I have 2 fields(LastName and FirstName), I want to return it as one field(name)

Question

I have 2 fields(LastName and FirstName), I want to return it as one field(name) concatenated in a!Query ,I did following using a!queryColumn , it is not working any suggestions appreciated

a!querySelection(columns: {
a!queryColumn(field: "LastName"&" "&"FirstName", alias="Name" ),

prestonb · Answer

Once you run your query, you have a data subset. You can then use merge and apply to process the data subset one name at a time.

We do something similar in this code, concatenating two fields together with a dash.

with(
local!query: a!query(pagingInfo: topaginginfo(1, -1)),
local!ds: a!queryEntity(entity: cons!RC_REQUEST, query: local!query),
local!merge: merge(local!ds.data.tRequestAction, local!ds.data.tRequestCategory),
apply(fn!concat(_, "-", _), local!merge)
)