With the introduction of multi-doc workflows, we noticed how the multi-doc task data is, in some cases, stored in different fields than standard workflow tasks.
For standard workflows, the following fields are set or blank:
For multi-document workflows, the following fields are set or blank
We've built a simple ETL tool to enable some custom reporting we can't get via the UI. This inconsistent data model causes us issues as we now have to look at the workflow type to determine which fields we care about. It's not hard to do, but it creates work for us on our end to re-align the data for our reporting purposes.
While we suspect that this is to ensure backwards compatibility, can we request that the fields be merged (or perhaps the values echoed into new task-level fields) so that a single query can pull back the same info from the same field for both standard and multi-document workflow tasks? If the legacy fields need to live on and continue to be populated for standard workflows, that's fine. In our scenario, we'd simply ignore them. We believe this consistency will also make things easier for the the Vault reporting tools within the UI.
Here's a proposal for some standardized workflow tasks fields:
task_document_id__v <--- this field doesn't exist, but the "task_" prefix better aligns with the rest of the fields introduced with the multi-doc workflow changes
task_document_verdict__v <--- this field doesn't exist, but the "task_document_" prefix better reflects the scope of the verdict value
Legacy fields that can live on for backwards compatibility reasons:
Let us know your thoughts. Thanks for considering our perspective as a customer who's looking for the simplest way to consume the data being generated by Vault.