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
3284 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
priyal.patel
Appian Employee
over 10 years ago
I have done this by running the full query rule in an activity class parameter on a user input node.
Then on the form, for the dropdown display I choose ac!query.name and for the value choose ac!query.id.
Does that make sense?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
priyal.patel
Appian Employee
over 10 years ago
I have done this by running the full query rule in an activity class parameter on a user input node.
Then on the form, for the dropdown display I choose ac!query.name and for the value choose ac!query.id.
Does that make sense?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data