I have a view which has several fields. Also, I have a couple other fields in the view from a related (foreign) table.
I notice in general, it appears if I sort by a column in the main table that the filter criteria filters by that column.
For example, if I have a Name column (and sort by that one) in the main table with three names: John, Larry and Susan, if I type in an L in the main Search this view area or click on the letter L in the alphabet bar, it will filter the results to show me only Larry.
Let's say there is a foreign table associated with an ID. On that foreign table is something like Customer Location. Let's say John is Denver, Larry is Minneapolis and Susan is Phoenix.
I can have the view set so it would display those as well. In this scenario, I can click on Customer Location and it would sort as expected.
However, now if I would try to do something like search for D, it wouldn't find Denver or if I searched for M it wouldn't find Minneapolis.
What it appears to do is filter off the primary key on the main table in these types of scenarios instead.
Is there a way to override or apply some custom logic (maybe addCustomView??) so that the main search area is tied into a related (foreign) field?
In one article I found, there is mention of an out of the box js file called formcontrol.js with a parameter called requireSortResults. Sounds like this is set to true by default and may be part of the reason why sorting seems to happen on the primary field instead of foreign fields.
Any suggestions or tips?
I am running 2020 release wave 1 - Version 1710 (9.1.0.18353) online
