SQL Collection

English Forum Questions
1

Hi guys,

I cannot find this info but does SQL collection accept params? Like AND b.data = :data.

The issue Im having is that i have is i have tables that belong to floors that belong to buildings and Im Booking that table on a specific date. I want a table on the ui so that it lists all tables and filter by date so i can see if its booked and i cannot seem to get that working. If if filter by the Booking date all it shows is the table thats booked. I want all the tables by date and if they are booked or not. Can someone help me please?

2

No filtering is needed when defining SQL in NocoBase; filtering can be done when creating blocks on the page using SQL collections. The filtering functionality is no different from that of a regular table.