Question
convert a!query to value to be saved
seems I almost there, the problem I found is that the value i supposed to be saved for a!query is not the standard form. What should be the correct one?
a!save(target:ri!userrole.USER_ID,
value:cast(type!Integer,
a!queryEntity(
entity:cons!KONE_Development_userrole_Constant,
fetchTotalCount:true,
query:a!query(
selection: a!querySelection(
columns: {
a!queryColumn(
field: "USER_ID"
)
}
),
filter:a!queryFilter(
field:"NAME",operator:"=",
value:ri!userinputsheet.kone_user_name,
applyWhen:not(isnull(ri!userinputsheet.KONE_user_name))
),
pagingInfo:a!pagingInfo(
startIndex: 1,
batchSize: 50
)
)
).data.USER_ID)
),