Advanced Filter Mode

Advanced filter logic

You can create your own advanced filter logic by directly using Salesforce Object Query language. This is for advanced Salesforce users only but it gives you the ability to reference the full power of SOQL including referring to lookup fields within your filter. This advanced filter text box is SOQL following the WHERE clause. For example to use the Campaign lookup field on Lead we could use the syntax below:

Logic to avoid

Advanced filter mode allows complete access to create any query which is flexible, but also potentially can allow inefficient queries to be created. Avoid using the following:

• Not equals !=
• Not in