#aggregation I would like to aggregate the information I am bringing back in a d

@georgeu Hi, here goes few thoughts in my mind and might help you, just in case if you aren't aware:

1. Create a view in database and map a cdt in Appian and then query the corresponding data store entity.

2. Create a stored procedure and make a call to it in Appian by sending the inputs to it.

To the best of my knowledge, the functionality desired by you with respect to concatenation isn't available with a!queryEntity.

I should say that the view or stored procedure should do the job as desired by you (for instance, group by and group concat operations) and finally you would be left with querying these objects in Appian to obtain the data.

Hi George, I agree with shiva, we can do it through views and may be we can use some of the built in functions like LISTAGG for instance in oracle.

You can also try to pre-concatenate the data when you add it in the DB. That way you avoid the overhead of having to concatenate the data in real-time. This should be feasible if you will only need the data in concatenated form.

If you do need both the concatenated version of the data as well as separated, you can still follow this approach by creating a separate table dedicated to store the concatenated data and use that in your view or queryEntity as applicable.