Support Topics Documentation Slack YouTube Blog

Invalid Where clause on a simple database and query

I’ve created a simple one-column database and if I search with “sql search” enabled I get “Invalid Where Clause”.

If I disable sql search I get no error but no results are returned.

String = First_Name
Value = Erika

My search = First_Name = “Erika”

What am I doing wrong?

Please see the documentation:
https://backendless.com/docs/rest/data_search_with_where_clause.html

The proper formatting is:

First_Name = 'Erika'

Regards,
Mark

Of course it was something that small! Thanks Mark!!