Can I filter Area Path before start loading ?

[helenoalves]

First of all thank you for your amazing work.

On the context that I`m working I have one project and a lot of area paths. I would like to filter the area paths in the initial wizard before loading all data. It will make the tool more usable on my context.
I created my own version of Ageing Chart, and some Control Chart based on Azure DevOps Analitics Views, but I would like to try FlowViz, but I need a pre filter on area path to avoid loading all org data.

Best Regards

[nbrown02]

Thanks for the kind words @helenoalves :)

That's a good question - I know it can be done within the OData queries, however I'm not sure how it would be able to be handled from a parameters perspective. For example if users were to leave the parameter for area path as blank, I think the query may fail...but let me do some digging and get back to you 👍

[nbrown02]

I just did a quick test using my dummy project:

• Test to see if queries by area path work (where TestArea would be a parameter users would enter)

  https://analytics.dev.azure.com/n123btesting/FlowViz/_odata/v3.0-preview/WorkItems? 
$filter=StateCategory ne 'Completed'
            and startswith(Area/AreaPath,'TestArea')

This works, so we know we can filter by AreaPath in our queries

• Test to see if users did not enter an Area Path what would happen

  https://analytics.dev.azure.com/n123btesting/FlowViz/_odata/v3.0-preview/WorkItems? 
$filter=StateCategory ne 'Completed'
            and startswith(Area/AreaPath,'')

This also works - so this looks like it can be done!

[nbrown02]

I would need to have Area Path as an optional parameter for users to enter. Let me do some proper tests and then we can get it up and running :)

[nbrown02]

So after some further research, doesn't look like this is possible 👎

It works fine when you have an Area Path

However when you leave it blank, it creates issues:

Any ideas?

[helenoalves]

Hi @nbrown02,

I did this way:

1. I created one new parameter with default value %20:

2. And I changed every odata query putting the filter as the second part:

It seems to be ok !
In my context I have more than one AreaPath to include :)
Thank you for your support.

[nbrown02]

Amazing! Great stuff 🙂