Is it possible to use "like" operator in a!queryFilter?

is it possible to use "like" operator in a!queryFilter?

OriginalPostID-200671

OriginalPostID-200671

  Discussion posts and replies are publicly visible

Parents
  • filter is not working if I use "includes" operator.
    I have 3 option in my portal report like "All","Open","Completed" and "Cancelled"
    sample code as follows:
    local!report: a!queryProcessAnalytics(
    report: cons!Employee_entity,
    contextProcessModels : cons!EMP_MODEL_NAMES,
    query: a!query(
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50),

    logicalExpression:a!queryLogicalExpression(
    operator:"AND",
    filters: {
    if(ri!tStatus="All",null,if(like(ri!tStatus,"*Complete*"),a!queryFilter(field: "c3", operator: "includes", value: "*Complete*"),a!queryFilter(field: "c3", operator: "includes", value: "*Cancell*")))

    }
    )

    )


    The above code is not working. Any suggestion
Reply
  • filter is not working if I use "includes" operator.
    I have 3 option in my portal report like "All","Open","Completed" and "Cancelled"
    sample code as follows:
    local!report: a!queryProcessAnalytics(
    report: cons!Employee_entity,
    contextProcessModels : cons!EMP_MODEL_NAMES,
    query: a!query(
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 50),

    logicalExpression:a!queryLogicalExpression(
    operator:"AND",
    filters: {
    if(ri!tStatus="All",null,if(like(ri!tStatus,"*Complete*"),a!queryFilter(field: "c3", operator: "includes", value: "*Complete*"),a!queryFilter(field: "c3", operator: "includes", value: "*Cancell*")))

    }
    )

    )


    The above code is not working. Any suggestion
Children
No Data