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
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