Versions Compared

Old Version 3

changes.mady.by.user Alex Xie

Saved on

compared with

New Version 4

changes.mady.by.user Alex Xie

Saved on

Key

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

You can configure a detail element to displayOneList data binding is capable of displaying the following information:

  • Static text   

  • Source data property

...

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.

FeatureExpressionDescriptionExample
Display
Static textAny textDisplay a static text.
  • Header

Source

n/a

Expression => Display

Header  =>  Header

Single properties{Property}Display the value of the bound source property.

Source

{
    "PO_NUMBER": "4500010000",

    "PO_ADDRESS": {

          "CITY1": "Sydney"

     }
}

Expression => Display

  • {PO_NUMBER}                => 4500010000
  • {PO_ADDRESS.CITY1}
  • 4500010000
    • Sydney
    •    => Sydney
    Multiple property{Property1} {Property2}Display the concatenation of the value from multiple properties. 

    Source

    {
        "CostCentreId": "1234",

        "CostCentreName": "Sales Office"
    }

    Expression => Display

    • {
    CostCentreNumber
    • CostCentreId} {CostCentreName}
    1234 Sales 
    •     => 1234 Sales Office 
    Combination of static text and propertiesText1 {Property1} Text2 {Property2}Combining static text (including space) and properties to display more descriptive information or complete sentences.

    Source

    {
        "OrderQuantity": 10,

        "UnitPrice": 10.00

        "UoM": "EA"
    }

    Expression => Display

    • Quantity: {OrderQuantity} {UoM} @ ${UnitPrice} / {UoM}
    •   =>  Quantity: 10.00 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

    Source

    {
        "CreatedOn": "2019-06-24T14:00:00+00:00",

        "ModifiedOn": "2019-06-30T10:10:00+00:00"

    }

    Expression => Display

    • {CreatedOn:dd/MM/yyyy}                  =>  24/06/2019
    • {ModifiedOn:dd/MM/yyyy hh:mm}
  • 12/02/2019
    • 16/02
    •      =>  30/06/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 

    Source

    {
        "OrderQuantity": 100.0,

        "Weight": 12.50,

        "Amount": 1500.50,

    }

    Expression => Display

    • OrderQuantity:#}       => 100
    • {Weight:#.0}              =>  12.5
    • {Amount:
    c}
  • 12
  • 5.1
    • 12:
    • #,###.00}    =>  1,500.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.  

    Source

    {
        "Texts": ["Line 1", "Line 2"],

        "Items": [

            {"Title":"Item 0", "Value":0 },

            {"Title":"Item 1", "Value":100 },

            {"Title":"Item 2", "Value":200 }

        ]

    }

    Expression => Display

    • {
    Strings
    • Texts[0]}            =>  Line 1
    • {Items[2].Title}
  • The text element
    • The title of the second item in the array
    •       =>   Item 2
    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

    Source

    {
        "Items": [

            {"Title":"Item 0", "Value": 0 },

            {"Title":"Item 1", "Value": 100 },

            {"Title":"Item 2", "Value": 200 }

        ]

    }

    Expression => Display

    • {Items[?(@.
    NAME
    • Title=='
    OPERATION
    • Item 2')].
    VALUE
    • Value}    =>  200

    The above expression selects the element in the

    LEAVE_DATA

    Items array where the element's

    NAME

    Title property is '

    OPERATION

    Item 2' and binds to the element's

    VALUE

    Value property.