Attribute Type(s)
|
Operators
|
Result
|
|
Single Line of Text
Customer Lookup Status Status Reason Two Option Option Set |
Equals
|
First Name Equals John
|
John
|
Does Not Equal
|
First Name Does Not Equals John
|
Don
|
|
Contains
|
First Name Contains Alli
|
Allison, Hallie
|
|
Does Not Contains
|
First Name Does Not Contains Alli
|
Abraham, Alex etc
|
|
Begins With
|
First Name Begins With Alli
|
Allison
|
|
Does Not Begins With
|
First Name Does Not Begins With Alli
|
Abraham, Alex etc
|
|
Ends With
|
First Name Ends With Son
|
Allison
|
|
Does Not Ends With
|
First Name Does Not Ends With Son
|
Abraham, Alex etc
|
|
Contains Data
|
First Name Contains Data
|
All records where First Name has something
|
|
Does Not Contains Data
|
First Name Does Not Contains Data
|
All records where First Name is empty.
|
|
Multiple Line of Text
|
Contains
|
Same as Single Line of
Text
|
|
Does Not Contains
|
|||
Begins With
|
|||
Does Not Begins With
|
|||
Ends With
|
|||
Does Not Ends With
|
|||
Contains Data
|
|||
Does Not Contains Data
|
|||
Currency
Whole Number Decimal Number Floating Point Number |
Equals
|
Same as Single Line of
Text
|
|
Does Not Equal
|
|||
Contains Data
|
|||
Does Not Contains Data
|
|||
Is Greater Than
|
Salary Is Greater Than 5000
|
5001, 6000, 10000
|
|
Is Greater Than or Equal To
|
Salary Is Greater Than or Equal To
5000
|
5000,5001, 6000, 10000
|
|
Is Less Than
|
Salary Is Less Than 5000
|
4999, 4500
|
|
Is Less Than or Equal To
|
Salary Is Less Than or Equal To 5000
|
5000, 4999, 4500
|
|
Primary Key
|
Equals
|
Contact Equals Allison
|
|
Does Not Equal
|
Same as Single Line of
Text
|
||
Contains Data
|
|||
Does Not Contains Data
|
|||
Owner
|
Equals Current User
|
Owner Equals Current User
|
Records owned by logged in user
|
Does Not Equal Current User
|
Owner Does Not Equal Current User
|
Records not owned by logged in User
|
|
Equal Current User Or His Reporting Hierarchy
|
Owner Equal Current User Or His
Reporting Hierarchy
|
Records owned by current user or other users from his reporting
hierarchy
|
|
Equal Current User And His Teams Or His Reporting Hierarchy And
Their Teams
|
Owner Equal Current User And His
Teams Or His Reporting Hierarchy And Their Teams
|
Records owned by current user and all teams of current user Or
other users and their teams from his reporting hierarchy
|
|
Equals Current User's Teams
|
Owner Equals Current User's Teams
|
Records owned by all teams of current user.
|
|
Equals Current User Or User's Teams
|
Owner Equals Current User Or
User's Teams
|
Records owned by current user or all teams of current user.
|
|
Equals
|
Same as Single Line of
Text
|
||
Does Not Equal
|
|||
Contains Data
|
|||
Does Not Contains Data
|
|||
Contains
|
|||
Does Not Contains
|
|||
Begins With
|
|||
Does Not Begins With
|
|||
Ends With
|
|||
Does Not Ends With
|
|||
Date Time
|
On
|
Birthday On 12/15/1985
|
12/15/1985
|
On or After
|
Birthday On or After 12/15/1985
|
12/15/1985 ,
12/16/1985,01/01/1990
|
|
On or Before
|
Birthday On or Before 12/15/1985
|
12/15/1985 ,
12/14/1985,01/01/1980
|
|
Yesterday
|
Birthday Yesterday 12/15/1985
|
12/14/1985
|
|
Today
|
Birthday Today
|
If today = 09/23/2016, then 09/23/2016
|
|
Tomorrow
|
Birthday Tomorrow
|
If today = 09/23/2016, then 09/24/2016
|
|
Next 7 Days
|
Birthday Next 7 Days
|
Excluding today next seven days
|
|
Last 7 Days
|
Birthday Last 7 Days
|
Excluding today last
seven days
|
|
Next Week
|
Birthday Next Week
|
From upcoming Sunday to Saturday records
|
|
Last Week
|
Birthday Last Week
|
From last Saturday to Sunday records
|
|
This Week
|
Birthday This Week
|
Current Week - Sunday to Saturday
|
|
Next Month
|
Birthday Next Month
|
From 1st day of Next month to last day of Next month
|
|
Last Month
|
Birthday Last Month
|
From 1st day of Last month to last day of Last month
|
|
This Month
|
Birthday This Month
|
From 1st day of current month to last day of current month
|
|
Next Year
|
Birthday Next Year
|
if current year is 2016, then records from 01/01/2017 to
12/31/2017
|
|
Last Year
|
Birthday Last Year
|
if current year is 2016, then records from 01/01/2015 to
12/31/2015
|
|
This Year
|
Birthday This Year
|
if current year is 2016, then records from 01/01/2016 to
12/31/2016
|
|
Last X Hours
|
Createon Last X Hours 2
|
If current time is 12:10 PM, then records from 10:00 AM to 12:10
PM
|
|
Next X Hours
|
Createon Next X Hours 2
|
If current time is 12:10 PM, then records from 12:10 PM to 2:00
PM
|
|
Last X Days
|
Createon Last X Days 2
|
If today is 09-26-2016, then records from 09-24-2016 12:00 AM,
to 09-26-2016
|
|
Next X Days
|
Createon Next X Days 2
|
If today is 09-26-2016 12:12 PM, then records from 09-26-2016
12:12 PM, to 09-28-2016 12:00 AM
|
|
Last X Weeks
|
Createon Last X Weeks 2
|
If today is 09-26-2016 12:15 PM Monday, then records from
09-12-2016 12:00 AM to 09-26-2016 12:15 PM
|
|
Next X Weeks
|
Createon Next X Weeks 2
|
If today is 09-26-2016 12:15 PM Monday, then records from
09-26-2016 12:15 PM to 10-10-2016 12:00 AM
|
|
Last X Months
|
Createon Last X Months 2
|
If today is 09-26-2016 12:15 PM Monday, then records from
07-26-2016 12:00 AM to 09-26-2016 12:15 PM
|
|
Next X Months
|
Createon Next X Months 2
|
If today is 09-26-2016 12:15 PM Monday, then records from
09-26-2016 12:15 PM to 11-26-2016 12:00 AM
|
|
Last X Years
|
Createon Last X Years 2
|
If today is 09-26-2016 12:15 PM Monday, then records from
09-26-2014 12:00 AM to 09-26-2016 12:15 PM
|
|
Next X Years
|
Createon Next X Years 2
|
If today is 09-26-2016 12:15 PM Monday, then records from
09-26-2016 12:15 PM to 09-26-2018 12:00 AM
|
|
Any Time
|
Createon Any Time
|
Where createdOn is not null.
|
|
New operators in 2016
|
Older Than X Minutes
|
Createon Older Than X Minutes 20
|
All records except records created in last 20 mins. If today is
09-26-2016 12:20 PM, then all records created before 09-26-2016 12:00 PM
|
Older Than X Hours
|
Createon Older Than X Hours 2
|
All records except records created in last 2 hours. If today is
09-26-2016 12:20 PM, then all records created before 09-26-2016 10:20 AM
|
|
Older Than X Days
|
Createon Older Than X Days 2
|
All records except records created in last 2 days. If today is
09-26-2016 12:20 PM, then all records created before 09-24-2016 12:20 PM
|
|
Older Than X Weeks
|
Createon Older Than X Weeks 2
|
All records except records created in last 2 Weeks. If today is
09-26-2016 12:20 PM, then all records created before 09-12-2016 12:20 PM
|
|
Older Than X Months
|
Createon Older Than X Months 2
|
All records except records created in last 2 Months. If today is
09-26-2016 12:20 PM, then all records created before 07-26-2016 12:20 PM
|
|
Older Than X Years
|
Createon Older Than X Years 2
|
All records except records created in last 2 Years. If today is
09-26-2016 12:20 PM, then all records created before 09-26-2014 12:20 PM
|
|
Contains Data
|
Same as Single Line of
Text
|
||
Does Not Contain Data
|
|||
In Fiscal Year
|
Createon In Fiscal Year
|
Filters are same as any
other Datetime operation but values are based on how you have fiscal Year and
Period.
|
|
In Fiscal Period
|
Createon In Fiscal Period
|
||
In Fiscal Period and Year
|
Createon In Fiscal Year and Period
|
||
In or After Fiscal Period
|
Createon In or After Fiscal Period
|
||
In or Before Fiscal Period
|
Createon In or Before Fiscal Period
|
||
Last Fiscal Year
|
Createon Last Fiscal Year
|
||
This Fiscal Year
|
Createon This Fiscal Year
|
||
Next Fiscal Year
|
Createon Next Fiscal Year
|
||
Last X Fiscal Year
|
Createon Last X Fiscal Year
|
||
Next X Fiscal Year
|
Createon Next X Fiscal Year
|
||
Last Fiscal Period
|
Createon Last Fiscal Period
|
||
This Fiscal Period
|
Createon This Fiscal Period
|
||
Next Fiscal Period
|
Createon Next Fiscal Period
|
||
Last X Fiscal Periods
|
Createon Last X Fiscal Period
|
||
Next X Fiscal Periods
|
Createon Next X Fiscal Period
|
||
Tuesday, September 27, 2016
Advanced Find operator
Subscribe to:
Posts (Atom)