Is it possible to query a datastore entity to give result based on unique combination of two columns and group record values as separated by commas for other columns.

saileshd over 8 years ago

Is it possible to query a datastore entity to give result based on unique combination of two columns and group record values as separated by commas for other columns. For Ex:
Sr. no deal no. Description
123 abc Desc1
123 abc Desc2

Can I query this datastore it to return one record as follows:
123 abc Desc1, Desc2

Discussion posts and replies are publicly visible

0 Lakshmi Meyyappan over 8 years ago

You cannot perform text aggregation from a query in Appian, but you can create a View in your database to aggregate the text (syntax will depend on which RDBMS you're using), then Appian can just query the view.
I believe the function you would use in mySQL is GROUP_CONCAT()
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel