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

csh8428 — Tue, 15 Mar 2022 17:55:37 GMT

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

When/who uploaded it initially
Who is the author of the current published revision
What is the current Deletion status
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

Re: Help with simple MongoDB report - When/who uploaded each workflow, current author/stat

JeffK — Mon, 28 Mar 2022 14:49:35 GMT

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

topic Help with simple MongoDB report - When/who uploaded each workflow, current author/status in Alteryx Server Discussions

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

Re: Help with simple MongoDB report - When/who uploaded each workflow, current author/stat