Jazz Forum Welcome to the Jazz Community Forum Connect and collaborate with IBM Engineering experts and users

Is there a way to run a report that will show a calculated value for number of days until the expiration date (ie. the difference between the current date and the expiration date)?

I am working on a license management project in RTC and I would like to show the number of days before a license expires.  I wrote a calculated value script that will calculate the number of days between the current date and the expiration date of our licenses using "var day = dojo.date.difference(currDate, expDate, "day");".  The script works fine to update the "Expires in" attribute with the number of days until the license expires; however, I found that this attribute will not update daily, so it only gets updated to the correct value when you change and save the work item.

After searching on jazz.net, it appears that the best way to accomplish this is to run a report, but I am not able to figure out how to do that.  I have been able to run a query that shows the licenses with an expiration date that is within 6 months.  In that query, I can show the expiration date attribute.  However, I would really like to have a numeric value that states the number of days before the license expires.  I was hoping that there was a way to do this in JRS, but have not found a solution.  We are currently running version 6.0.3.

Is there any way to run a report that will show me the number of days until the expiration date?

Thanks!

0 votes

Comments

I would assume the correct question is rather how to create a calculated column in a report to show that value. I don't know, but I would suggest you reword the subject and the question itself t reflect that.



One answer

Permanent link

Hi Janet,

Assuming you are using data warehouse for JRS, you can modify the SQL query directly in Advanced tab. Use timestampdiff (DB2) or datadiff (SQL Server) function to calculate the number of days. If you have a problem, engage the database specialist.

0 votes

Your answer

Register or log in to post your answer.

Dashboards and work items are no longer publicly available, so some links may be invalid. We now provide similar information through other means. Learn more here.

Search context
Follow this question

By Email: 

Once you sign in you will be able to subscribe for any updates here.

By RSS:

Answers
Answers and Comments
Question details
× 6,122
× 19

Question asked: Dec 29 '17, 12:07 p.m.

Question was seen: 2,470 times

Last updated: Jan 03 '18, 6:53 p.m.

Confirmation Cancel Confirm