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
9 replies
Subscribers
4 subscribers
Views
3288 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Process
I have a database table that contains group records. The fields are Id, Name, T
helmuta
over 10 years ago
I have a database table that contains group records. The fields are Id, Name, Type, Category, Status, etc. I am trying to retrieve the name for a given Id.
Let me draw an example:
Id Name Type Category Status
1 OMG Cookies Project Food Active
2 Dream Home Project Home Active
I have created a query rule that returns the entire record. The input is the record id. So in the above given record id 1 it would return
1 OMG Cookies Project Food Active but all I really want is the name OMG Cookies.
I have thought of a couple of workarounds to get the name only but I was hoping there is an easy way for me to do this without doing a lot of unnecessary stuff.
Any help would be appreciated. ...
OriginalPostID-96242
OriginalPostID-96242
Discussion posts and replies are publicly visible
Parents
0
helmuta
over 10 years ago
One more question. I have a new query rule that returns all of the active records and I need to expose the names in a dropdown and be able to store the associated id in a pv.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
helmuta
over 10 years ago
One more question. I have a new query rule that returns all of the active records and I need to expose the names in a dropdown and be able to store the associated id in a pv.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data