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 is replaced with the value of the property. Texts outside of the {} are static and not changed.

Feature

Expression

Description

Example

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

  • {Property:dd/MM/yyyy}

  • {Property:yyyy-MM-dd hh:mm:ss}

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[?(@.Property=='value to be searched')].ChildProperty}

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/

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.

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

Requirement

Regex Setting

Example

Remove leading zero.

Pattern: (^|\s)0+

  • 000123 Sales Office                           => 123 Sales Office

  • Cost centre: 0000123 Sales Office     => Cost centre: 123 Sales Office

Format a number that has only zeros

Pattern: (^|\D)0+(\D|$)

Replacement: 0,

  • 0000                          => 0

  • Batches: 000, 1         => Batches: 0, 1