How to add extra, non-calculated field to an existing grid application

Applications Grid / Reports
#1

I have a grid application based on a view that contains data from several tables. Due to the complexity with many related tables involved in the view, I overlooked a field that has to be added to the view and grid. After adding the new field to the view by recreating it in the database, I want it to be added to the grid application as well. I thought by just opening the grid application in SC again, that the either the field would be added automatically, or there would be a way do so. However, the new field does not appear and I can’t find where to add the field.

Under “Fields” section in the left side there is a “+New Field” node, but that seems to be only for adding calculated fields based on the existing fields and not adding an extra field from the table or view that the grid is based on.

Any hints?

#2

Go to application tab on the left within your application and then click on synchronise table, you will see your field then.

#3

Grids don’t have the sync option.

If your fields are explicitly stated in the SQL setting of your grid, just add the new one there.

I’m lazy and use “select ".
To force a refresh in that case I just change the select to "select tablename.”.

#4

Thanks for the help! Updating the SQL did the job.