Query Primary Data Source For Task Details

subhankarb over 7 years ago

We have a requirement where we need to expose the task details through a Database View.
Can we get the following informations: Task name, Task Assignee, Assigned date time, accepted date time & Process model Name from our Primary Database?

I am aware of the alternatives like "Execute Process Report" smart service and save the details in the database as a scheduler process. In my opinion this will impact the performance of the system and will not have the latest details as this will be a scheduler.

Kindly let me know if we can achieve it using some "GRANT" access to primary database ?

Discussion posts and replies are publicly visible

Parents

0 kondetiv over 7 years ago

@subhankarb as suggested by christineh we have achieve the same thing by using a!queryProcessAnayltics() function. It doesn't impact the performance. And more over don't touch the primary database as it is not recommended by Appian. For more information about how to use a!queryProcessAnayltics() function please follow the below links.

https://forum.appian.com/suite/help/16.2/Task_Report_Tutorial.html

https://forum.appian.com/suite/help/16.2/System_Functions.html#a-queryprocessanalytics

https://forum.appian.com/suite/help/16.2/SAIL_Recipes.html#Display_a_Users_Tasks_in_a_Grid_With_Task_List

https://forum.appian.com/suite/help/16.2/SAIL_Recipes.html#Display_Processes_by_Process_Model_with_Status_Icons

https://forum.appian.com/suite/help/16.2/Process_Reports.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 kondetiv over 7 years ago

@subhankarb as suggested by christineh we have achieve the same thing by using a!queryProcessAnayltics() function. It doesn't impact the performance. And more over don't touch the primary database as it is not recommended by Appian. For more information about how to use a!queryProcessAnayltics() function please follow the below links.

https://forum.appian.com/suite/help/16.2/Task_Report_Tutorial.html

https://forum.appian.com/suite/help/16.2/System_Functions.html#a-queryprocessanalytics

https://forum.appian.com/suite/help/16.2/SAIL_Recipes.html#Display_a_Users_Tasks_in_a_Grid_With_Task_List

https://forum.appian.com/suite/help/16.2/SAIL_Recipes.html#Display_Processes_by_Process_Model_with_Status_Icons

https://forum.appian.com/suite/help/16.2/Process_Reports.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data