Adding dynamic filters to queries

You can dynamically filter your query results using the variables described.

Note: You must enter the quotation marks where indicated when using the following variables.

  • Filter by ContactKey and UserKey properties of a business object:
    • "@LoggedInUser" and "@Me": Both filter by the currently logged-in user.
    • "@SelectedUser" and "@SubjectContact": Filters by the selected contact. The contact is selected based on the contact key passed in the URL parameter. If no contact key is passed in the URL, the contact is considered to be the On Behalf Of contact (if set), or the logged in user.
    • For example, set NetContact.ContactKey equal to "@SelectedUser".

  • Filter by ID:
    • "@SelectedID": For authenticated users, this variable filters by a selected contact ID. The ID is selected based on the ID passed in the URL parameter. If no ID is passed in the URL, the ID is considered to be the On Behalf Of contact's ID (if set), or the logged in user's ID.
    • For example, set CsContact.ID equal to "@SelectedID".

  • Filter by date properties:
    • @Date: Filters by the current date.
    • @Now: Filters by the current date and time.
  • Filter by URL parameter:
    • "@url:" Filters by a specified URL parameter. Specify the name of the URL parameter after the colon in "@url:".
    • For example, the event dashboard page includes a parameter in the URL called EventCode. To build a query that uses this EventCode as a filter, add a filter to the query that sets CsEvent.EventCode equal to "@url:EventCode".

      Note: The Prompt must have No selected in order to avoid the filter from being removed from automated alerts.