Can we do string concatenation on OQL View entities to improve datagrid columns with one-to-many associations?
0
I want to improve the performance of one of our datagrids by converting them to an OQL view entity. One of the performance issues is a Datasource dataview inside the datagrid due to a one-to-many association.Assume a datamodel with CarModel and Buyer and each CarModel can be bought by multiple persons (buyer), how would I show a datagrid with all CarModels and a single column with comma-separated all buyers while using a OQL View Entity?
asked
Sander Schaeffer
1 answers
1
That's what string_agg is for, but you'll need 11.2 or higher to use it in a view entity. In the meantime you could use a microflow source for your grid and execute the OQL in a java action and return your objects.