Table of Contents

Search

  1. Preface
  2. Understanding Data Types and Field Properties
  3. Designing Processes
  4. Using and Displaying Data
  5. Designing Guides
  6. Designing Process Objects
  7. Designing Service Connectors
  8. Using Connectors
  9. System Services, Listeners and Connectors

2. Design

2. Design

Creating OData Custom Composite Keys

Creating OData Custom Composite Keys

To create OData custom composite keys, you select entities that you want to use as primary keys.
  1. Click
    Edit Custom Keys
    .
  2. Select an entity from the list of entities.
  3. Select the fields that you want to use as a custom key. You can select multiple fields.
    Important:
    Ensure that you analyze the data and select fields that uniquely identify each record in the database table or view. For example, if you want to use the fields
    FirstName
    and
    LastName
    to create a custom composite key, you cannot have two employees with the same first and last names.
  4. Click
    Apply
    .
    You see the custom composite key that you created in the list under Custom ODataEntity Keys.