One of our objectives is to be able to report on when our licenses/warranties are nearing expiration. How do you configure the filters/alerts to trigger when a license is nearing it's end date in the asset management module? I see options for > & <, and this will work for an individual report where you specify the date, but in order to configure an alert,the system needs to take a difference between today's date and the expiration date.
0 Comments   [ + ] Show Comments

Comments

Please log in to comment

Rating comments in this legacy AppDeploy message board thread won't reorder them,
so that the conversation will remain readable.

Answers

0
So, it looks like I should be able to use a system variable, like $DATE. This shows up properly in the filter, but if I try to put something like $DATE + 60 or $DATE -d "60 days" the filter ignores the modification of the variable. What is the syntax to allow for variable modification in the filter dialogs?
Answered 08/13/2009 by: Thaiguy78
Senior Yellow Belt

Please log in to comment
0
You will have to manually edit the SQL with the MySQL functions date functions to get this to work correctly:


http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html


What I do is setup the filter using the normal drop-downs first to get everything working correctly expect the date and then modify the SQL under the Reports tab.


The main ones to use are:

CURDATE(), DATE_ADD(), and DATE_SUB()

Here is an example to limit the filter to only items that are older than 2 weeks old:

DATE_SUB(CURDATE(), INTERVAL 14 DAY)
Answered 08/27/2009 by: Thomas.Babcock
Blue Belt

Please log in to comment
0

I had done this by the follwing  way.

 

1. Click Reporting 

2.Select Classic report

3. Create new report 

In the reports craetion wizard you can set the rules accoding your condition.

please find the attached image

 

Answered 04/14/2014 by: itsuman
White Belt

Please log in to comment
0

Answered 04/14/2014 by: itsuman
White Belt

Please log in to comment
Answer this question or Comment on this question for clarity