...
- 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.
...
| Requirement | Regex Setting | Example |
|---|---|---|
| Remove leading zero. | Pattern: (^|\s)0+ |
|
| Format a number that has only zeros | Pattern: (^|\D)0+(\D|$) Replacement: 0, |
|
...