Query Template Display

• Limit users who can view data for other contacts - (enabled by default) If this option is enabled, only users who can edit a contact, such as the contact themselves or staff, or who administer a group that the contact belongs to, can view query results for that contact. Enabling this option prevents other users from changing the ID in the URL to access another contact's data. If this option is disabled, you can also allow access based on contact security settings with the Allow access to other contacts via Contact Security option.

  • Allow access to other contacts via Contact Security - (disabled by default) Available only when Limit users who can view data for other contacts is disabled. If this option is enabled, users can view query results for any contact that the contact security queries allow them to view (Settings > Contacts > Contact security). Enabling Limit users who can view data for other contacts hides and clears this option.

    🚧

    Warning

    Depending on your contact security settings, enabling Allow access to other contacts via Contact Security might allow public users to change the ID in the URL to view other contacts' data. For example, if a contact is included in the All users access query, unauthenticated users can view this query's results for that contact. Do not enable this option for queries that return sensitive data.

• Source query – Click select and browse to the IQA query. The query must have content defined in the Template tab of the query definition.
• Display in cards – Displays the query content in a container that resembles a card. See the Cards Bootstrap documentation for more information about cards. When this option is not enabled, the query content is displayed in a simple list.
• Display in columns - Displays the information in multiple columns instead of a single column.
  • Number of columns – Select the number of card columns to display on each page.
• Rows per page – Enter the number of data rows to display on each page.

📘

Note

Results are limited to a maximum of 120. If the column-by-row calculation is greater than 120, the Rows per page
value is automatically modified to a value that returns 120 or less.

• Pager position – The pager is a set of controls that moves the pages of results either forward or backward. Select where the pager is located:
  • Left - Select to show paging controls on the bottom left of the page.
  • Center - Select to show paging controls in the bottom center of the page.
  • Right - Select to show paging controls at the bottom right of the page.
• Use simple pager - Enable to hide the page numbers.
• Hide when there are no results – Enable this option to hide the content item when the query specified returns no results.
• No results tab – Message displayed when the query specified returns no results. If Hide when there are no results is enabled, this tab is disabled.
• Header tab – Messaged displayed above the query results.
• Footer tab – Messaged displayed below the query results.

• The maximum number of results to display is 120.
• Use the ContactProfileImage business object to display profile pictures.
• If a source is removed from the query and one of the source’s properties is being used in the Template, the property is not automatically deleted from the Template content and must be manually deleted.
• Properties that use the built-in functions (Count, Max, Min, Avg, Sum) are respected, and the resulting values are displayed in the template.
• The following are currently not supported in the Query Template Display:
  • Subtotal properties
  • Optional query filters
  • Exporting the query results directly from this iPart