How to add module filter condition relating to a dot-walking column?

Yu_G
Tera Contributor

Hi everyone,

 

I have some problems adding  a dot-walking column as the module filter condition.

Details are as follows.

 

There is a module of records of a database table.

The database table is a combination of Table A and Table B.

Column [X] is a reference column of Table B (Reference table is called Table C).

And there is a True/False column [Y] in Table C.

 

Now what I want to do is to add column[Y] to the module filter condition setting. However, I cannot find it among the selectable options. The only thing I can choose is column [X].

 

Anyone with good ideas?

Thank you very much.

1 REPLY 1

Mark Manders
Mega Patron

It depends on what you are doing. Is it already a database view or not? 

 

What you are describing is very cryptic, so I am unsure what exactly isn't working. If I follow your example I am creating a list view on the Incident table (Table A that has the 'caller' field as reference to Table B (sys_user) and I can simply dotwalk to caller.location = xyz). There is no need for a database view, everything shows on my list.

 

But if it is a database view you created between two tables, you don't have access to the referenced tables from either one of them. You are just combining the data from two tables. If you need that 3rd table to filter on, you will have to add it to the database view (in my example, add the cmn_location table to the database view of incident and sys_user).


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark