How can I show the data of two local variables into one grid

I am using two local variables and the data is coming via expression rules (there are multiple columns)

local!empStatus: index(rule!EO_getEmpStatus(),"data",{}),
local!empDetail: index(rule!EO_getEmpDetail(),"data",{})

I want to use the data of local!empStatus and local!empDetail into single read-only grid.

  Discussion posts and replies are publicly visible

Parents
  • 2nd one 

    load(

    local!empStatus: {{id:3,empId:1,status:"Active"}, {id:2, empId:2, status:"Active"}, {id:1, empId:3, status: "Inactive"}},
    local!empDetail: {{id:1,name:"ABC"}, {id:2, name:"PQR"}, {id:3, name: "LMN"}},

    a!formLayout(
    label:"Form",
    contents:{
    a!gridField(
    label:"grid",
    data:local!empDetail,
    pageSize:5,
    pagingSaveInto:fv!pagingInfo,
    columns:{
    a!gridColumn(
    label:"Name",
    value:fv!row.name
    ),
    a!gridColumn(
    label:"Status",
    value:index(
    index(
    local!empStatus,
    wherecontains(
    tointeger(fv!row.id),
    tointeger(index(local!empStatus,"empId",{}))
    ),
    {}
    ),
    "status",
    {}
    )
    )
    }
    )
    }
    )
    )

Reply
  • 2nd one 

    load(

    local!empStatus: {{id:3,empId:1,status:"Active"}, {id:2, empId:2, status:"Active"}, {id:1, empId:3, status: "Inactive"}},
    local!empDetail: {{id:1,name:"ABC"}, {id:2, name:"PQR"}, {id:3, name: "LMN"}},

    a!formLayout(
    label:"Form",
    contents:{
    a!gridField(
    label:"grid",
    data:local!empDetail,
    pageSize:5,
    pagingSaveInto:fv!pagingInfo,
    columns:{
    a!gridColumn(
    label:"Name",
    value:fv!row.name
    ),
    a!gridColumn(
    label:"Status",
    value:index(
    index(
    local!empStatus,
    wherecontains(
    tointeger(fv!row.id),
    tointeger(index(local!empStatus,"empId",{}))
    ),
    {}
    ),
    "status",
    {}
    )
    )
    }
    )
    }
    )
    )

Children
No Data