Performing non-SQL searches like available in the console

Data Service
1

In the console, it’s possible to do non-SQL (i.e. with the SQL toggle turned off) searches of the contents of the selected table by simply typing in arbitrary text.

How is this actually implemented? If I wanted to offer the same functionality in my app would I just prepare a where clause something like:

“col1 LIKE ‘%searchText%’ OR col2 LIKE ‘%searchText%’ OR col3…” for every column in the table?

2

Ping

3

Hi, Simon.
Yes, you can use SQL queries in Backendless console where form.
Do you encounter problems with it?

4

Yes, this is exactly how I would do it. A “like” search for every string or text column.

5

Cheers!