Generate a list of workflow in each collection

[bsk_93]

Hi All, 

I'm looking to generate a list of workflow in each collection level. 

How to generate and what is the process to create a workflow?

[Yoshiro_Fujimori]

Assuming you are referring to Collections on Alteryx Gallery,

you can get the information from MongoDB of your server via MongoDB Input Tool.

You can find the schema here: 

https://help.alteryx.com/20231/en/server/configure/mongodb-management/mongodb-schema-reference/alter...

The information of workflows is stored as below:

Apps: (Array) Array of info on all workflows in the collection.

• ApplicationId: (String) Workflow ID.

• DateAdded: (Date) Date-time (UTC) workflow was added to the collection.

• AddedById: (String) User ID for the user that added the workflow to the collection.

You may need to join with other MongoDB collections (e.g. "appInfos") to get workflow name and other information, depending on your needs.

I hope this helps.

[bsk_93]

Thank you  Yoshiro_Fujimori

Current version 2024.1

I did the same thing utilized the MongoDB Input tools, transpose , joins and select tools. But I'm not gettig the accurate data. when i connect Collection, appInfo

Here is details of each tools that utilized on Alteryx Workflow.

MongoDB Input Tool: Taken input as collection, appInfo

transpose tool: Name contains Application ID

Joins( 2Joins used) One is connected from collection MongoDB Input Tool and second one connected from appinfo. Join common.

But here i;m not getting the exact result that what i;'m seeing on Alteyx gallery. 

If you don't mind can you provide me the workflow from your end