Create an interactive filter against a different field than the predefined table reference fields

[william1066]

Problem statement:

I need to be able to create an interactive filter on a column that is not the predefined table reference.

Is this possible?

[Mark Manders]

Can you explain your use case? You can dotwalk, so yes, it is possible, but without the exact thing you are looking for, it's just a theoretical 'yes you can'. 

[william1066]

Hi Mark,

More detail is probably needed.

l need to create an "interactive filter" based on "reference".  I am trying to do this via the UI, so not coding it. 

This filter is so that a specific control can be selected from the dropdown in a report.  The users are much more effective using a different display value than the default on the controls table (default display column is name) and we have a "control id" field that displays the code of the control.  The default "display" field for filters against the controls table is the name field.  Is it possible, somehow, to say that for this specific "interactive filter" not to use the default display field set on the data dictionary and use some other field for the display value?

We could change the default display field in the data dictionary for this table to the column we require, but that would likely have quite a widespread impact to OOB dashboards, and other forms.

William

[Mark Manders]

If you just are looking to change the way the filter is showing, the answer is: you need to change the display value on the table. There is no override for filters on this. On the other hand: if your users recognize this better with a different value, isn't that also the case on other records where this table is used? If 'name' is not clear enough in a filter, it probably also isn't clear enough on a ticket (or other dashboards).