Posted Tue, 14 Dec 2021 15:15:40 GMT by Micheal Carolissen
Hi is there an option in the BPA SQL database that indicates whether any construct is enabled/disabled. 

the AutomateConstruct table has the enabled field, but when filtering this to enabled ~ false, it only reflect resource type 3 which refers to workflows that are disabled even though there are tasks/conditions/folders that are disabled as well

Posted Thu, 30 Jun 2022 12:50:34 GMT by Amy Knode
Hi Micheal,<br> &nbsp;<br> The data you are looking for is stored in the workflowitemconstructs table.&nbsp; You will first need to determine the workflow resource id from automateconstruct and then you can filter on that to find the record in&nbsp;workflowitemconstructs.&nbsp; You will likely see multiple records returned.&nbsp; The construct type is 2 for tasks and you can see there is a column for Enabled.&nbsp;&nbsp;<br> &nbsp;<br> Let me know if you have any questions.<br> &nbsp;<br> Thanks,<br> &nbsp;<br> Amy

You must be signed in to post in this forum.