We create the Grid.
1. We create the grid based on the table “Orders“.
2. In the side panel, we go to “Export -> Export types” and we are going to work with the JSON option.
3. In the general settings we select “Select columns“. So that when exporting we can select the columns to display.
4. In the Default values, we configure it as follows .
5. Finally, select the “Run application” button on the toolbar to generate the query.
To see more examples created with Scriptcase, go to: Examples: Complete systems and applications with Scriptcase