Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  1. If not already opened, click the Linked Entities tab in the pivot grid view's properties dialog.
  2. Open the Linked Entities entry for the entity whose record you want to open when a cell is double-clicked in the pivot grid.
  3. Make a note of the Join Field specified on the Linked Entities record. Typically, this is the Linked Entity's ID field.
  4. Click the Fields tab look for that entity's ID field in the field grid.
  5. If the ID field is not already included, click New and select ID from the Field Name field. Otherwise, double-click ID in the field grid and go to the next step.
  6. Modify the Description for the ID field if it has not been properly aliased.
    • Aptify uses the field's description as the field's alias in the pivot grid's source SQL statement. Therefore, be sure to properly alias the field so it is unique and does not conflict with other fields selected in the SQL statement.
    • For example, the display name for the Orders entity's ID field could be changed to OrderID (to avoid confusion with the Persons entity's ID field).

  7. Click OK to close the Fields record.
  8. Click OK to close the Linked Entities record.
  9. Click the Detail Navigation sub tab.
  10. Specify the entity whose record you want to open when a cell is double-clicked in the Detail Open Entity field.
  11. Enter the display name you assigned to the entity's ID field in the Linked Entities record in the Detail Open Entity Field field.
    • For the figure below, the Detail Open Entity field value is OrderID, which corresponds to the display name assigned to the Orders entity's ID field in the corresponding Linked Entities record.
      Pivot Grid View Detailed Navigation SettingsImage RemovedDetailed Navigation SettingsImage Added
       
  12. Configure the other pivot grid settings, as necessary. (See Creating a Pivot Grid View in the Web Interface).