Advanced Find operator

Mahadeo Matre

17,021

Like ( 0 )

Report

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	Same as Single Line of Text
	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

Comments

*This post is locked for comments

Community member
Posted at

Advanced Find operator

Last Month

Birthday Last Month

From 1st day of Last month to last day of Last month

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

Why is there not an operator that would go back X Months, and include the FULL month. So,

if today is 09-26-2016 12:15 PM Monday, then records from 07-01-2016 12:00 AM to 08-31-2016 11:59 PM

Like (0)

Report

Advanced Find operator

Comments

Dynamics 365 Community Update – Sep 16th

Announcing Our 2024 Season 2 Super Users!

Dynamics 365 Community Newsletter - September 2024

more Community News