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 

[ch_venkata]

Hi ,

Please find the attached workflow to fetch details like workflows per collection + collection owners etc.

[mamtaban]

To create a workflow for each level, first figure out the different levels, then decide what need to happen at each level. Lists the steps, put them in order and decide who does what. You can use a simple tool like Excel or Notion to organize it. Test it on a small project, and then write it down clearly so everyone  knows the steps and who is responsible.