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
5 subscribers
Views
1042 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Reports
68962 - no subject - Hello,\n\nI'm trying to get information
Aiac 5
over 11 years ago
Hello,
I'm trying to get information from an entity-backed record using query record, but i'm having troubles with the filter option:
Here's my expression rule definition:
queryrecord(ri!recordType, rule!APN_querySelection(ri!fields, rule!APN_logicalExpressionOR(apply( rule!APN_queryFilter, ri!value, "EQUALS", ri!field )), rule!APN_pagingInfoAll()))
And this is the error message:
Expression evaluation error at function 'queryrecord': Error evaluating function 'queryrecord' : Invalid logical expression operator given: [[AND]]. Valid operators are: [{1}].
I'm using the common appian object app
Regards...
OriginalPostID-68962
Discussion posts and replies are publicly visible
0
cody.smith
Appian Employee
over 11 years ago
Sorry, Ayax. The OR operator is not yet supported in queryrecord(). As a workaround, you could apply() over queryrecord() and union() the results, although that will perform slower.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Aiac 5
over 11 years ago
Thanks Cody! I'll try your suggestion
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel