Page Comparison

Scenario: I created a grid view configured with a SQL Map and default instruction class. I had mapped the view to an app, which in turn is mapped to a workspace. However, in the application (e.g. CT ModelHouse), the app (widget) is empty and does not display any data even though the table that is referred in the SQL Map does contain data.

Try all of the following steps:

• Ensure that the SQL Map ID is correct in the configuration screens in Canvas Studio as defined in the SQL XML file.
• Ensure minimum one column from the table is selected as a sortable indicator in the configuration for the view in Canvas Studio.
• Ensure that the view items ID (columns) of the grid in the Canvas Studio configuration screen are exactly the same as the column names in the table.
  
  
  
  

• Ensure that the column names and table names in the SQL Map query are the same as in the database schema.

  Note
  If you are using Data Source instead of SQL Map, ensure that the column names and table name given in the Data Source configuration screen in Canvas Studio are same as in the database schema.

  
  

• If all the above fails, clear the cache for Canvas Studio and the application. Clear the browser cookies. Access the application to check if the widget is displayed with the data from the table.