Creating local data storage

Local data storage lets you store data records for a data type without having to manually create or maintain database tables. Local data storage is used with a data type 's record editor.

  1. In the navigation panel of Dev Studio, click Data types.
  2. Click the data type.
  3. Click Sources.
  4. Click Create a local source.
  5. Optional: Add a property by clicking Add a row. Remove a property by clicking the Delete icon to the right of the property row. To change the property order, click and drag the icon to the left of a property row to reposition the property.
  6. Specify which column to use as the key by clicking Add this property as key in the Use as Key column.
  7. To generate single, list and savable data pages for this data type, select Generate single, list, and savable data pages.
  8. Optional: To change the default data page names, change the defaults in the Single instance data page name, List data page name, and Savable data page fields.
    Start the data page names with a "D_" followed by letters and numbers, with no spaces.
  9. In the Database field, select the database to use.
  10. Click Submit.
  11. Review the list of the properties configured for local data storage.
  12. Optional: Select View Details to view the database table, report definition, and data page details.
  13. Click on a link to review the rules created for the database table, database table mapping rule, report definition, single instance data page, list data page, and savable data page.
  14. Click Close.
Result: If you get a warning that the system could not generate a dedicated database table for this data type, refer to Fixing database table generation for more information.