Where are the task details for workspace queues stored in Adobe LiveCycle ES database?

[Jaison_Sunny]

where are the task details for workspace queues stored in Adobe LiveCycle ES database?

Hi,

Where are the task details for workspace queues stored in Adobe LiveCycle ES database?

What are the tables which are affected in Adobe LiveCycle ES when a task is created?

How can i view the task Id, process ID, status from Adobe LiveCycle ES Database?

Thanks for reply,

Jaison

[John-Conner]

the task details you can get from the table tb_task.

the relation of task id and process id you can get from table tb_task and tb_process_instance.

I hope this suggestion can help you.

[Jaison_Sunny]

Are there any stored procedures that are used to update these tables?

[Jasmin_Charbonn]

Unfortunately there isn't any stored procedure to update these tables.

Also be aware that modifying these tables is not supported by Adobe.

Jasmin

[neu_pro]

As a consequence for this question, how can i remove the tracking history records as there is no UI in the admin console nor an external tool or Java API for removing the tracking processes and tasks.