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
4 replies
Subscribers
7 subscribers
Views
1221 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
AI and Rules
Any suggestions on how I can get results back from a query rule where my value i
Chasity Davis
over 10 years ago
Any suggestions on how I can get results back from a query rule where my value is not null? It appears I can't use null as an input so I'm at a loss. Thanks!...
OriginalPostID-100758
OriginalPostID-100758
Discussion posts and replies are publicly visible
0
Bishnu Panigrahi
Appian Employee
over 10 years ago
Here are a few ideas I can think of:
1. Use a query database node: ex. select <fieldA> from <table> where <fieldB> is not NULL
2. Create a view that filters the rows based on these null values. Then query that table.
3. Use a query rule to call back a bigger datasubset, then filter nulls in process.
There are positives and downsides to each scenario, so think about each one before implementing.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Bishnu Panigrahi
Appian Employee
over 10 years ago
Also, when designing the query rule, check out the 'includes' operator, if it fits your use case. It can take null rule inputs.
forum.appian.com/.../Rules
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sikhivahans
over 10 years ago
Creating a record and using fn!queryrecord() is also an option and this will inturn provide much powerful features.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Chasity Davis
over 10 years ago
Thanks for the suggestions!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel