Versions Compared

Old Version 2

changes.mady.by.user Alex Xie

Saved on

compared with

New Version 3

changes.mady.by.user Alex Xie

Saved on

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

FeatureExpressionDescriptionExampleDisplay
Static textAny textDisplay a static text.
  • Header
  • Header
Single propertyproperties{Property}Display the value of the bound source property.
  • {PO_NUMBER}
  • {PO_ADDRESS.CITY1}
  • 4500010000
  • Sydney
Multiple property{Property1} {Property2}Display the concatenation of the value from multiple properties. 
  • {CostCentreNumber} {CostCentreName}
  • 1234 Sales 
Combination of static text and propertiesText1 {Property1} Text2 {Property2}Combining static text (including space) and properties to display more descriptive information or complete sentences.
  • Quantity: {OrderQuantity} {UoM} @ ${UnitPrice} / {UoM}
  • Quantity: 10 EA @ $10 / EA
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
  • {CreatedOn:dd/MM/yyyy}
  • {ModifiedOn:dd/MM/yyyy hh:mm}
  • 12/02/2019
  • 16/02/2019 10:10
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 
  • {OrderQuantity:#}
  • {Weight:#.0}
  • {Amount:c}
  • 12
  • 5.1
  • 12:50
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.  
  • {Strings[0]}
  • {Items[2].Title}
  • The text element
  • The title of the second item in the array
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/
  • {LEAVE_DATA[?(@.NAME=='OPERATION')].VALUE}

The above expression selects the element in the LEAVE_DATA array where the element's NAME property is 'OPERATION' and binds to the element's VALUE property.