Solved
Filter data between filter of two dates
a!localVariables(
local!date: todatetime(ri!startTime, ri!endTime),
local!pId: a!queryEntity(
entity:cons!DS_DATA,
query:
a!query(
selection:
a!querySelection(
columns: {
a!queryColumn(
field:"pId",
alias:"pId"
)
}
),
logicalExpression: {
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field:"startTime",
operator: ">=",
value : local!date
),
a!queryFilter(
field:"endTime",
operator: "<=",
value : local!date
),
}
)
},
pagingInfo: a!pagingInfo(
startIndex: 1,
batchSize: -1
)
),
fetchTotalCount: true
).data,