> For the complete documentation index, see [llms.txt](https://docs.cloudio.io/llms.txt). Markdown versions of documentation pages are available by appending `.md` to page URLs; this page is available as [Markdown](https://docs.cloudio.io/creating-pages/working-with-pages/working-data-stores/defining-data-store-properties.md).

# 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\*       | <p>A unique name as the DataSource Alias which will be used while performing actions on the store</p><p><em>All the datasources defined within the current page or any of the parent abstract pages must have unique alias names.</em></p>                                                         |
| Default Where Clause      | A default static where clause to be used while fetching/manipulating data from the datasource                                                                                                                                                                                                      |
| Max Rows                  | <p>The number of rows to be fetched and displayed at a time<br>The same number of rows will be displayed for every scroll.</p><p><em>This is applicable when the data store is used by the Grid and the Card Table component only. The default value for <strong>Max Rows</strong> is 20.</em></p> |
| Order By Clause           | <p>A default Order By clause to sort the fetched data<br>For example, #firstAttr#, #secondAttr# DESC</p>                                                                                                                                                                                           |
| 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    | <p>Indicates that you have not saved the changes made to the data</p><p><em>The dirty records are highlighted in red.</em></p>                                                                                                                                                                     |
| Cache Results             | <p>Fetches the data from the previously saved searches that are saved in the cache memory</p><p><em>This is applicable only if the <strong>Remote Filter</strong> property of the LOV component is enabled.</em></p>                                                                               |
| 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 %}

&#x20;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)&#x20;
* 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 %}