CODEWITHSUNDEEP
oracle-apex
Moe
Moe

Reputation: 1

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

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

Upvotes: -1

Views: 31

Answers (1)

Littlefoot
Littlefoot

Reputation: 143053

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)

Upvotes: 1

Related Questions