Click HERE to see how Saviynt Intelligence is transforming the industry. |
08/04/2024 04:44 AM
Need to configure RUN TIME ANALYTICS we are getting two inputs from users, START_DATE and END_DATE.
1. END_DATE - By default it should be current date, and it should be editable.
2.Difference between START_DATE and END_DATE should be less than or equal to 15 days. if user select more than 15 days it should throw an error.
We referred Saviynt and forum documents but couldn't find much information.
08/04/2024 07:44 AM
1. END_DATE - By default it should be current date, and it should be editable. - Keep default value as blank during configuration
2.Difference between START_DATE and END_DATE should be less than or equal to 15 days. if user select more than 15 days it should throw an error. - You need to show no records. You can’t show error messages on analytics
08/04/2024 10:14 AM
Difference between START_DATE and END_DATE should be less than or equal to 15 days. It's possible to configure this requirment in Run time.
08/04/2024 07:56 PM
08/04/2024 12:11 PM - edited 08/04/2024 12:11 PM
Hi @Akilan , you can add a condition
DATEDIFF(ENDDATE,STARTDATE) <=15
08/06/2024 01:27 AM
Hi,
Thanks for the inputs.
DATEDIFF(ENDDATE,STARTDATE) <=15 this is working for 15 days or less.
1. END_DATE - By default it should be current date, and it should be editable. I can't leave it empty ENDATE tab in runtime analytics.
2) Is it possible to configure STARTDATE is (ENDDATE-7 )days by default .For example ENDATE should be current date(6-Aug-2024) and STARTDATE should be (30-Jul-2024). If the user want to change the STARTDATE and ENDDATE its should be editable and maximum date range is 15 day.
Expected Result should be like this (ENDATE is Current date and STARTDATE is ENDDATE-7 days)
Expected result Date difference is 15 days max.
Regards,
Akilan.
cant leave box empty
08/06/2024 01:30 AM - edited 08/06/2024 01:30 AM
Hi @Akilan , can you add now() in default value
08/06/2024 01:50 AM
08/06/2024 06:09 AM
Default value is not supported for date