Query configuration problem

[Marzio]

I have a problem that I can’t solve:
In the database I have two tables, one to list “travel” and the other to list “tickets”

---

I have generate a table on a PHP page that through a query lists all the available travel (IDtravel) with all the fields, including a numerical field of the available places

---

In the Tickets Table (IDticket) there are all data including the number of seats booked (for each travel)

I would like to insert a column in the table with the data of the booked places relating to the IDtravel record, taking from the Tickets table by adding the result (SUM)

I tried to configure various query solutions, but it doesn’t work

I don’t know if I explained enough, but if someone has any ideas, thank you in advance

[Marzio]

Anyone know how to do it?
In practice I have reached the point that I have a table on the page that lists (repeat) all the “ID” records
Then I also have a Connect Server connected to another database table, which through a query sums all the numerical values of the places booked, with a GET “ID” parameter
The current result of all places booked gives a correct number, and if I manually enter a value of a “ID” record it effectively filters the total

What I can’t do is being able to add a column in the table (repeat) where to insert the “places booked” data by filtering it with the ID table value

[Teodor]

You need to check this:

Nested Repeat Regions

to see how to filter the second table using a value from the first one. In the second table query builder you can use the aggregate functions to return SUM:

[Marzio]

@Teodor

Regioni ripetute nidificate

Thanks Teodor
I hope it can solve my problem and I hope above all I don’t make mistakes
I’ll let you know if everything is ok

[Marzio]

I will follow the instructions
However, I hope to achieve this result, where the last column reports the sum of a field of a second query, filtered for the value of the first column ID (main query)
Also because that value will then serve to set up some operations with other records of the record line

[famousmag]

Join Results of 2 Data Collections

Intro Using the Data Transformations options you can easily join the results of two different data sources such as - a database query and an API response, the results of 2 database queries from 2 different databases, or any other array data. In our example we will show you how to join the results of 2 database queries from 2 different databases. Data Transformation We have two database queries using two different database connections, so we can’t join them using the query builder. We can joi…

Working with Server Connect Array Lists

Intro The Server Connect Array List component allows you create and manipulate Array Lists easily with Server Connect actions. You can add items to an array, join multiple sources, remove and set arbitrary items, keep simple or complex objects or collections in an Array List. It’s also easy to use it as a string builder, when you need multi lines strings. Basics In order to be able to add items to an array you first need to define the array. The Array List actions are located in the Data Man…

[Marzio]

I followed the instructions, but I probably be wrong because it is as a result of an error

[Teodor]

Sorry marzio but that has nothing to do with what i posted above. The tutorial i sent you shows how to nest a query and filter it with the result of another one.
Your screenshots show something totally different. Just follow the tutorial i linked to and adjust it per your requirements for summing the values …

[Marzio]

Sorry Teodor I thought the last post was evolution. I restart again

[Marzio]

Sorry Teodor
but i got lost
I ran following the tutorial, but when I got to this point I don’t find it. It doesn’t appear to me like in the instructions

[Teodor]

well, Marzio you can turn app connect mode off to be able to see the content if no dynamic data is available.

[Marzio]

I continued but then I get to repeat2 and it doesn’t let me choose repeat2

[Teodor]

I don’t understand what exactly you’re doing from your screenshot.
Just follow the tutorial i sent you, there’s nothing more required and there’s nothing more i can explain you than what’s already explained there…

[Marzio]

Okay
Double check, maybe I did something wrong
The tutorial was done with an old version of Wappler and certain procedures have changed
Thank you

[Teodor]

Nothing in the process has changed actually.

[Marzio]

Thanks Teodor
then thanks to your advice I got completely what I needed