I'm trying to create a report that has the following for each workflow:
I'm querying AlteryxGallery.appInfos to get each workflow's info. I know how to join user, so the "who" piece of each one I can do.
What I'm having problems with is understanding the various date fields: PublishedRevision.DateCreated, Revision.0.DateCreated, Revision.1.DateCreated, Revision.2.DateCreated, etc...
PublishedRevision.UploadDate, Revision.0.UploadDate, Revision.1.UploadDate, Revision.2.UploadDate, etc...
I would have thought the following would be the way to understand the Revision # logic:
"Published" would be the most current workflow and each Revision # is chronological with 0 being the first revision, 1 being the 2nd, so on and so forth.
However, I'm finding this is not the case. I have workflows where Revision 0 Date is AFTER Revision 1 and Revision 1 date = Published Revision date and Revision 2 date is AFTER Revision 3 date and Revision 5 date is AFTER Published Revision date.
I don't necessarily need a workflow to do this for me, but I would definitely appreciate if somebody could explain the logic to me of the "Published Revision" and "Revision.#" date fields
Hi @csh8428 - For each field definition refer to the MongoDB Scheme help here...
https://help.alteryx.com/20212/server/alteryxgallery-mongodb-schema
In regards to the Version History and aligning the date's this will be in reference to published versions versus revisions. See the article below for help.
https://help.alteryx.com/20204/server/workflow-version-history