Creating Datastores in SXP Extensibility

First published on: 03/20/2025/12:00 pm

In your Saltbox Tenant, in 'Project Assets', choose 'Add Datastore'.

Populate the Datastore name.

The user can populate a description or copy an existing datastore.

Using 'Copy' will duplicate the structure, but won't copy the content. 

After you click 'Add', the datastore setup will open: 

Now you can add fields to your datastore.

Using the + button on the fields list, add the fields relevant to your datastore. 

For each field, you can define: 

• Required – This will mandate that any record inserted or updated into this datastore must provide a value for this column and will default the field to editable. 
• Set the field as Primary Key – This field will be used when inserting/updating/fetching the record from the datastore via a workflow (to be described in the Workflows section).  
• Name – The column name in the DB. 
• Display name – The name that will be displayed on the form/grid.
  • If not populated, the DB name will be displayed. 
• Data type – String, date, integer, decimal, boolean, collection, or object. 

Based on the selected data type, the user will see additional setting options:

• Format – This field will define how the value is formatted on screen. (Numeric or currency.)
  • The currency option will NOT perform any conversion action; it will only concatenate the currency symbol to the value for display. 

Continue adding all the fields, then click save. 

The datastore is ready to be used. 

• Preview the data in your datastore – Quick view of your datastore's content. 
• Purge a datastore – Empty a datastore's content.
  • You cannot modify the schema, change data types, or remove fields when data exists. This option will empty all data. 
• Record settings (business validations) – Discussed in a separate section. 
• Populate/create datastore using a workflow – Discussed in a separate section.