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
1225 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
Parents
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
Reply
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
Children
No Data