Hi, I am trying to retrieve Column Name-Value Pairs from a CDT and th

anagha_abhyankar over 9 years ago

Hi,

I am trying to retrieve Column Name-Value Pairs from a CDT and this CDT is an o/p of a stored procedure and is a Ref cursor.
For eg (using same example in stored proc documentation):
[title=Peppa Pig: Fun at the Fair, author=Collectif, quantity=23, price=3.74], [title=Panda Goes to the Olympics, author=Judith Simanovsky, quantity=7, price=4.99]

If I can capture the column names as Title and its two values, that would be very helpful....

Discussion posts and replies are publicly visible

0 Rick Bivin
Appian Employee
over 9 years ago

You can use the "dot" notation to retrieve the titles. So, cdtName.title will return: Peppa Pig: Fun at the Fair, Panda Goes to the Olympics.

If you are looking to display these values in a grid, you can use index(cdtName, "title", {}) -- this way, if there are no values to return, it returns "{}" or null.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 anagha_abhyankar over 9 years ago

No, I know I can fetch the values, I am looking for something like this as an o/p :
[name=title, value={Peppa Pig: Fun at the Fair;Panda Goes to the Olympics}], [name=author, value={Collectif;Judith Simanovsky}], [name=quantity, value={23;7}], [name=price, value={3.74;4.99}] similar to Name-Value pairs.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel