There are certain events that happen as part of a Workflow - example, person X signed off, Approvals are completed, rejections, etc that need to be part of a query on the content itself. Example: Get all specs that were approved by a person between x and y dates. Given that content model and workflow events are separate entities how are companies handling such queries? Please note that good performance is expected while performing such queries.
Most of the time (95-98%) companies are not handling this at all. Workflow data is only transient data and normally not relevant for long term / export. If workflow properties are relevant, then the workflow should contain logic that sets the relevant metadata on the document itself, so that there is a clean separation between transient data (workflow-only metadata) and relevant data (metadata on affected nodes). That way you can query for the relevant data / nodes like you query for any node - with the Alfresco search functionality, i.e. SOLR and/or transactional metadata queries.
Ask for and offer help to other Alfresco Content Services Users and members of the Alfresco team.
Related links:
By using this site, you are agreeing to allow us to collect and use cookies as outlined in Alfresco’s Cookie Statement and Terms of Use (and you have a legitimate interest in Alfresco and our products, authorizing us to contact you in such methods). If you are not ok with these terms, please do not use this website.