Other fields not showing in interactive filter

oww15
Tera Contributor

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!

 

1 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. 

 

AndersBGS_1-1694085028640.png

 

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

 

Best regards

Anders

If my answer has helped with your question, please mark my answer as the accepted solution and give a thumbs up.

Best regards
Anders

Rising star 2024
MVP 2025
linkedIn: https://www.linkedin.com/in/andersskovbjerg/

View solution in original post

5 REPLIES 5

oww15
Tera Contributor

Thank you @AndersBGS