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

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

Sure. I think you have a full date in your database that includes the day. So you have to check whether the date in DB is between (>=) the first day of the month and the last day (<=).

Sorry ... this works in queryEntity only. But queryEntity is so much better that you should stop using query rules.

What you're asking isn't possible even with queryEntity(). You would have to do you concatenation on the database side using a view and then query against it with either a query rule or queryEntity.

=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
)
)

@stefan: "queryEntity is so much better that you should stop using query rules." -- I'd have to disagree entirely, or at least say that's far too broad a statement - but that's a discussion for another thread: https://forum.appian.com/suite/tempo/entry/e-196692

I agree. But we did some performance tests etc. and decided to leave query rules behind. Expressions using queryEntity can be much better tailored to certain use cases. But this is just what we found.

The other thread is very nice ;-)

is it possible put the same condition in queryEntity?
sample code is :
a!queryEntity(
entity: cons!EMPLOYEE_ENTITY,
query: a!query(
selection: a!querySelection(
columns: {
a!queryColumn(field: "hiredate"),
a!queryColumn(field: "empid")
}
),
logicalExpression: a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "hiredate",
operator: "<",
value: date(year(now()), month(now())-1, day(now()))
),
a!queryFilter(
field: "empid",
operator: "=",
value: ri!empid
)
}
),
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1
)
)
)
getting the below error message
Expression evaluation error at function a!queryEntity: Cannot apply operator [LESS_THAN] to field [dtCreated] when comparing to value [TypedValue[it=7,v=2016-02-10]].

Use the datetime() function instead of date() as per Stefan's example

is it possible to check only month and year not the date like 201603?