...
- Continue the above step to bind multiple properties to the same field.
- Optionally, edit the binging expression to
- Change the order of the properties;
- Add static text;
- Add formatting; .
Syntax of the binding expression
Path of the source property is enclosed with {}. The text including the {} braces are is replaced with the value of the property. Texts outside of the {} are static and not changed.
| Feature | Expression | Description | Example | |||||
|---|---|---|---|---|---|---|---|---|
| Static text | Any text | Display a static text. |
| |||||
| Single properties | {Property} | Display the value of the bound source property. |
| |||||
| Multiple property | {Property1} {Property2} | Display the concatenation of the value from multiple properties. |
| |||||
| Combination of static text and properties | Text1 {Property1} Text2 {Property2} | Combining static text (including space) and properties to display more descriptive information or complete sentences. |
| |||||
| Date and time format |
| Display date and time in specific format. More detail of date & time format can be found at: https://docs.microsoft.com/en-us/dotnet/standard/base-types/custom-date-and-time-format-strings |
| |||||
| Number & currency format | {Property:#.00} {Property:#.c} | Display number in specific format. More detail of number format can be found at: https://docs.microsoft.com/en-us/dotnet/standard/base-types/standard-numeric-format-strings |
| |||||
| Array element | {ArrayProperty[Index]} {ArrayProperty[Index].Property} | Display the text in an string array at the specific index, display a property of the array element at the specific index. Note: index starts from 0. |
| |||||
| JSON path query | {ArrayProperty[?(@.TitleProperty=='the titlevalue to be searched')].ValueChildProperty} | Evaluate the JSON Path Query at runtime and display the selected value. More detail about JSON Path can be found at: https://restfulapi.net/json-jsonpath/ |
|
...
A value converter is only required when the bound source property needs to be converted to number or date-time for formating:
- DateTime Converter - converts a string to the native date-time value;
- Double Converter - converts a string to a numeric value;
- SAP Date Converter - converts SAP date string YYYYMMDD to the native date value;
- SAP Time Converter - converts SAP time string to the native time value.
If sepcified, the Regex Pattern and Regex Replacement Value are applied to the result of the binding expression to achieve further Use Regular Expression to fulfil advanced formatting requirement. More about regular expression can be found at: https://docs.microsoft.com/en-us/dotnet/standard/base-types/regular-expressions
| Requirement | Regex Setting | Example |
|---|---|---|
| Remove leading zero. | Pattern: (^|\s)0+ |
|
| Format a number that has only zeros | Pattern: (^|\D)0+(\D|$) Replacement: 0, |
|