Can you use Subtables with Existing database?

[Sorry_Duh]

I’m pretty sure seen as your tables aren’t named with a prefix even in the query manager they are green, once you select your main table they will display any related table at the bottom of the fields which also as they aren’t named are green

[cpuser]

Actually you are correct, the last table is MEDIA in green! I didn’t seen.
But on the App side it doesn’t appear to select for the 2nd repeat.
SO, do I select the MEDIA table in the Query Builder? or not

[Sorry_Duh]

You can select media and it will return the images as an array or if you join them it will also add the parents fields to every repeat I’ll try find where hyperbytes explained the data output

[Sorry_Duh]

Thinking in sub tables

Sorry, late to the show (again) but think this is important Sub tables and joins work differently and therefore their output is not the same so in some cases joins are appropriate, others sub tables So if i take a simple users table (this is from the sample data in docker) and I add to it a sub table of role [image] Now to illustrate the difference i now add a separate role table [image] Both role tables have the same content, two roles “A” and “E” attached to user id = 1 I then create tw…

Here’s the explanation

[cpuser]

Okay, Media is now coming up on the app page to select… but its still not displaying the data

[Sorry_Duh]

Have you tried double clicking it in the query builder it opens a new panel for that table

You click where it adds the fields your outputting not where it lists all the fields in the table on the left just to specify

[cpuser]

double clicking doesn’t work it just adds it to the columns.

[Sorry_Duh]

You need to click to the right where it adds it double click what it adds

[cpuser]

oh yes! that worked! when I double click it opens another window. I added the fields I need. Do I need to set a condition or it should be okay because it has a foreign key already

[Sorry_Duh]

This condition would be if you only wanted certain media for example say you have a media type field and only want png you’d need to condition if you want all from that project you won’t need a condition most likely depends on the data really

[cpuser]

Okay. Something is not right, on the App, the Media doesn’t appear under the main query. In appears int he Serverconenct but nor in the parent nest. So I can’t select it like you had in your code.

[Sorry_Duh]

Maybe check this out for how to use the data

Using Nested Queries with the Database Query Builder

Intro You can access the nested data created with the help of sub tables using a single database query in your API Action. This way you don’t need complicated workflows such as using repeats and nesting database queries inside them to access nested data. Nested Queries First, create a new API Action: [Screenshot_28] And add a name to it: [Screenshot_29] Then add a new step inside it: [Screenshot_30] Select Database Query: [Screenshot_31] Open the Query Builder: [Screenshot_32] A…

[cpuser]

I will try to start again. I will let you know how I go. Thanks for trying to help. Its frustrating not getting nested repeats happening. I don’t mind which way I do it. Its doesn’t have to be Subtables, happy to use normal joins. … I just want it to work.

[cpuser]

Okay the App side it giving me the options to select… But the query doesn’t display the Media data. its blank. The main table data appears fine. but not the subtable media

[guptast]

If you create a new API and add main projects table, does it show media as a subtable in orange in the Query Builder?

[cpuser]

It displays media, but not in orange. It display in normal green.

[Sorry_Duh]

When you double clicked did you add fields you needed like you do with other queries? Also what does the binds look like for the media is there a chance you selected it from somewhere other than the repeat

Have you also tried inspecting what the query returns in browser tools under network XHR it will show the action (might need a page refresh once in browser tools)

Debugging Server Connect Errors

You can easily debug issues related to server-side processing such as - form not sending email, record not inserting or updating, query not showing data etc. The first thing you need to do is to open the server connect settings. They are located in the Workflows Panel > Server Actions: [Screenshot 2021-09-27 at 10.02.35] And enable the Debug Mode: [Screenshot 2021-09-27 at 10.03.08] Click Save: [Screenshot 2021-09-27 at 10.03.26] In your browser, open the Developer tools. If you don’t k…

[cpuser]

The issue is with the query side/subtable - the app side binds are okay.
So when I test the query, Projects display correctly but Media is empty - I tested this in Network XHR - this is how I know the server side is the issue.

[Sorry_Duh]

Could you try a new query with just projects and media as nested and see what happens it could be how something is setup in the query

[cpuser]

Okay. I got it to wor! Yay. Finally - but not with subtables - I gave up on subtables! I just used the tutorial below again (I had the output selected for one part that I shouldn’t). Thanks very much for your help.

Its great to finally see nested repeats Thanks very much guys - @guptast and @Sorry_Duh

……
For the benefit of others ….

I followed the tutorial below.

Nested Repeat Regions

With respect to Subtables I am not sure why it didn’t work? Even though I could see the ‘subtable’ showing in ‘Query Builder’. (by the way the subtable wasn’t originally showing in Query Builder, even though I have the foreign key setup correctly in MySQL, likely because the Database schema wasn’t refreshed as @George mentioned in his reply further above, but it appeared later on - I think after I did the refresh).

When I tested the query in ‘Query Builder’ the output didn’t show the subtable records, hence the nested repeat on the app side wasn’t working. I tried a few times and ensure the query were correct and couldn’t get it to work.

Regardless I achieved the same results using the nested repeat in Server App using the tutorial mentioned above.