When adding/editing a row, some columns are not showing

Question

I added a column to a table in the SQL Workshop. I synchronized the columns of the interactive report. When adding/editing a row in the report, the new column is not available.

Details: I made an excel sheet with 5 columns. In Oracle Apex SQL Workshop, I loaded the excel file and created a table. Using the table, I made an app with an Interactive Report page. Then I added a 6th column in the SQL Workshop. I synchronized the columns of the interactive report. The column was added. I ran the application. The column was NOT displayed. I had to press "Actions -> columns" then move the new column to the displayed side. Now, When adding/editing a row in the report, only 5 columns are available for editing/adding. The new column is not there.

image3

image4

Answer 1

That's how it goes.

• when you added a new column into a table, you (properly) synchronized the interactive report which then fetched that column
• running the page, you have to add it using the "Actions" button
• don't forget to Save that layout! (most probably as the default report), otherwise it'll be "lost" and you'll have to add it again using the Actions button
• the 2nd page (on the right hand side of the screenshot) represents a form you use to insert/modify data
  • you have to synchronize that page's region as well in order to display the item (related to newly added column)
    • synchronization won't propagate from one page to another!
  • once it is there, modify its properties (if necessary)