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,
Discussion posts and replies are publicly visible