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 ChristineH
Certified Lead Developer
over 7 years ago

I believe that content is stored in the kx (in memory) database and not the primary.

Can you expand on your use case? If you use an Appian task report and use a SAIL component to query the process analytics, what will that not provide that a view will give you?

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ChristineH
Certified Lead Developer
over 7 years ago

I believe that content is stored in the kx (in memory) database and not the primary.

Can you expand on your use case? If you use an Appian task report and use a SAIL component to query the process analytics, what will that not provide that a view will give you?

Thanks
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data