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
2921 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
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
0
sikhivahans
over 7 years ago
@marco Have a look at the documentation at
forum.appian.com/.../Query_Recipes.html
and I believe that should answer your question.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sparshs
over 7 years ago
i think you can use query entity instead of query rule for that.. It will suffice your requirement. Let me know if there are any further concerns.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
PhilB
Certified Lead Developer
over 7 years ago
As above, you'll need to use a query entity with a logical expression to achieve what you're hoping to do.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
marcoc918
A Score Level 1
over 7 years ago
Yes with query entity it works fine, not so easy to implement but once you have understood the logic it works.
Thank you very much to all
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
phanibabuk
over 7 years ago
Hi,
I hope this URL might be of help.
forum.appian.com/.../Query_Recipes.html
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel