Report filtering on RITM reference variables

[Nick Hynes]

I'm trying to create a report that is based on the variables in a RITM.  I can add the variables to the columns for the report fine, however I'm trying to apply filters to only show results with specific variable information.

Unfortunately, because the variable is a reference type (to the user table) it seems that you can only filter using the SysID of the records you're searching for rather than the display value.  Is there any way around this?  Ideally we want to make this an Interactive Filter.

[Voona Rohila]

Hi Nick

Can you share what have you tried/issue you are facing?

sample filter:(manager is referred to user table)

[Nick Hynes]

Thanks Rohila

This the is the report showing the correct variable

But if I want to filter I can't search by the user name

Only sysid works

[Ankur Bawiskar]

@Nick Hynes 

why not use IS in the operator?

Regards
Ankur

[Nick Hynes]

IS is not available only Contains, Does not contain, Is empty, Is not empty

Maybe this is because the variable is a list collector allowing for multiple choices?