Creating a Query for a Notification

This guide will walk you through the process of using Advanced Find to create a Fetch XML query. There are other tools that can be used to achieve this, yet Advanced Find provides a very simple user-friendly interface for designing the query.

Open Advanced Find from the Top Navigation Bar

Select the Record Type for the Notification

Define the query criteria. Make it is simple or complex as needed

Click on Results to ensure records are included in the query criteria

These records will have the Notification displayed after we finish the configuration

Click on the Advanced Find tab to go back to the Query Details

Click Download Fetch XML to download the XML Query

It is possible to open the file in any text editor to view the query

1
2
3
4
5
6
7
8
9
10
11

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
    <entity name="contact">
        <attribute name="fullname"/>
        <attribute name="telephone1"/>
        <attribute name="contactid"/>
        <order attribute="fullname" descending="false"/>
        <filter type="and">
            <condition attribute="mobilephone" operator="null"/>
        </filter>
    </entity>
</fetch>