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
Not only do process reports not support querying, as Stefan mentioned, but they handle only VERY basic / minimal expressions. That means not only no queries, it means no local variables, absolutely no expression rules that use dictionary syntax (for some reason), and no non-primitive Appian functions at that (and the kicker here is, they don't really publish what functions are "primitive" or not, you just kinda have to figure it out).