Hello

Creating a Grid with an SQL query works fine. After adding an column (for example ROWID) on the first position of your SQL query, the database column is not added to your coloumns. You have to add it on the last position of your SQL query. This is no problem, but I thought maybe you would like to know it. I use FOEX 2.1 and Apex 5.

Kind Regards, Christian

I have just tried reproducing the behaviour and can see that when modifying the query of an existing grid and adding a new column in the first position (or any other position) it does appear in the desired position of list of columns but at the end. This is the same behaviour in APEX 4.2, you need to re-order your columns using drag & drop in the page designer to obtain the desired column ordering. The query only affects the ordering on the initial creation.