ProcessMaker Forum | BPM Workflow Simplified

Posted: **Tue May 29, 2018 9:01 pm**

How to know that a task is subprocess in the APP_CACHE_VIEW table?
I want to select user tasks without considering subprocesses as tasks ...

Posted: **Wed May 30, 2018 1:04 pm**

You can do a join between the tables APP_CACHE_VIEW and PROCESS. There is a column in the PROCESS table to determine if the process is a subprocess or not.

Code: Select all

SELECT AC.* FROM APP_CACHE_VIEW AC INNER JOIN PROCESS P ON AC.PRO_UID=P.PRO_UID 
WHERE P.PRO_SUBPROCESS=0

ProcessMaker Forum | BPM Workflow Simplified

How to know that a task is subprocess in the APP_CACHE_VIEW table

How to know that a task is subprocess in the APP_CACHE_VIEW table

Re: How to know that a task is subprocess in the APP_CACHE_VIEW table