Data Models

March 16, 2014 , by

Every Pistachio Application is broken up into various data models. Each data model has independent set of configuration options for items such as:

  • Group Roles Security
  • Display Settings
  • Data Table and Field Mapping
  • Field Grouping Settings
  • Validation and Record Ownership
  • N-Level Relationship Setup
  • Business Rules

Creating a Data Model

Simply click on [Add New] link under Data Model tab. Give it a name, select a table, and click Save.

Once, created, you will have a chance to play with more properties for the modal.

Outlined below are the information related to the Data Model settings. The settings are grouped by the tabs displayed within the Data Model Management tool.

  • Active indicates whether or not this section is available to anyone. If not checked, this section will not be available, regardless of the group rights settings.
  • Name indicates the internal name of the section.
  • Label is used in the place of the word 'record' throughout the section.
  • Label (plural) The label that is used in the place of the word 'records' throughout the section.
  • Notes provides ad hoc documentation regarding the Data Model


  • Duplicate Checking Mode indicates whether this section checks for duplicates on the add page.
  • History Tracking indicates what level of history if any should be tracked. The Save Granular History setting determines whether field-by-field change history should be saved to the obj_history_field table. This setting increases the amount of database activity needed to add or update a record, however provides a full archive of a record's prior values.
  • File Path indicates where the file uploads associated with the data model are stored.
  • SharePoint Data Sync List


Here you can specify which roles are associated with which Groups for this particular data model. A Role determines the family of features members of the user group will have access to. The above configuration indicates that this form will be available for administration Role by Admin group, and for searching and viewing (readonly) by all logged in users, as well as not logged in users.

  • Ownership - User rights allows users to view and edit records that they have created only. Group gives users permission to view/edit records created by users in the user group(s) they belong to. Section ownership allows users to view and edit the table's records that were created using this section's interface only. All ownership lets users edit/view all records in the table.


This section lets you manage fields associated with the data model. You can read more about Data Model Fields here. LINK HERE

  • Scan Table – Rescan the table and add new fields, if any added.
  • Re-Order fields – provides interface to reorder fields in which they are presented on the screen.


Record Saved Actions

  • Destination After Add - The page that is loaded after a user adds a record.
  • Destination After Edit - The page that is located after the user edits a record.
  • Default Detail View - Whether the Edit or View page should appear when the user clicks on the results row.

This section lets you manage rules associated with the data model. You can read more about Data Model Rules here.


  • Form Help - Help about the data model