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?

Discussion posts and replies are publicly visible

Parents

0 chetany
A Score Level 1
over 8 years ago

@Sikhi, agree that it is not a good idea to replicate the functionality of database for filtering using the looping functions. But, since the question asked for avoiding DB view, I think the only way to do it in Appian is to use the looping functions like filter.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 chetany
A Score Level 1
over 8 years ago

@Sikhi, agree that it is not a good idea to replicate the functionality of database for filtering using the looping functions. But, since the question asked for avoiding DB view, I think the only way to do it in Appian is to use the looping functions like filter.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data