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

ramakg

A Score Level 1

over 8 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 Stefan Helzle
A Score Level 3
over 8 years ago

=a!queryEntity(
entity: cons!MSS_ENTITY_MEETING_FLAT,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
if(isnull(ri!month), null, {
a!queryFilter(
field: "createdAt",
operator: ">=",
value: datetime(year(ri!month), month(ri!month), 1, 0, 0, 0)
),
a!queryFilter(
field: "createdAt",
operator: "<=",
value: datetime(
year(eomonth(ri!month, 0)),
month(eomonth(ri!month, 0)),
day(eomonth(ri!month, 0)),
23, 59, 59)
)
}
),
a!queryFilter(
field: "cancelled",
operator: "=",
value: false
)
}
),
pagingInfo: ri!pagingInfo
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 Stefan Helzle
A Score Level 3
over 8 years ago

=a!queryEntity(
entity: cons!MSS_ENTITY_MEETING_FLAT,
query: a!query(
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
if(isnull(ri!month), null, {
a!queryFilter(
field: "createdAt",
operator: ">=",
value: datetime(year(ri!month), month(ri!month), 1, 0, 0, 0)
),
a!queryFilter(
field: "createdAt",
operator: "<=",
value: datetime(
year(eomonth(ri!month, 0)),
month(eomonth(ri!month, 0)),
day(eomonth(ri!month, 0)),
23, 59, 59)
)
}
),
a!queryFilter(
field: "cancelled",
operator: "=",
value: false
)
}
),
pagingInfo: ri!pagingInfo
)
)
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data