OneList data binding is capable of displaying the following information:
- Static text
- Source data property
- Combination of static text and source properties
How to create the binding expression
- Select field or click on the
button to open the Source Properties Selector; - Select the property in the tree to setup the binding. Note: the tree only shows the properties that are valid for binding in the current context.
- 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 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. | Sourcen/a Expression => Display
|
| Single properties | {Property} | Display the value of the bound source property. | Source{ "PO_ADDRESS": { "CITY1": "Sydney" } |
| Multiple property | {Property1} {Property2} | Display the concatenation of the value from multiple properties. | Source{ "CostCentreName": "Sales Office" Expression => Display
|
| 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. | Source{ "UnitPrice": 10.00 "UoM": "EA" Expression => Display
|
| 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 | Source{ "ModifiedOn": "2019-06-30T10:10:00+00:00" } Expression => Display
|
| 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 | Source{ "Weight": 12.50, "Amount": 1500.50, } Expression => Display
|
| 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. | Source{ "Items": [ {"Title":"Item 0", "Value":0 }, {"Title":"Item 1", "Value":100 }, {"Title":"Item 2", "Value":200 } ] } Expression => Display
|
| JSON path query | {ArrayProperty[?(@.Title='the title')].Value} | 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/ | Source{ {"Title":"Item 0", "Value": 0 }, {"Title":"Item 1", "Value": 100 }, {"Title":"Item 2", "Value": 200 } ] } Expression => Display
The above expression selects the element in the Items array where the element's Title property is 'Item 2' and binds to the element's Value property. |
Additional binding configuration
Select the Binding Configurations tab in the Source Property Selector to setup additional binding configuration.
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 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, |
|