Common properties

There are some common properties that should or can be used when defining a Data Access. These properties are:

• Cache: The cache can also be defined as an attribute when defining a Data Access. When defining the cache as an element, we should also specify the two attributes, duration and enabled. The first attribute is used to define the time that the query will be cached since the last execution. The enabled attribute will be set to true or false depending on whether you want to enable it or disable it.
• Name: This is the friendly name of the data access being defined.
• Columns: This is an element that can create a different output by changing the name of a column or just by adding new ones using calculated columns. To change the name of columns, you would just need to specify the columns' idx, starting from 0, and the desired name, as shown in the following example:

  <Column idx="0">
     <Name> Region </Name>    
  </Column>
  <Column idx...