Create an Activity Flex Query

Instructions

You create Activity Flex Queries on the Custom Flex Queries screen.

  1. Click Performance & Reports > Flex Queries.

    Image of flex query panel in Portal.

  2. Click + icon in the Activity Flex Query Templates section to open the Create an Account Query.

    Image of the activity flex query templates in Portal.

  3. Enter the name of the Activity Flex Query.

  4. In Sections, click each section that you want to appear in your Flex Query.

    Image of flex query sections in Portal.

  5. As you select each section, a pop-up opens with all possible fields in the selected section.

    • Click each field that you want to appear in the Flex Query.

    • Change the order in which the fields will appear by dragging each field to a different position by the bars symbol on the right.

    • Click Save.

      Image of flex query account information in Portal.

  6. In the Delivery Configuration section, choose how you want the report delivered.

    • Accounts - Click Add/Edit Accounts to bring up the Account Selector

    • Models - Choose from Optional or All

    • Format - Choose from XML, CSV, Text (Pipe), Text (Tab)

    • Period - Choose from Last Business Day, Last Business Week, Last Month, Last Quarter, Last 30 Calendar Days, Last 365 Calendar Days, Last N Calendar Days, Month to Date, Quarter to Date or Year to Date

      Image of flex query delivery configuration

  7. Choose other options for your report in the General Configuration section.

    Image of flex query general configuration

  8. Click Continue to review your Activity Flex Query configuration. Click Create to create the report or Back to go the previous screen to make any changes.

    Image of the review activity flex query in Portal.

 

Additional Resources