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.
- 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
-
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
-
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.
#reworkneeded..Titel ist irreführend