🤓Xplan Hint: Supercharge your Searches with Syntax
Did you know you can use search syntax in Xplan to create powerful and specific advanced searches—beyond what the basic interface allows?
With just a few lines of code, you can target contact details, user fields, adviser roles, and even partner relationships. It’s a game-changer when you need ultra-targeted search results—especially for reporting, segmentation, or compliance checks.
Let’s unpack what’s possible.
🧠 What is Search Syntax?
Search syntax allows you to write logical search queries directly using Xplan’s internal field references. This unlocks additional fields that aren't always available via the standard Advanced Search screen—think adviser roles, contact fields, and even partner data.
The general format looks like this:
<:let result = $entity.compare('field_path', 'operator', 'value'):>
And you enter it here
💡 Practical Examples You Can Try
Cleaning up data gaps - Find clients where Date of birth is blank
Client
Partner
Find clients with a service adviser named Jack Smith
OR done as multiple lines
You can also use these adviser roles:
- client_adviser_service
- client_adviser_paraplanner
- client_adviser_investment
…and more!
🧪 Pro Tips
Syntax search is case-sensitive—double-check spelling!
You can mix syntax and standard search criteria for hybrid searches.
Saved Syntax can be reused across searches, reports, and bulk actions.
Have a go at writing your own syntax—or try tweaking one of the examples above to fit your client data.
👇 Already using search syntax like a pro? Share your favourite syntax use cases in the comments—we’d love to see them in
2 Replies
- courtney.youngblutt
Xplan Expert
I'd almost forgotten about this feature and it is quite easy to use - your two links to the Community articles Field Names and Operators are definitely lifesavers when using syntax to search. Awesome reminder, thanks Andrew.
- rainier.reyes
Advisely Team
Top-shelf tip right here, thanks andrew.wilson.0 ! Very keen to see what great use cases are out there from our syntax search savants 🤓
Welcome to the Advisely forums!
This is where financial advice professionals from all walks of life come together to share knowledge, swap ideas, solve problems, and talk all things growth and efficiency.
Here are some tips when posting in the forums:
- Be respectful and courteous to fellow members
- If a reply helped you, mark it as a solution so other users can find it easily
- Take a moment to read through our Community Guidelines
- For Xplan support issues, it's best to raise a ticket in Iress Connect first. You can also search the discussions for posts about the same issue first before starting a new thread.
- Keep an eye out for our 'Ask me anything (AMA)' threads – these are live text-based Q&As with industry and Xplan experts during a set period of time. Find out when the next one is happening here.
- Don’t be shy! You don’t need to be an expert to help someone out. Many users are looking for practical advice, shared experiences, or just a fresh perspective
- Introduce yourself and meet other members here!
We’re glad you’re here – see you around! 😁
Recent Discussions
Adding attachment icon to Client Portal Messages
Hi Team Please can you consider adding an "attachment" icon like a paperclip to file notes sent to clients via the client portal that have an attachment to them? At the moment, and particularly i...sharyn.evans82 days agoActive Interactor17Views0likes1CommentLifestyle Assets in Client Portal Fact Find
Hi Team, We've just moved from a 3rd party platform that we used for capturing online fact finds, over to the integrated client portal fact find in Xplan. What we're saddened to see is that current...sharyn.evans83 days agoActive Interactor30Views2likes3CommentsWhy Financial Advice Accountability Legislation Needs to Change Now
After my article in the IFA on CSLR and the accountability gap we currently see in Australian financial advice, I have had a number of people ask what specific legislation needs to change to tighten ...tonybeaven4 days agoNetwork Navigator10Views0likes0Comments