Hi! I'm looking for best practices on using the Gallery, Studios and Collections.
1) Can you track where you've previously shared a workflow from your Private Studio and out to multiple Collections? How do you know which collections include one of your workflows?
2) If a workflow is broken or providing incorrect results, how do I take it "offline" for fixing? If it's share in multiple collections, do I have to go to each collection and delete it? Can I unable the run / download for workflows that are in development or being fixed?
Thanks!
The Server Usage Report may be helpful. It is available for download at downloads.alteryx.com in the Server tab.
Also, you can connect to the Gallery's Mongo database either using the MongoDB Tools in the Connectors toolbar or Robo 3T, a free application for Mongo administration tasks https://robomongo.org/download.
The database has collections instead of tables. There is an appInfos collection with details about all the workflows in the database, including the revision number. Also, there a collection called collections. Details are available only about the current state of a collection. You search can all collections at once for a workflow name.
To access the Mongo database, you will first need to open the System Settings on the Server. On the Controller Persistence tab, make a note of the hostname, username, and password. Be sure to use the Password field and not the Admin Password for authentication.
Using Manual Mode in the MongoDB Input Tool, you can select the Scan button to show all columns and add filter criteria, or filter in the workflow.
Robo 3T connection
In Robo 3T, after selecting a collection, put the search term between the find brackets.
FYI I've proposed the following in the Server Ideas, I couldn't seen anything relevant already there.