for $wf in collection('/db/DRIVER/wf/simple')[.//RESOURCE_IDENTIFIER/@value='@wfId@']/RESOURCE_PROFILE
for $x in $wf//NODE[@type='LaunchWorkflow']
for $y in collection('/db/DRIVER/wf/simple')[.//RESOURCE_IDENTIFIER/@value = $x//PARAM[@name='wfId']/@value]
return
{$x//PARAM[@name='wfId']/@value/string()}
{$x/@name/string()}
{$x/DESCRIPTION/text()}
{$y//LAST_EXECUTION_DATE/string()}
{$y//LAST_EXECUTION_STATUS/string()}
{$y//CONFIGURATION/@start="DISABLED" or $y//CONFIGURATION/@status !="EXECUTABLE"}
false
{$wf//RESOURCE_IDENTIFIER/@value/string()}
,
for $wf in collection('/db/DRIVER/wf/simple')[.//RESOURCE_IDENTIFIER/@value='@wfId@']/RESOURCE_PROFILE
for $x in $wf//NODE[@type='LaunchWorkflowTemplate']
return
{$x//PARAM[@name='wfTemplateId']/@value/string()}
{$x/@name/string()}
{$x/DESCRIPTION/text()}
{$wf//CONFIGURATION/@status != 'EXECUTABLE' or $wf//CONFIGURATION/@start = 'DISABLED'}
true
{$wf//RESOURCE_IDENTIFIER/@value/string()}