# 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**. ![](/files/-M1ZqZfMedfUdXUOM0ho) The **Data Store** properties pane is displayed. ![](/files/-M1ZqnPQRdVAltttFm1R) 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 | {% hint style="success" %} *All fields marked \* are mandatory.* {% endhint %} 3\. Under **Standard**, enter the [standard component properties](/creating-pages/working-with-pages/working-data-stores/defining-data-store-properties.md). ![](/files/-M1ZrouGR-8SZGG-a8vQ) {% hint style="info" %} **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.![](/files/-M1ZvuRDk9To1IAfOno3) * 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. {% endhint %} --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.cloudio.io/creating-pages/working-with-pages/working-data-stores/defining-data-store-properties.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.