Toad World® Forums

ListAgg Stated to be Available, but I don't see it?

The release notes for 5.1.X indicate that PivotGrids can now summarize by ListAgg function. I'm on 5.1.3.179 (32 bit) and connecting to Oracle.

I have a dataset of ORDER_NUMBER, ORDER_LINE_NUMBER, LINE_ITEM_PART_NUMBER, PART_TYPE.

In the pivot I want to see the ORDER_NUMBER, and then a column that uses ListAgg to show the various PART_TYPE's on each order.

Example of desired outcome:
Capture

I put ORDER_ID in Row Area and PART_TYPE in the Data Area, but when I right-click on PART_TYPE to switch it from Count to ListAgg, ListAgg is not a choice.

Hi,
we announced this feature in TDP 5.1.4 You should be able to see this ListAgg function here.
Filip