How to add Next 30, 60, 90 days options to Interactive Filter?

Harry Smith · ‎06-19-2020

Hi Everyone,

I have setup an interactive filter which affects a report displaying device's warranty expiration dates, however I want it to be able to filter this report by devices that expire in the Next 30, 60, and 90 days. I have the option for Next Month so really it's just adding the 60 and 90 days filter, how can I do this?

Many Thanks,

Harry Smith

Harry Smith · ‎07-06-2020

Hi All,

I've found the solution to my problem,

It requires editing the script in the BR "Get Date Filter Options for Date Filters" by adding the below lines:

answer.add('180_Next 3 months@javascript:gs.monthsAgoStart(-0)@javascript:gs.monthsAgoEnd(-3)', gs.getMessage('Next 3 months'));
answer.add('185_Next 6 months@javascript:gs.monthsAgoStart(-0)@javascript:gs.monthsAgoEnd(-6)', gs.getMessage('Next 6 months'));
answer.add('190_Next 9 months@javascript:gs.monthsAgoStart(-0)@javascript:gs.monthsAgoEnd(-9)', gs.getMessage('Next 9 months'));

Thanks everyone for you suggestions!

Cheers,

Harry Smith

View solution in original post

Ishita Shrivast · ‎06-19-2020

Hi Harry, I am adding 2 screenshots for your reference, try giving condition like this. Hope this helps. Please mark it as helpful and correct, if applicable.

Thanks and regards,

Ishita Shrivastava.

Harry Smith · ‎06-22-2020

Hi Ishita,

Thank you for the suggestion,

The issue I'm facing is more that I want to be able to add the next 60/90 days to the interactive filter so the client can easily change how far the warranty report is looking into the future rather than on the report level where some users don't have access to amend this.

Do you have any suggestions?

Many Thanks,

Harry Smith

Deepen Shah · ‎06-19-2020

Hello Harry,

You need to create the filter with 'AND' condition like this,

Please mark this correct and helpful if this works for you.

Thanks

Deepen Shah

aavenir.com

Harry Smith · ‎06-22-2020

Hi Deepen,

Thank you for the suggestion,

The issue I'm facing is more that I want to be able to add the next 60/90 days to the interactive filter so the client can easily change how far the warranty report is looking into the future rather than on the report level where some users don't have access to amend this.

Do you have any suggestions?

Many Thanks,

Harry Smith