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

anagha_abhyankar over 10 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

Parents

0 Rick Bivin
Appian Employee
over 10 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

Reply

0 Rick Bivin
Appian Employee
over 10 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

Children

No Data