How to nested queries with pagination?

Wappler General Need Help
1

Continuing the discussion from Nested Repeat Regions

I've created so many nested queries in past. But now it's required to create nested query for a large parent table.

Example:

  1. Air Ticket PNR xd62835 (has 2 connecting flights)
    1. Flight No 01
      1. Person 1
      2. Person 2
      3. Person 3
      4. Person 4
    3. Flight No 02
      1. Person 1
      2. Person 2
      3. Person 4

As rhe main table (Air ticket PNR) is a large data table, I need paged query. But in Repeat region I can't select and display data from paged query, instead I've to select repeat step to do so.

Anybody can please guide to do it easily.

2

That would very much depend of your data structure, can you explain it?

I assume maintable -> subtable->subtable

3

Yeah.

As I mentioned above : Air_Ticket > Flight_Details > Person_list.

I’ve created them in phpMyAdmin (not in Wappler DB manager). So they are connected to each other with their PRIMARY_KEY ID’s and Foreign_Key’s. But in Wappler DB manager I can’t see as SubTable (I’ve never used that to create tables).

4

I dont know how far into the project you are but I stongly suggest you revise your data structures if you can as your current structure is going to make things much more difficult than it needs to be.
If you dont fully understand how subtables work then perhaps view this video which hopefully should highlight how to optimise your data structure which will kake everything much easier.

If you dont want to watch it all (i suggest you do as it contrasts what you are doing with a subtables approach) then subtables are dealt with about 15 minutes in

1 Like
5

Using Wappler without watching your tutorials is like driving an Airplane on the runway. :grinning_face_with_smiling_eyes:

1 Like
6

You are so kind, thank you.

1 Like