Home > Forum > General > Bugs in default filtering of dashboard reports

Bugs in default filtering of dashboard reports

0

23.03.2026

10:49

Hi,

I've suffixed processes that contain a workflow with a cyclical on start global action with " [JOB]". To get an overview of all process planed as a job I've created a dictionary report in a dashboard and want to filter the column "Process Name" with a default filter.

Now I have 3 different behaviors:
- Using "[JOB]" returns all processes in the list without any filtering > This seems to be a bug imho. (screenshot)
- Using "JOB" returns only the expected processes containing JOB > This works fine for the filter but the list could also contain processes that don't contain [JOB] with brackets. (screenshot)
- Using " JOB" (with trailing" space returns an empty list > This seems to be a bug imho. (not in the screenshot)

I didn't test this behavior in BPS internal views and the "old" reports yet. Used version is 2025.2.1.179.

Kind regards
Sébastien

PS: A new Thread Categoy "Portal" or "Dashboards" would be nice.

23.03.2026

14:06

Hi Sebastien,
This is probably because MS SQL treats [] as wildcard characters: https://learn.microsoft.com/en-us/dotnet/framework/data/adonet/ef/language-reference/like-entity-sql#

A workaround is to use the SQL filter: >Your column< like '%![JOB!]%' escape '!'

Regards,
Jacek

Solution (1)

Helpful (0)

Wrong answer (0)

23.03.2026

15:35

In reply to: Jacek Wojnar

Hi Jacek,

thank you for the hint! I expected that WEBCON escapes the query already.

I put the SQL filter to the dashboard's data source. Both methods work like a charm:

##
AND WFD_AttText1 LIKE '%![JOB!]%' ESCAPE '!'
##

and

##
AND WFD_AttText1 LIKE '%[[]JOB]%'
##

Kind regards
Sébastien

Solution (0)

Helpful (0)

Wrong answer (0)

23.03.2026

15:40

In reply to: Sébastien Anselment

I was also surprised that it didn't work by default ;)

In your case, you need to add "ESCAPE '!'" at the end.

Try:

AND WFD_AttText1 LIKE '%![JOB!]' ESCAPE '!'

Solution (0)

Helpful (0)

Wrong answer (0)

23.03.2026

15:42

In reply to: Jacek Wojnar

I was also surprised that it didn't work by default ;)

In your case, you need to add "ESCAPE '!'" at the end.

Try:

AND WFD_AttText1 LIKE '%![JOB!]' ESCAPE '!'

Hi,

yes I've seen that I missed the ESCAPE part. I've updated my previous message with a 2nd working method.

Kind regards
Sébastien

Solution (0)

Helpful (0)

Wrong answer (0)