What fields does the search box search?

Basic answer: Server-side Skuid search, in all of its implementations (table search, lookup/master-detail autocompletes) will search on the following types of Salesforce fields:

• Text
• Text Area - short
• Email
• Phone
• Url
• Lookup
• Master Detail
• Picklist
• Record Id’s

Skuid does NOT search on the following field types:

• Date
• Datetime
• Number
• Currency
• Text Area - Long
• Text Area - Rich
• Boolean

Technical answer: All forms of Skuid search leverage SOQL (Salesforce Object Query Language), rather than SOSL (Salesforce Object Search Language). For a detailed explanation of the difference between these two, check the official docs. SOSL can search on long text areas, but SOQL cannot. However, there are many limitations to SOSL that made it impractical for us to use it Skuid’s search, at least at present, foremost of all its inability to search across lookup and master-detail fields, or to search on picklist and multipicklist fields. Alternative: Client-side search One alternative, assuming that you only need to search on records which you have already retrieved in your Models either initially or after Filtering, is to use Client-side Search. You can choose “Client” rather than “Server” from the Search properties of the Table component. What this means is that Skuid will search only on data that it already has in a Model — it will not go back to the server and search the entire database, then bring its results into the Model. So if you are trying to search across, say, all of the Description fields on all Tasks in your Salesforce, this will not work. But if you have already limited, for instance, your Tasks model to just those Tasks associated with a given Opportunity, and are ensuring that you will always retrieve all of these in your Tasks model (by setting the “Max # of Records (Limit)” property on your Tasks model’s Advanced settings to blank / empty), then Client-Side search may be a good option. For one, it will search on ALL field types: including Long Textarea and Rich Textarea. Two, it is much faster than Server-side search (which is saying something!), because no call to the Salesforce server is needed. If you’re worried about having too much data to search for Client-Side search to be viable, consider using Filters to pre-funnel the data down to just the subset you need, as Filters still run “server-side”, meaning that after a Filter is applied, it will funnel down the Model after doing a full server-side database query. Then you can client-side search on the results.