Hi,
I am trying to create a report which pull the review definition scheduled weekly. But I am not able to find the frequency/schedule in review type report. Also I am not able to find the same from backend. Could you please help with either query to create report which pulls review running weekly or the place where I can find frequency of a particular review.
Aveksa version is 6.9.1.
Thanks.
Hi,
it takes courage. But it can be done. You need to parse the NVCHAR2 field RULE of T_SCHEDULED_TASKS for all OBJECT_CLASS_NAME = 'com.avkesa.review.ReviewReportTask'.
The RULE column contains basically crontab in XML. to parse XMLTABLE is your friend.
To reliable get the Review Definition ID you then need to join in T_SCHEDULED_TASK_PROPERTIES via T_SCHEDULED_TASKS.ID = T_SCHEDULED_TASK_PROPERTIES. the column PROPERTY_VALUE is then your review ID (keep joining until you have what you want...).
Frank