Client Management - Client Searching: Advanced Search - Advanced Search Criteria

Client Management - Client Searching: Advanced Search - Advanced Search Criteria

Advanced Search Criteria

 

List item must meet all criteria

The checkbox List item must meet all criteria can be used when a client may have multiple items in categories, such as two or more postal addresses.

With the checkbox unticked, AND criteria need to be met across the client's details as a whole, so a search for Suburb = Sydney AND State = Vic may return a result if the client has two addresses, one in Sydney and one in Victoria.

With the checkbox ticked, the criteria must be met within a single item, ie. The client must have an address that contains both Sydney and Vic. 

 

Data Exists

Data Exists option allows you to search for clients that have no data saved in a Field Group. For example, you can find all clients that have no Address data saved.

Other than the Entity field group, all Field Groups can be searched against. The Entity Field Group contains required information such as a client’s Entity ID, First Name and Surname, and all client entities will have data saved against the Entity Field Group.

 

Search using Dates

When using dates as criteria the follow information applies:

  • Choose an Operation with 'date' at the end, as these a specifically designed for date functions.
  • 'Equal Month', 'Older than Month', 'Less than Month' operations search only in the month field, and ignores day and year.
  • 'Older than' and 'Later than' are specifically designed to search for notes, although may be used elsewhere

 

Single Criteria

  1. Click Add in the Advanced Search screen. A variety of different searching criteria displays.

  2. Using the drop-down lists and boxes, enter a single criteria to be searched.
  3. Click Add. The search criteria displays, listing the current criteria.
  4. Click Search.           

 

Multiple Criteria

  1. Click Add in the Advanced Search screen. A variety of different searching criteria displays.
  2. Using the drop-down lists and boxes, enter a criteria to be searched.
  3. Click Add More. A new selection of search criteria displays.
  4. Enter the search criteria. Click Add on the final criteria. The search criteria displays, listing the current criteria.

  5. Click Search.

 

OR/AND/NOT Criteria

Searches using OR/AND/NOT logical filters are very flexible, and can range in complexity from a simple 2-term OR search to a multilevel, multi-term criteria.

By default results must meet all criteria, however by using the boolean functions of AND, OR and NOT searches can be generated where results can meet one of multiple different requirements.

  • AND - all criteria within the AND function must be met.
  • OR - results will meet any one or more criteria in the function.
  • NOT - inverts the other two functions (returns the opposite results). NOT AND returns clients that don't meet all the criteria in the AND function, and NOT OR returns clients that don't meet any of the criteria.

Note: These functions can only be used for searching Field or Group criteria.


Using AND / OR

  1. Click Add. A variety of different searching criteria displays.
  2. Click the Filter List A drop-down list displays.

  1. Select the AND/OR function.
  2. Click Add. The search criteria displays, listing the function.

     
  1. Click the Add Icon next to the function. The criteria selection window opens.

  2. Add the first search criteria 
  3. Click the Add Icon next to the function. The criteria selection window opens.
  4. Add the second search criteria
  5. Add any additional search criteria



  6. Click Search when all criteria have been entered

 

Using NOT

  1. When adding an AND/OR function, tick the NOT: Negate the filter result



  2. Click Add. A NOT function has been created.

    • Related Articles

    • Client Management - Client Searching: Advanced Search

      Advanced Search Overview The purpose of this guide is to provide you with instructions how to use the Advanced Search function of XPLAN. To view the IRESS Insights Video, please view the following link here. (Created by Anthony Derriscott on Feb 19, ...

    • Client Management - Client Searching: Advanced Search - Search Syntax

      Search Syntax Overview Syntax searching allows you to manually build a search criterion using XPLAN syntax. Click Add in the Advanced Search screen. A variety of different searching criteria displays. Select the Syntax Enter the Search Syntax Click ...

    • Client Management - Client Searching: Quick Search

      Quick Search Overview The purpose of this guide is to provide you with instructions on how to perform a Quick Search in XPLAN.  To view the IRESS Insights Video, please view the following link here. (Created by Anthony Derriscott on Feb 19, 2018) ...

    • Client Management - Search: Insurance Policy

      Searching for Insurance Policy Overview The purpose of this guide is to provide instructions on using the Insurance Policy Search function in XPLAN.  Insurance Policy searching can be conducted using the Advanced Search function, alternatively you ...

    • Client Management - Search: Portfolio Holdings/ Positions

      Searching for Portfolio Holdings/Position Overview The purpose of this guide is to provide instructions on using the Portfolio Position Search function in XPLAN.  The Portfolio Positions function allows you to search for portfolio positions across ...

    • Popular Articles

    • Wealth Axis Files - Naming Convention

      File Format: Date, Client Name, File Name Date - yymmdd E.g: 12 Sept 2013 - 130912 E.g: Undated - 010101 Client Names One Client / Only primary client (John Smith) E.g: Smith, J Two Clients (Primary and Secondary Client/Client and Partner) - Married ...

    • Wealth Axis Wizards - Overview

      Overview  This article is designed to help you effectively use the Wealth Axis Wizards in XPLAN. The key features of the Wealth Axis Wizards are: Integration with key modules such as Client Focus, Portfolios (IPS), Risk Researcher, WealthSolver and ...

    • New User Manual - Admin

      XPLAN and the Advice Process Overview Many advisers use the Advice to Client process to manage the advice process in their business. To enable participants to be able to relate to the different modules in XPLAN, this course is structured along the ...

    • Administration - Email: Setting up the Outlook Plugin

      Outlook Plugin - Overview  Outlook Plugin is a function available with XPLAN that allows you to quickly and easily save and record email correspondence in the XPLAN document library as a Note that is linked to a client or user entity. This allows for ...

    • XPLAN Workshop - XPLAN Client Setup

      Introduction Overview     Each practice deals with leads, referrals and potential clients differently. However, most practices have a system regarding the way client information is recorded and relationships with clients are managed. In this section, ...

    • Recent Articles

    • XPLAN Legislative Rates June 2022

      XPLAN Legislative Rates - June 2022 Legislative rates have been updated to reflect: 1. Social Security rates effective July 2022 2. AFSA Retirement Standard Benchmarks for the March Quarter 2022.  Social Security Rate Changes - July 2022 The rate ...

    • XPLAN: Task Notifications - Redirecting

      XPLAN: Redirecting Task Notifications XPLAN task notifications can be sent to your Email Inbox (e.g. Outllok, Gmail) to notify you if a task has been created, unactioned, is overdue or complete. If the task notifications cannot be turned off, then ...

    • XPLAN Version Enhancements - 18 November 2021 (Version 21.11.195)

      XPLAN Version Enhancements - 18 November 2021 (Version 21.11.195) Client Focus Digital Signature Notification will Honour the "Override from Address" when sent by Super User The notify signatories template configured in system settings > client focus ...

    • XPLAN Version Enhancements - November 2021 (Version 21.11.194)

      XPLAN Version Enhancements - November 2021 (Version 21.11.194) Client Focus New Current Residential Address Field A new field, current residential address, has been added to record a client’s current address. When entering the first address for a ...

    • XPLAN Datafeeds: HUB24 Enhancements (v4.3) 29 October 2021

      HUB24 Enhancements: 29 October 2021 HUB24 have released enhancements to their  XPLAN EPI 4.3 datafeeds, to be effective 15 November 2021. Below is the information directly from HUB24 on the enhancements. The Individual Holding extract is where the ...