topic Re: How to find the count of workflows tagged for a district in Alteryx Server Discussions

How to find the count of workflows tagged for a district

swapnilhoderkar — Mon, 26 Oct 2020 03:58:59 GMT

Hi All,

I would like to find how many workflows are part of a specific district

When i look at a particular district to see how many workflows are tagged under it i am not able to see the entire list.

Is there a way through Gallery or building a workflow against Mongo DB to find total no of workflows per district.

Regards,

Swapnil

Re: How to find the count of workflows tagged for a district

joshuaburkhow — Mon, 26 Oct 2020 10:56:07 GMT

Hey @swapnilhoderkar

You might want to look in the 'districts' collection in AlteryxGallery of Mongo. I don't use them so don't have a reference.

Hope this helps!

Re: How to find the count of workflows tagged for a district

swapnilhoderkar — Fri, 30 Oct 2020 21:09:06 GMT

Thanks Josh. I will take a look at it and update here on my findings.

Re: How to find the count of workflows tagged for a district

BrianR — Mon, 02 Nov 2020 21:58:38 GMT

Using the districts and appInfos collections @joshuaburkhow mentioned, you can join on the TagIds.0 / TagId column, which are tied to Districts. Counting on the _id column should give you a count of workflows that are in a given District.