Data value not showing in added column

[Former Member]

I have added a column to a fixed SQL query. When the application runs, the column appears in the display grid, but the value is missing.

I have added the column to both the query and display templates. I've added the column to the IlluminatorDoc, reselected the query template in the IllumSQLQuery block, and updated the configuration in the IlluminatorRow block to link the new field.

The new column appears in the Rowsets/Rowset/Column and I can see the value in Rowsets/Rowset/Row. When running the xacute query calling the BLS transaction, the new column and value is displayed in the text/html format.

Can anyone advise on why the column value is not showing in the grid?

[Former Member]

Thanks Udayan & Ryan.

The auto refresh was checked, so once I disabled I was able to use the Data option on the grid.

Thanks for your time!