IIs there any text search across multiple fields?
I have attached UI and Class schema SS .
Where do I want to provide a single search box to fetch records which is similar or satisfied search value from multiple fields on the table ?
also my table(Class) contains different types of fields if I want to query as in SQL where we use LIKE Operator (eg . WHERE CustomerName LIKE ‘a%’) on multiple fields.
what do I need to do ? as for string column there is methods like start with or fulltext so what I need to do in case of other types
Or Do I need to convert all my columns into string types?
please suggest the easiest way to achieve this functionality in the PARSE way.