Need to filter the data of a grid in a tempo report by two filters

You can do it by using an if condition in the logicalExpression, you will just need to return a {} as the false condition eg. if(isnull(ri!filter),{},a!queryFilter(......). Also you will need to look where your query is sitting within the structure e.g. is it in load or with. If you are wanting it to fresh when a new dropdown value is selected then you will need it to be in the with function.

Ok i think we are near the solution (i hope), this is my sail code for the query record
local!datasubset: queryrecord(
cons!ApacRequestMobileReport,
a!query(
selection: a!querySelection(columns: {
a!queryColumn(field: "ApacRequestMobile.ID", alias: "ID"),
a!queryColumn(field: "ApacRequestMobile.Name", alias: "Requestor"),
a!queryColumn(field: "ApacRequestMobile.LeaveCode", alias: "LeaveType"),
a!queryColumn(field: "ApacRequestMobile.ApplyDate", alias: "ApplyDate"),
a!queryColumn(field: "ApacRequestMobile.FromDate", alias: "FromDate"),
a!queryColumn(field: "ApacRequestMobile.FromTime", alias: "FromTime"),
a!queryColumn(field: "ApacRequestMobile.ToDate", alias: "ToDate"),
a!queryColumn(field: "ApacRequestMobile.Totime", alias: "ToTime"),
a!queryColumn(field: "ApacRequestMobile.Reason", alias: "Reason"),
a!queryColumn(field: "ApacRequestMobile.Status", alias: "Status"),
a!queryColumn(field: "ApacRequestMobile.ApprovedDate", alias: "ApprovalDate"),
a!queryColumn(field: "ApacRequestMobile.ApprovedBy", alias: "ApprovedBy"),
a!queryColumn(field: "ligtRequest", alias: "lightRequest"),
a!queryColumn(field: "lightManager", alias: "lightManager")
}),
logicalExpression: if(isnull(local!filterLeave),
a!queryLogicalExpression(
operator: "AND",
filters:{
a!queryFilter(
field: "ApacRequestMobile.ID",
operator: "=",
value: 29
)
}
),
a!queryLogicalExpression(
operator: "AND",
filters: {
a!queryFilter(
field: "ApacRequestMobile.ID",
operator: "=",
value: 29
),
a!queryFilter:(
field: "ApacRequestMobile.LeaveCode",
operator: "includes",
value: local!filterLeave
)
}
)
),
pagingInfo: local!pagingInfo
)
)

sail says: Expression evaluation Error "Sintax error. details: expression evaluation error at function a!queryLogicalExpression parameters 2: missing right parenthesis in the expression found: COMMA.

can anyone help me?

solved the extra : after the a!queryFilter