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

@narasimham It isn't possible using the a!queryColumn but definitely it is doable and one of the several possible ways of doing it is, you could create a database view (which contains all the columns from the source table and an additional column that concats the first name and last name columns) and then create a cdt + data store entity that maps to the database view.

@narasimham It isn't possible using the a!queryColumn but definitely it is doable and one of the several possible ways of doing it is, you could create a database view (which contains all the columns from the source table and an additional column that concats the first name and last name columns) and then create a cdt + data store entity that maps to the database view.