Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
2 replies
Subscribers
9 subscribers
Views
1888 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
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....
OriginalPostID-113607
OriginalPostID-113607
Discussion posts and replies are publicly visible
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
0
anagha_abhyankar
over 10 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