Defining attribute properties

When a datasource is created using a table, the platform generates an attribute for each column in the table. You can also create an attribute manually. You can edit the properties of the attributes as per the requirement.

An attribute can have the following properties:

Property	Description
Name	The name of the attribute being created Note: The name should not contain any special character other than space.
Type	The data type of the column Note: The number columns are of the data type decimal and the character columns are of the data type String.
Length	The maximum length of the data
Scale	The maximum number of decimal places allowed in numeric data
Default Value	Note: You can define a default value for the attribute that will be set if the user does not enter the value for the attribute. UUID: generates and populates the attribute value with a Universally Unique Identifier (UUID) OrgID: populates the attribute value with the Org Id of the current subdomain SYSDATE: current date master.attributeName: Populates the attribute value from a parent/master row CURRENTUSER: The username of the signed in user CURRENTUSERID: The user id of the signed in user =SELECT: Executes the given select statement and populates the attribute with the resulting value PASSWORD: Populates the attribute value with the hash value of a randomly generated 12 alphanumeric value. The actual password value in clear text will be populated withattributeName_clear. For example, if pwd is the attribute name, then pwd_clear will have the generated value and pwd will have the hash value. String or Number Constant Value: If the specified value doesn't fall under any of the above, then it is treated as a constant value.
Insert	Indicates whether the user can provide a value while inserting a row
Update	Indicates whether the user can change the value while updating a row
Calculated	Indicates whether the attribute is a calculated value and should not be included in Insert or Update
Column name	The column name in the database that the attribute is mapped to
Out Parameter	Applicable when UseAPI is selected while defining the datasource details. The parameter in the API will be treated as IN OUT type.
Primary	Indicates that the attribute is a primary key
Auto Sequence	Indicates that the value is generated from a database sequence. If selected, in the Default Value column, enter the sequence name
Optional	Indicates if the attribute can be left blank by the user
Audit	Indicates if the changes to the attribute value should be audited
Query	Indicates that the column should be automatically included in the Where Clause when a value is passed during a query. When this property is not selected, the platform will not include the column in the where clause even if a value is specified. The developer should programmatically handle its value through the pre-query script.
Disable Uppercase Search	By default, the where clause is constructed as UPPER(column) LIKE 'VALUE%. When this property is selected, column = 'Value' is constructed instead, which gives better performance when the column is indexed without using the UPPER function
Select	Indicates if the column is a part of the select clause
Export	Indicates if the column is a part of the select clause while exporting the data
Param Name	Applicable when Use API is selected while defining the datasource details. By default, the parameter name is assumed to be P_COLUMN_NAME. If the parameter name in the API is other than P_COLUMN_NAME, then specify the exact parameter to be used here.

• To fetch all the attributes and their values from the database, in the Attributes tab, in the actions bar, click. The data from the database is displayed n the table in the Attributes section.

• To create an attribute, in the Attributes tab, in the actions bar, click . A row is added in the Attributes section. You can select/enter the required properties for each attribute.

• To set the attribute property, for the required attribute name, enter or select the appropriate values for the corresponding columns.

• To search for a specific attribute value,

a. In the Attributes tab, in the actions bar, click. Search filters are displayed for each attribute. Clicking onagain will hide with search filters.

b. To search for a specific attribute values, in the search filters for the respective attribute(s), select the search criteria. The attributes are displayed as per the search criteria.

• To delete a data row, in the checkbox column,

a. Select the row(s) that you want to delete and click .

b. Click Delete. The selected row(s) are deleted.

• To refresh the table, in the Attributes tab, in the actions bar, click .