Classic Sunset Officially at 2026.1

[klincecum (Kevin Lincecum)]

@aclements

There is definitely an issue with inner sub queries in a baq, causing invalid column names errors in the server log when used in a kinetic dashboard.

The issue is not with the queries, but with that wizard.

Let me see if I can find the thread.

Edit:

I'm this close to rage quitting - Application Studio and Dashboards

There is a known bug in the Basic Application Wizard where if your BAQ has subqueries, the grids get created with all columns including those in subqueries that are not in your top level. Then the way the provider model works is it runs the BAQ with a select list of columns and because of the above this can now cause the SQL error you are seeing because the columns do not exist to the top level. Therefore when this happens you need to your grid after the app has created and go to Grid Model > …