Creating Advanced Searches

Creating Advanced Searches

Advanced Searches are the most powerful and flexible method for returning specific information from your CRM database. They allow you to quickly see exactly what you’re looking for and also form the foundation of reports created in the Report Assistant.

  1. Click the Search Bar.

  2. Click Advanced Search from the drop-down menu.
  3. Click Create New Search in the upper-left of the new window.
  4. Specify which area of AE CRM you want to search in.
  5. Create your search criteria.
    • Select fields you want to search by from the left. You will be prompted to enter your criteria for that field.
    • You may specify more than one criteria for any field chosen. Be sure to set your logical operator (AND, OR, NOT) correctly.
    • If you select more than one field be sure to set your overall logical operator (AND, OR) correctly.
  6. Choose how to use this search:
    • Click Apply to view your search results.
    • Click Save & Apply to save this search definition for later use before viewing the results. Advanced Searches used with the Report Assistant must be saved before use.

Note that when searching extended text fields, the search will only look at the first 500 characters of the field for a match.

Advanced Search Examples

See all clients belonging to two or more particular Advisors

  1. Create a new Record Advanced Search.
  2. Select the Record > Classifications field.
  3. Select Client from the left list (either double-click or use the Add button).
  4. Click Save changes.
  5. Select the Record > Advisor 1 field.
  6. Select two or more Advisors from the left list.
  7. Set the Logical Operator to OR.
  8. Click Save changes.
  9. Set the Logical Operator for the entire search to AND.
  10. Save or use the definition as needed.

See all incomplete Actions for your entire firm.

  1. Create a new Action Advanced Search.
  2. Select the Actions > Actions Fields field.
  3. Select Action Required from the drop-down.
  4. Select Is True.
  5. Click + Add Criteria.
  6. Select Complete from the drop-down.
  7. Leave Is True unchecked.
  8. Set the Logical Operator to AND.
  9. Click Save changes.
  10. Click Close.
  11. Save or use the definition as needed.

Tip: Add another criteria of Assigned To and set the overall Logical Operator to AND in order to see incomplete Actions for one particular User.

    • Related Articles

    • Using and Managing Advanced Searches

      Applying a Saved Advanced Search Click the Search Bar in the Workspace Grid. Click Advanced Search from the drop-down menu. Select the Advanced Search to apply from the list. Click Apply. Editing Saved Advanced Searches Click the Search Bar in the ...

    • Creating Mass Letters

      Selecting Recipients and Launching the Correspondence Editor Navigate to the Records Workspace. Use the row checkboxes to select the Records you wish to communicate with. You can use Grid Features and Searches to create a recipient list, combined ...

    • Creating Single Letters

      Launching the Correspondence Editor You can begin drafting an individual letter from multiple areas of AdvisorEngine CRM. Options include: Select a single Record from the Record Workspace. From the toolbar, choose Document > Letter. From within a ...

    • Creating Mass Envelopes or Labels

      Envelopes or Labels for multiple Records can be created as part of Creating Mass Letters in AdvisorEngine CRM, but the following process allows you to create Envelopes or Labels independent of any other communication. Navigate to the Records ...

    • Creating and Using Grid Templates

      If you have used the Grid tools to arrange a custom Grid view that suits your needs, you can save that particular arrangement of filters, groups, sorts, columns, display items, and even searches as a Grid Template which may be quickly recalled later. ...