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()}