How test equality of property to the content of a variable in where clause? (codeless)

Server Code Codeless
1

How test equality of property to the content of a variable in where clause? (codeless).
Example: I need to recover from a table, the records which propertyX= @variableY .

2

is the “content” a list? an object? or a scalar value?

What does the variable contain? (list, object, string, int)?

Regards,
Mark

3

A string (ex. “ab5537773”).

4

The comparison operator should do the job then:

UI Builder - DatabaseCourse - Backendless 2023-02-17 13-49-45
UI Builder - DatabaseCourse - Backendless 2023-02-17 13-49-451160×1432 74.6 KB

5

I’ve tried it. But it does not conect …
image

6

I do not see what you’re trying to compare… The screenshot shows you’re loading objects from a table. The comparison block doesn’t make sense there.

7

Sorry.
The solution below does not work as well, but probably will illustrate better my intent …
image

I am trying to retrieve all the records of the table which column humanoWhatsapp have the value that is stored in the variable primMsg.

8

Make sure to test your where clause in rest console first.

The logic you composed for where clause doesn’t make sense.

The comparison operator returns a boolean value (true/false). The “create text with” just takes that value of true or false and returns “true” or “false”. That is incorrect where clause.

Have you taken the Codeless training course here?

9

Don´t worry. I will find a solution.

10

I am sure you will. With some time spent understanding how Codeless works, you will find a solution faster.

UI Builder - DatabaseCourse - Backendless 2023-02-17 14-42-16

11

Thanks!