Help with simple MongoDB report - When/who uploaded each workflow, current author/status

[csh8428]

I'm trying to create a report that has the following for each workflow:

1. When/who uploaded it initially
2. Who is the author of the current published revision
3. What is the current Deletion status
4. When was it deleted if it was deleted.

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

[JeffK]

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