Issue with database fields showing on client side

[BWCWeb]

I upgraded to the new version 6.0 and i have been having an issue with the fields of the database displaying for me to select them in the data display

Here is the server side setup
you can see the number of columns displaying in the query results

Now when i go to the client side setup and i am trying to retreive some of those items, its not displaying them all for selection. it seems like its only showing the primary table and not the Join table i selected

any thoughts on why this occured? I have tried to refresh the page / data scheme but still doesn’t show. The only way i can use the data is manually typing in the field name.

[franse]

Hey!

@BWCWeb

Click on the fields and the plus sign +
You can check the output of the api.
Also as a friendly reminder, I see agentId on both tables wich I saw on this community that has caused some troubles having the same field name.
Workaround here:

Server Connect with subtable returning incorrect data when a field has the same name in each

Wappler Version : 6.0.0 beta 13 Operating System : Windows 11 Server Model: node Database Type: postgres Hosting Type: n/a Expected behavior The correct value for the Contact table’s Type field should be returned. In this example it should be “Contact” [image] This is the subtable’s related record showing its Type field set to “Default” [image] Instead it is returning “Default” for the Contact Type field [image] Here’s the subtable show its Type set to “Default” as well. [image] …

[BWCWeb]

hi Franse, thank you for helping.

I will give that a shot.