This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
How do I differentiate between workflows which are not uploaded to gallery and those that are present in the gallery?
How can I know which user uploaded or Scheduled the workflow from the long id field?
More often we are seeing this question get asked and although is a simple answer is not apparent to users how simple it is to find the answer.
Open Designer and go to Options > View Schedules
If the field contains the long number which is the mongo_id then it means it’s on the Gallery. Otherwise if it has your name it’s not.
Furthermore you may want to know which user the mongo_id corresponds to. If so you have the option to connect to Mongo from the Designer:
Connect to Mongo using the MongoDB Input Tool. You will need your Alteryx System Settings to do so:
Further to the Server name, user and Password you will also need to connect to the AlteryxGallery database and Users Collection:
Make sure to Include Mongo_id Field from the Connection options.
Using the Select Tool you may modify your results to remove unnecessary fields for Analysis. The _id field reflects the Mongo_id column from the "Uploaded By" column from the View Schedules windows on Designer.