In QueryEntity, we are using nested condition to get the desired data from the D

In QueryEntity, we are using nested condition to get the desired data from the DB Table. However, we are getting "Expression evaluation error at function a!queryEntity: Cannot apply a filter with a blank field name." exception during execution. Without the nested condition the query works fine and when we introduce nested condition, we are getting the mentioned error. We couldnt figureout what went wrong. Any help is appreciated. Please find the queryEntity rule attached for reference

QueryEntity.txt

OriginalPostID-211996

OriginalPostID-211996

  Discussion posts and replies are publicly visible

Parents Reply Children
  • i'm new to Appian. I have an issue with expression rule. my rule is as follows:

    a!queryEntity(
    entity: cons!LCW_BUSINESS_UNIT_ENTITY,
    query: a!query(
    filter: if(
    rule!APN_isEmpty(ri!businessDivision.id),
    {},
    a!queryFilter(
    field: "businessDivision.id",
    operator: "=",
    value: ri!businessDivision.id)
    ),
    pagingInfo: a!pagingInfo(
    startIndex: 1,
    batchSize: -1,
    sort: a!sortInfo(
    field: "order",
    ascending: true
    )
    )
    ),
    fetchTotalCount: true
    )

    but when i execute this i get the following error

    Expression evaluation error at function a!queryEntity: Cannot apply a filter with a blank field name.

    can you pls help?