If a column in a list view is from another table, I am not able to search the choice list however, I can do 'show Matching'

[minaz]

In my application, a couple of fields/columns are from a different table. When in List View, I see the values/data in those fields. But when I want to do a search using the List View Search, it yields NO data, however, I can do 'show Matching or Filter Out functions. Is there any way to have these two columns/fields do a search on its own table, sort of dot. walking?

[mayurt]

Hi Minaz,

yes we have to use dot walking for that,

consider an example if in an incident table i want a field from company i have to select company first and then again when i click on selected company i will get the field of company table so that i can select the required field from company table.

below thread will give you a clear idea:

Dot-walking in choice list fields

hope this helps

[minaz]

Thank you Mayur for your answer.

What you have described and what is in that document is about the SETUP or Configuration of a List View Column from a different table. All that is working fine. I have the required Column listed and I can also see the records from that field. My issue is when I do a search, it does not fetch the information. For example: my field name is State and it is from Asset.Server Tables. This column has about five choices. In Use, Retired, Decommissioned, etc. When I display the list view, it shows all the servers with their respective choice values, however, when I do a List View Search, it does not display any records.