Home > Forum > Tips&Tricks > Filter report current user

Filter report current user

0

MariaM

14.03.2024

16:50

MariaM

Hello,

I have 2 form fields - Person (Assignee, Manager)
I would like to create a report and filter that report based on these 2 columns. It is working fine, until Assignee/Manager is multiple value. If there are 2 persons assigned, it doesn't bring that instance in the report.

This is my formula (SQL filter):

and (WFD_AttChoose1 like trim('##currentloginname## ' )+'#%' OR WFD_AttChoose6 like trim('##currentloginname## ' )+'#%')

Do you have any tips? Thank you.

14.03.2024

20:31

HI Maria,

if you have a multiple value field the values will look like:

a) id1#displayname
b) id2#displayname;id1#displayname
c) id2#displayname;id1#displayname;id1#displayname

It should be possible to always filter for id1 by adding a ; in the beginning, so that you could filter for %;id1#.

Therefore something like this should work, or at least point you in the right direction. I haven't tested it.
and (';'+WFD_AttChoose1 like '%;'+trim('##currentloginname## ' )+'#%' OR ';'+WFD_AttChoose6 like '%;'+trim('##currentloginname## ' )+'#%')

Best regards,
Daniel

Solution (1)

Helpful (0)

Wrong answer (0)