NW base table fields might be restricted to “typeahead only”. This restricts the lookup fields to Primary and Secondary on the application. I would like to override this typeahead only field via extensions to have access to additional related fields from the lookup. Is this possible?
The use case being that we want to search/filter all contacts by what will be written on the check. Either “Write Check To” or ”Pay to the Order of” fields. Many tables/applications have the contacts as ‘Typeahead only’. Maybe there is an alternative to the original proposed idea?
You can use Advanced Filtering to search by other fields, but it does add a few more clicks.
For example, if I open Sales Orders > Add detail or edit detail > Open Ship To search app > Select Filter > I can filter and search by other fields
Another approach which has been used in the past for Table Lookup data items which have Customization Pattern = ChangeSynonymsFormatsValidations is to customize the data item and specify the desired field field (in this example the WriteCheckTo field) as a Secondary Search Field and then set Display Secondary Lookup to true for it. That field will now appear in square parentheses underneath the Primary Search Field in the list view and be filterable using the column filters. Any app that you want to work with this functionality change will need to be customized if it isn’t already, and all customized apps with that data item will see this display behavior/searchability change.
1 Like
One slight note for Ian’s post: adding a secondary search field can come at a performance cost: using one allows the system to use a user’s search against two separate tables if the entered search field is a table lookup.
This is a useful tool but can cause notable slowness in the UI if the following are true:
- The secondary/tertiary search field is a table lookup to a large table (many records)
- Users frequently use a wildcard (*) search to match their text input to a record
1 Like