Overview

  • In MS Dynamics CRM you can set simple filters on a fixed value by just selecting the field in the left side and writing the value on the rigth side.
  • In addition to this, a number of functions are supported (on the right side - in FILTER):
    • Equal
    • NotEqual
    • GreaterThan
    • LessThan
    • GreaterEqual
    • LessEqual
    • Like
    • NotLike
    • In
    • NotIn
    • Between
    • NotBetween
    • Null
    • NotNull
    • Yesterday
    • Today
    • Tomorrow
    • Last7Days
    • Next7Days
    • LastWeek
    • ThisWeek
    • NextWeek
    • LastMonth
    • ThisMonth
    • NextMonth
    • On
    • OnOrBefore
    • OnOrAfter
    • LastYear
    • ThisYear
    • NextYear
    • LastXHours
    • NextXHours
    • LastXDays
    • NextXDays
    • LastXWeeks
    • NextXWeeks
    • LastXMonths
    • NextXMonths
    • LastXYears
    • NextXYears
    • EqualUserId
    • NotEqualUserId
    • EqualBusinessId
    • NotEqualBusinessId
    • ChildOf
    • Mask
    • NotMask
    • MasksSelect
    • Contains

If you need to specify several values after the operator, then separate these values with #-sign.

 

Examples:

  • Filter on the address1_city field to the value Coventry:
FIELD NAME FILTER
address1_city Coventry

 

  • Filter on accountnumber that are greater or equal to 1000:
FIELD NAME FILTER
accountnumber GreaterEqual 1000

 

  • Filter on accountnumber between 1000 and 1020:
FIELD NAME FILTER
accountnumber Between 1000#1020

 

 

  1. Getting Started
  2. Documentation
  3. HowTo
  4. Standard Integrations

 

Service News can now be found on our Product Updates Blog 

 

Remember to Subscribe to our Product Updates Blog to receive updates and product news.

 

 

 

 

Wheeled by Wagn v. 1.9.1