#RecordListView-SearchBox

Question

Hi All, 
 In Record list view there is search box. 
 what is the search criteria for this? 
 will it search all data which are displaying in List view? 
 can we customize this search box? 
 
 Thanks in advanced.

Conor Cahill · Accepted Answer

In Appian 16.3 and earlier, my experience has been the following: The search box in the record list view will query on any record fields in the title of a record (i.e. the blue link text). 
 
For example, your title could be built like the following: "Case: " & rf!caseId & " - " & rf!caseName 
You could have the following records: 
Case: 00204 - Merchant Payment Issue 
Case: 00205 - Sales Cost Increase 
 
You could search using either the caseId or the caseName, but if you were to type "00204 - Merchant Payment Issue" or "Case", it would not find any results. It seems like the system will search each individual record field in the title for the entire search text. In both of our search example, no single record field contains the full string, so no results are returned. 
 
I don&#x27;t believe that this is customize-able, however you could build a report that has all the customized search features you need. 
 
It looks like in 17.1 the search functionality has been improved, but I&#x27;m not sure what exactly it&#x27;s searching on.

PhilB · Answer

This depends whether you&#x27;re using the grid or feed layout for the record. 
 
If you&#x27;re using the feed type view, @conorc is pretty much there - essentially any field used in the title is searchable. However, it&#x27;s worth knowing that there&#x27;s a useful - if technically unsupported - trick here, in that any field used in the title expression is searchable even if it&#x27;s not actually displayed. Bearing this in mind, you can use the concatenate function to reference multiple fields, but concatenate them conditionally. For example: 
 
fn!concat( 
 "Case: ", 
 rf!caseId, 
 " - ", 
 rf!caseName, 
 if( 
 true, 
 "", 
 fn!concat( 
 rf!caseDescription, 
 rf!caseInitiator 
 ) 
 ) 
) 
 
The above will display caseId and caseName, but make the other two fields searchable. 
 
If you&#x27;re using the grid layout, any field you map to a column is searchable - though this doesnt apply for values you retrieve using rules; only rf! fields are searchable. If there are fields you wish to search but not display, there is an option to hide a field - if it&#x27;s hidden, it isn&#x27;t shown but it is still searchable.

mk · Answer

I agree with what Conor has said. To add to that, in my experience it searches for every field that is displayed on the Record List View and not just the title with the record link.