Home Recent Sign up Sign in
  • View
  • Changes
  • Options
  • Related
  • Edit
    • Filtering with MS Dynamics CRM   

    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

     

    Examples:

     

    Filter on the address1_city field to the value Coventry:

    FIELD: address1_city

    FILTER: Coventry

     

    Filter on accountnumber that are greater or equal to 10000:

    FIELD: accountnumber

    FILTER: GreaterEqual 10000

     

    Cards: Filtering with MS Dynamics CRM Last Editor: Michael Bock  
    Wheeled by Wagn v.0.13.0