Filtering data in report widget, on date column

[vinod...@gmail.com]

Hi

I am trying to filter report widget on date column. When I try to filter based on your input it is filtering out everything. I have attached screenshots with and without filter (clear filter is working but not add filter.

Request help; thanks in advance

Regards

Vinod

[Bidisha Das]

Hi,

The code you are implementing will filter report based on your Action Date already present in report and will give you the records where Action Date is greater than the "From" date entered by you.So, make sure you are using correct variable names in the code.

For ex:Make sure the "actiondate" you have used in code is the value variable/property name in report.

Don't use addFilter & clearFilter at the same time. 

I have tested the functionality with Process report and its working fine for me.

Thanks & Regards

Bidisha

[vinod...@gmail.com]

Hi Bidisha

Thanks for the support.

I had used clear filter only to remove filter and I comment it out when I try to set filter.

I have tried it again and it does not seem to work.

Script I am using is below:
date1=id_fromdatenum.getDate();
id_reminders.addFilter("actiondate", RMP_FilterOperator.GREATER_THAN, date1);
id_reminders.refresh();

Column name 'actiondate' I have taken from property in widget only. (screenshot attached).

Am I missing something? Request help

Regards


Vinod

[Murali]

Hi Vinod,

Unfortunately, we are not allowed to fix the code that is specific to application requirement.

Please refer to below resolved posts for the suggestions made around implementing report filter.

Solutions Ref:
https://groups.google.com/a/runmyprocess.com/forum/#!msg/supportforum/j1vi9hYIOlw/cx9Mjb1e1wIJ
https://groups.google.com/a/runmyprocess.com/forum/#!msg/supportforum/L7JeOl_54YQ/0YIwweeH5bEJ
https://groups.google.com/a/runmyprocess.com/forum/#!msg/supportforum/jqSu9hUc6SI/urj-EpoKp8MJ
https://groups.google.com/a/runmyprocess.com/forum/#!topicsearchin/supportforum/RMP_FilterOperator/supportforum/jqSu9hUc6SI

User-guide Ref:
https://docs.runmyprocess.com/Developer_Guide/Collection/Collections_BackOffice
https://docs.runmyprocess.com/API_Reference/FM/Utilities.html#get_time
https://docs.runmyprocess.com/Developer_Guide/Web_Interface/JS_Code_Examples/Date

Regards,
Murali
Fujitsu RunMyProcess Support

[vinod...@gmail.com]

Thanks a lot, Murali. Links helped.