Question
Carrollton Enterprise Services LLC
Carrollton Enterprise Services LLC
US
Posted: Sep 12, 2025
Last activity: Oct 3, 2025
Last activity: 3 Oct 2025 18:19 EDT
Cross Column Search
When I attempt to search by first and last name it does not allow me to on the OOTB search because they are stored in separate columns.
@JohnB691
Here’s the thing: the OOTB search won’t match across two separate columns, so give it a single searchable field. Create a Text property like .FullName and populate it with FirstName + " " + LastName via a declare expression or on-save data transform (also handle middle names and extra spaces). Add .FullName to the class’s search index fields in Dev Studio (Search settings → choose your class → include property), then trigger a full reindex of that class. After reindexing, users can type “john smith” and hit the .FullName tokens instead of needing two filters. If you need partials like “jo smi,” enable the standard analyzer (works fine) or add an n-gram/custom analyzer if your version supports it. For lists where you can’t change the index, add a Report Definition with a calculated column that concatenates names and filter with “contains.” Finally, surface that RD behind a “People search” view or action so users have one simple box that just works.