Adding new intellilink

  1. Provide a name to be displayed on the Data Browser and Exception Browser. The Stored Procedure name is derived from the display name and displayed automatically. The stored procedure contains the logic to create relationship between tables by linking two or more tables.
  2. Provide the Stored Procedure Group name.
  3. Select the check box Display in Primary Object's Group if you want the Intellilink to appear as the primary Intellilink. For example if the base table is Invoice and this check box is selected, then Invoice will appear as the primary Intellilink on the Data Browser, and the other tables like the vendor, Invoice_line will be displayed in another group.
  4. Click the Get Stored Procedure Template link, if you do not already have the Stored procedure template. When you click the link, the SQL gets copied to the clipboard.
    Note: It is mandatory that the stored procedure should include:
    • The output columns total_count, of_page_number, and page_number .
    • The input parameters with default values  @export_flag char(1) = 'N', @topx int = 10, @page_number int = 1, @cdm_id bigint = null
  5. You can work with the stored procedure on the clipboard and then paste the template in any SQL editor using Ctrl V. Alternatively, if you already have the Stored Procedure SQL, copy it in the Stored Procedure SQL field.
  6. Click Save to add the Intellilink.