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
3 replies
Subscribers
8 subscribers
Views
1803 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Using a queryEntity expression, would it be possible to set a queryFilter that c
GouthamKrishna
over 8 years ago
Using a queryEntity expression, would it be possible to set a queryFilter that compares two entity fields for a condition? For example, if I want to query set of tasks from tasks table that are overdue, can I specify queryFilter in such a way that checks if 'taskCompletionTime' > 'taskDeadLineTime' and these are fields in my cdt/entity. This type of filtering is possible in SQL and I think it’s a nice one to have in Appian too that saves us from creating a database view for such simple usecases. Did anyone encounter similar ideas and/or what are the best possible ways to do it besides creating a view?
OriginalPostID-223882
OriginalPostID-223882
Discussion posts and replies are publicly visible
Parents
0
sikhivahans
over 8 years ago
I would say that comparing the two fields is already available in database and it may not be worth trying to implement the same in Appian(pulling back all the database data into Appian and operating on it using Looping Functions) which would impose a additional overhead on the SAIL interface and this also makes the maintenance or changes complex in case if similar requirements arise in the future.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
sikhivahans
over 8 years ago
I would say that comparing the two fields is already available in database and it may not be worth trying to implement the same in Appian(pulling back all the database data into Appian and operating on it using Looping Functions) which would impose a additional overhead on the SAIL interface and this also makes the maintenance or changes complex in case if similar requirements arise in the future.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data