I have created a "CRD column" in process report which is required to take the data from "CRD column" in User database table. I tried querying the data and indexed it but it's not populating the column with data in the process report. The column is populating null. Please suggest me alternate solution so that I can achieve this data populating.
index(rule!CP_QRY_User(
username:pv!username,
returnCdt:true,
pagingInfo:a!pagingInfo(
startIndex:1,
batchSize:1
)
),"crd",null)
i was using this expression to get data for respective column in CRD defintion in the process report.
Discussion posts and replies are publicly visible
As Stefan mentioned querying in process reports are not gonna happen. If its just a matter of displaying in the grid, Why not do this in at the interface level, querying the complete data from the rule in a local and indexing the related value using the identifier respect to the row.
Loading too much data into an interface can lead to memory and performance issues. While this would work, I would not make it a general recommendation.
A single call in the local variable and then using whereContains() in the row would cause performance issues too? I wasn't aware :-o
Depends on the data volume and the number of lookup cells.