Hi Appian Community,
I have a use case where I'm using a record type as the source for a readOnly grid. This grid contains both record fields and related record fields, and I'd like for all fields of this grid to be searchable using the out of the box search functionality. Per appian documentation at https://docs.appian.com/suite/help/23.2/filter-the-record-list.html:
When you hide search on the record list, the search box on the grid will use the default search behavior, searching across all fields referenced in the grid. The search box will also use the default placeholder text of "<Plural record type name>".
"<Plural record type name>"
The above described functionality is what was desired, so I went ahead and hid search on the record type while setting the "showSearchBox" parameter on the readOnly grid to "true". However, the result is that related records fields with a one-to-one relationship are still searchable, but related records with a one-to-many relationship cannot be searched. Is this expected behavior?
Thanks in advance for any help!
Discussion posts and replies are publicly visible
Hi,
As per my understanding, selecting related record fields from a one-to-many relationship may slow "search performance".
Consequently, conducting a search on associated record fields within such a relationship might not be feasible.
I'm not sure if there exists an alternative solution for this situation.
Configure the search box
To configure the search box on the record list:
In your record type, go to Filters.
Under Search, select or clear the Show search box checkbox to show or hide the search box on the list. By default, this checkbox is selected.
Select the Limit search to selected fields checkbox to choose the fields to search on. You can select record fields or related record fields of type Text, Number (Integer), User, or Group, with a maximum of 10 selected fields. Selecting related record fields from a one-to-many relationship may slow performance.