Defining data store properties

1. To define the data store properties, select the data store component and in the upper panel of the Page Tree section, click the Properties tab.

   OR

   Right-click the data source component and from the list, select Properties.

The Data Store properties pane is displayed.

2. Under DataSource, enter or select the following details of the datasource from which the data is to be used in the application:

Label	Description
Data Source*	The name of the datasource
Data Source Alias*	A unique name as the DataSource Alias which will be used while performing actions on the store All the datasources defined within the current page or any of the parent abstract pages must have unique alias names.
Default Where Clause	A default static where clause to be used while fetching/manipulating data from the datasource
Max Rows	The number of rows to be fetched and displayed at a time The same number of rows will be displayed for every scroll. This is applicable when the data store is used by the Grid and the Card Table component only. The default value for Max Rows is 20.
Order By Clause	A default Order By clause to sort the fetched data For example, #firstAttr#, #secondAttr# DESC
Auto Query	Fetches all the records of the data store
Execute Count SQL	Returns the total number of rows in the data store
Execute Distinct SQL	Returns the total number of distinct rows in the data store
Insert Allowed	Allows you to insert a new record in the data store
Update Allowed	Allows you to update an existing record in the data store
Delete Allowed	Allows you to delete an existing record in the data store
Mask Page on Post	Freezes the page until all the data changes made from the frontend get saved at the backend
Make New Records Dirty	Indicates that you have not saved the changes made to the data The dirty records are highlighted in red.
Cache Results	Fetches the data from the previously saved searches that are saved in the cache memory This is applicable only if the Remote Filter property of the LOV component is enabled.
Auto Refresh Interval	Number of seconds after which the data store must be refreshed
Server Validate on Create	Performs default operations on the server side when a new record is created

All fields marked * are mandatory.

3. Under Standard, enter the standard component properties.

Note: For some components , you can create a data store instance and define its properties directly from the component properties section. For example,

• To create a data store instance for the Grid component, under DataSource, select Data Source and Data Source Alias. Fill the rest of the details as required.
• To reuse a datasource that was defined on another component of the current page or its parent abstract pages; or use an existing data store component, you must select the Use Existing Datasource box in the properties of the respective component and enter its details.