mscrm-addons.com - Blog

IMPORTANT INFORMATION

This blog is deprecated since July 2020.The articles below are no longer maintained and might contain outdated information. 
You can find the most acutal and relevenat information in our Knowledge Base at support.mscrm-addons.com

News.mscrm-addons.com Blog

rss

Hello and welcome to our blog! What can we do for you? Are you looking for further technical information or step-by-step instructions to our products? Or would you like to read the latest news on mscrm-addons? Please feel free to browse our blog for detailed information and to share our posts!


DocumentsCorePack Condition Syntax (Dynamics 365)

Certain properties of DocumentsCorePack templates consist of conditions based on Dynamics 365 fields. This article covers the basic syntax and the advanced options that can be used.
Several DocumentsCorePack properties support the same syntax. A list of these properties can be found at the end of this article. 

  1. The basic syntax:

    Fields from Dynamics 365 are enclosed by << and >> when you insert them from the tree view.

    Figure 1: Fields

    Fixed text has to be typed manually into the text field and has to be enclosed with single quotes ( ' ).


    Figure 2: Fixed text
    To combine several Dynamics 365 fields and fixed text you have to use the plus sign (+). (see figure 3)

    Figure 3: Plus sign
  2. Supported datatypes and available operators

Datatype

Value

Bool

True, false, 0, 1

Decimal/Numbers

Format z.B.: 1.1

Currency

€ 1.1 or $1.1 (when decimal, the currency symbols €, $ are deleted)

Date

#2015-12-13# or #2015-12-13T12:00:59+01:30#

Text

 

 

Operator

Description

Used with the following datatypes

=

equals

for each

<>

does not equal

for each

>

greater than

for each

<

less than

for each

>=

greater than or equal

for each

<=

less than or equal

for each

+

addition

Decimal, Numbers, Currency, Text

-

substraction

Decimal, Numbers, Currency

*

multiplication

Decimal, Numbers, Currency

/

division

Decimal, Numbers, Currency

%

modulo

Decimal, Numbers, Currency

LIKE

LIKE comparison, wildcard *,%

text

 

Boolean Operators: AND, OR, NOT

 

 

  1. Special values and functions

     

Null / NULL

null

true

true

false

false

ISNULL

ISNULL(field, substitute value)

LEN

LEN(text) returns the string-length

IIF

IIF(condition, valuetrue, valuefalse)

TRIM

TRIM(text) deletes the whitespace at the beginning/end

SUBSTRING

SUBSTRING(text, start, len)

CONVERT

CONVERT(value, destType) destType must be a .Net datatype, e.g.: System.Int32

 

This syntax applies to the following properties and special fields:

Template Properties 

  • Remove Watermark

That’s it! We appreciate your feedback! Please share your thoughts by sending an email to support@mscrm-addons.com.




Comments are closed.