nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Need a Livereport that finds attachments of a workflow, based on wf attributes

Chris_de_Boer_(cdeboer_-_(deleted))

I'm looking for a way to find documents which are attached to workflows, based on the attribute values of that workflow.We are scanning documents and then put them in a workflow. The workflow has a number of attributes (needed for proper routing). When the workflow has finished, I need to find the attached documents, by entering a (wf)attibute value in a LiveReport (or any other way if possible).(Another solution is copying the wf-attribute values to the document-attributes at the end of the workflow. Is this possible?)Has anyone done this?Thanks !

Find more posts tagged with

Comments

Chris_de_Boer_(cdeboer_-_(deleted))

I have to clean up the SQL, but it is something like:select * from dtree where parentid IN (select data_userdata from wdata where data_workid IN (select subwork_workid from wsubwork where subwork_subworkid IN (select wf_id from wfattrdata where wf_valstr = %1))and data_subtype = 1)