FIltering same Data Query into Tabs in the same Form

Wappler General Need Help
1

Hello All,

How can i use a single server connect query to filter data into tabs in my design.
Use case:

  1. I have a page with multiple tabs - (Tabs with Nav) e.g. (Header: New | Assign | Completed)
  2. A single query with $_GET.filter (using column - status = $_GET.filter)
  3. Status column IN (0,1,2,3 etc)

I currently have 4 queries and filter it with status = 1, status = 2 etc for each tab.
I believe there is a smarter way.

2

You can use 1 query and the where() formatter.

e.g.

serverconnect1.data.query1.where('statuscolumn',1,'==')

for a table/repeat expression would repeat the query but only where the status column = 1
you could do another table/repeat for .where('statuscolumn',2,'==') etc.

There is also the option of using something like a select input

serverconnect1.data.query1.where('statuscolumn',inp_select.value,'==')

where changing the select value would update the table/repeat accordingly.

1 Like
3

Thanks for this promptness.
I have 10 records in the category e.g status=0, but only 4 was displayed, is there any reason for this.
My expression looks like this****** sc_tickets.data.qry_alltickets.data.where(status, 0, ‘==’)*****

4

Concerning the inaccurate record, any record with a NULL value in part of the repeated field is not listed even though it has id. Thanks.
Any idea if single pagination can be applied to all the tabs. I tried it was messed up