Other fields not showing in interactive filter

[oww15]

Hi all, 

I have a requirement wherein I need to get a specific field from the database view. The field can be filtered using dot walking through Parent field ---> Business Unit in the database view table. But is not visible when locating in the reference field for the interactive filter. What could be the reason? Thank you!

[AndersBGS]

Hi @oww15 ,

Do you refer to the interactive filter references list? If yes, can you please share your interactive filter configuration together with your configuration from the related list "interactive filter reference"? By doing this, it will be much easier to help you.

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[oww15]

Hi @AndersBGS , this is the interactive filter reference fields. I am trying to map via parent (demand) but the business unit is not visible. Thanks!

[AndersBGS · Accepted solution]

Hi @oww15 ,

As demand parent.parent refers to task table, and there is no reference from task table to demand, there is currently no solution OOTB. To make a solution, you need to create a new field on the demand table which refer the demand table again. By doing this, you could create an interactive filter reference the business unit on the parent table. 

if my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.

Best regards

Anders

[AndersBGS]

Hi @oww15 ,

if my answer has helped with your question, please mark my answer as accepted solution.

Best regards

Anders