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
6 replies
Subscribers
5 subscribers
Views
2973 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Advanced Query Plugin SQL
marcoc918
A Score Level 1
over 7 years ago
Hello,
We are used to do complex query using the query database node, an example should be something like that:
select * from HSE_BBS_VIEW_REPORT WHERE
(DATE between {d '2015-05-24'} and {d '2016-01-01'})
and (OBSERVER_NAME='Winfield Paul' or OBSERVER_NAME='Griffiths Christopher')
there is a similar way to do so using query rule? we need to use them on report, interfaces and other sail components? If not when this components will be implemented?
Thank you
OriginalPostID-232608
Discussion posts and replies are publicly visible
Parents
0
kdimitrov
over 7 years ago
Hi Marco,
Using a query rule with an OR would not be possible.
The function a!queryEntity will allow you to do BETWEEN and OR as normal using a combination a!queryLogicalExpression() functions.
Hope that helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
kdimitrov
over 7 years ago
Hi Marco,
Using a query rule with an OR would not be possible.
The function a!queryEntity will allow you to do BETWEEN and OR as normal using a combination a!queryLogicalExpression() functions.
Hope that helps.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data