Inner Joins not working correctly - ID from the second table is not saved

Wappler Version : 3.9.1
Operating System : MacOS
Server Model: ASP.NET
Database Type: MSSQL
Hosting Type: IIS

Expected behavior

What do you think should happen?

When creating an Inner Join between tables in DB Query Builder UI, the linking IDs from both tables should be saved in the SA JSON file

Actual behavior

What actually happens?

ID selected from the Second Table is not saved correctly in the SA JSON file.

How to reproduce

  1. Create a new Server Action
  2. Add a new DB Query, Go to Query Builder
  3. Select two tables, select unique IDs from the First and Second Tables and Save
  4. The Select Statement shows the Second Table Name but the ID is not added. Once the JSON file has been edited, the SELECT Query shows the correct data (Screenshot attached)

1 Like