How to filter tables based on the data in a column

[Breldan_Muthaka]

Hi, I have a table that I need to filter based on the items in a column.
The table is called navigation and therein the name of the column that contains the name of the link is “navigation” so I added a different column that will contain the location where I want the link to be shown called “location”.
More details below.

<div style="position: relative; padding-bottom: 56.25%; height: 0;"><iframe src="https://www.loom.com/embed/d981b2a837f64dc29ce041d54f533211" frameborder="0" webkitallowfullscreen mozallowfullscreen allowfullscreen style="position: absolute; top: 0; left: 0; width: 100%; height: 100%;"></iframe></div>

(Please use the link below to view the loom screen recording in case the embed doesn’t work
Loom | Free Screen & Video Recording Software | Loom)

I am getting the items from my navigation table based on the repeater logic above. How can I filter by the location column so I can get the items with location value of “sidebar”?

[mark-piller]

Do you need to get database objects for a specific location ?

[Breldan_Muthaka]

Yes sir.

[mark-piller]

In that case, you need to use a where clause to create a condition for the database to return data.

Additional info:

How to fetch data from the Backendless database with a query (whereclause)

https://backendless.com/docs/js/data_search_with_where_clause.html

[Breldan_Muthaka]

I’m not able to get the correct results when I do the query.

This is how my data is structured.

Otherwise, I get the data in the response.

[mark-piller]

Try this:

location = 'sidebar'

Check the documentation link I shared earlier for examples of where clause formatting:
https://backendless.com/docs/js/data_search_with_where_clause.html

[Breldan_Muthaka]

Right!
So I was able to filter on the REST Console.

How do I apply this to the where clause in the UI Builder Logic?

[Breldan_Muthaka]

Perfect!
I’ve done it.