kryo91
April 28, 2023, 9:55am
1
Good morning,
How to use repeating regions and child repeating regions, I have two tables, the first “vehicles” and the second the “elements of vehicles”, how to link the two tables in a looper
Thanks
ben
April 28, 2023, 10:01am
2
Does this discussion solve your problem?
A member asked me this question in a PM. I gave him an answer but also suggested it be posted publically as it is something I suspect many are not 100% sure about.
They are a little shy and have asked me to do it for them
The question was:
Can you explain how Repeat and Repeat Children work?
Let’s see if I was correct!
kryo91
April 28, 2023, 7:53pm
3
sorry no I don’t understand the explanation at all, is there a tutorial
bpj
April 28, 2023, 8:38pm
4
Repeat - repeats the item itself (and its contents)
Repeat children - repeats the contents (not the item itself) of the item with the repeat children property
kryo91
April 28, 2023, 10:36pm
5
that’s exactly what I want, I have a looper with a title (vehicle name) and a child looper, inside the first looper that will repeat the material contained in the vehicle. there is my question how do I link between them the two looper
ben
April 29, 2023, 1:38am
6
Have a look at this. It is a bit more advanced, but the same principle is there.
kryo91
April 30, 2023, 1:39pm
7
Hello, sorry, but I have no problem with filters and interacting between several tables, my problem is the grouped display for example
I have two tables
Vehicles:
vehicle_id
vehicle_name
table content:
1
VPC
2
GE
material :
id_material
vehicle_id
material_name
table content:
1
1
first aid kit
2
1
extinguisher
3
2
blood bag
desired result
VPC
first aid kit
extinguisher
GE
blood bag
I would like my results to be displayed grouped under the name of the vehicle
Thanks
Hey @kryo91 ,
Take a look here my friend:
In this tutorial we will show you how to nest database queries. This is useful when you have two separate tables, one containing your categories and another one containing your products. You can nest the products query in the category query and filter it by the category ID.
Other usage case could be a dynamic navbar with dynamic dropdowns, so you nest the dropdown items under each parent item.
Let’s start with the server action. Open the Server Connect panel:
[Screenshot_40]
Add new server …
If you have any questions please ask