is it possible to put the below expression in query rule where condition?

ramakg

A Score Level 1

over 9 years ago

is it possible to put the below expression in query rule where condition?

month(EMP_HIRE_DATE) &"-"& year(EMP_HIRE_DATE)=year(now()) & month(now())-1

Discussion posts and replies are publicly visible

Parents

0 Dan Lluhi
Certified Lead Developer
over 9 years ago

I've found the best way to query based on complex conditions is to use a!queryEntity. queryEntity allows you to define logicalExpressions within the query which can combine queryFilters and more logicalExpressions. Here's a link to the documentation which explains queryEntity further: forum.appian.com/.../System_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Dan Lluhi
Certified Lead Developer
over 9 years ago

I've found the best way to query based on complex conditions is to use a!queryEntity. queryEntity allows you to define logicalExpressions within the query which can combine queryFilters and more logicalExpressions. Here's a link to the documentation which explains queryEntity further: forum.appian.com/.../System_Functions.html
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data