topic Re: CONTAINS or OR condition in URL filters in Report Server

CONTAINS or OR condition in URL filters

vickyd — Fri, 21 Sep 2018 12:11:53 GMT

I have a report to show list of employees. Each employee has a manager, the manager in turn has a manager and so on till the CEO i.e. a typical Org hierarchy.

I want to be able to pass a URL filter with an employee id and then show all employees that report to that employee i.e. everyone below him/her.

For each employee record, I already have fields like L1 Manager, L2 Manager where L1 manager = CEO, L2 is the next level and so on.

So URL filter would be something like

https://ReportURL?filter=Employee/L0ManagerID eq '123456' OR Employee/L1ManagerID eq '123456' OR Employee/L3ManagerID eq '123456' OR Employee/L4ManagerID eq '123456'

I can create a column called ManagerIDs which would be a concatenation of L0ManagerID, L1ManagerID, L2ManagerID and so on and then pass a URL like

https://ReportURL?filter=Employee/ManagerIDs CONTAINS '123456'

Looks like neither OR or CONTAINS is supported in URL filters though.

If that is correct, is there any other way I can achieve what I'm looking for?

Re: CONTAINS or OR condition in URL filters

Greg_Deckler — Fri, 21 Sep 2018 13:22:18 GMT

I believe that "in" is CONTAINS. I don't see an or which is odd since and is supported.

https://docs.microsoft.com/en-us/power-bi/service-url-filters

Re: CONTAINS or OR condition in URL filters

vickyd — Fri, 21 Sep 2018 13:38:22 GMT

Greg_Deckler wrote:
I believe that "in" is CONTAINS. I don't see an or which is odd since and is supported.

https://docs.microsoft.com/en-us/power-bi/service-url-filters

IN is more of search one column for on of the values in the list. What I need is more of the SQL LIKE search e.g. ManagerIDs LIKE '%12345%'.

I just used the word contains because Power BI filters uses the word contains.

Re: CONTAINS or OR condition in URL filters

DJTentman — Tue, 25 Oct 2022 18:14:59 GMT

I'm looking for the same thing. Four years later and it's still not available.

Re: CONTAINS or OR condition in URL filters

AndreasLanger — Thu, 02 Mar 2023 10:41:33 GMT

Same for me, found still no way to filter with "contain" method similar to normal report filters. Have you found out any workarrounds?