local!datasubsetDeficiency: a!queryEntity(
    entity: cons!BWIS_WF_REP_AUDIT_LOG_ENTITY,
    query: a!query(
      selection: a!querySelection(
        columns: {
          a!queryColumn(
            field: "requestId"
          )
        }
      ),
      logicalExpression: a!queryLogicalExpression(
        operator: "AND",
        filters: {
          a!queryFilter(
            field: "applicationName",
            operator: "=",
            value: cons!BWIS_UTIL_BUSINESS_UNIT
          ),
          a!queryFilter(
            field: "reasonCode",
            operator: "not null"
          )
        }
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: - 1
      )
    )
  ),
  local!deficiencyRequestDetailsCount: a!queryEntity(
    entity: cons!BWIS_WF_REP_REQUEST_DETAILS_ENTITY,
    query: a!query(
      aggregation: a!queryAggregation(
        aggregationColumns: {
          a!queryAggregationColumn(
            field: "mainCategory",
            isGrouping: true
          ),
          a!queryAggregationColumn(
            field: "requestId",
            aggregationFunction: "COUNT"
          )
        }
      ),
      filter: a!queryFilter(
        field: "requestId",
        operator: "in",
        value: local!datasubsetDeficiency.data.requesId
      ),
      pagingInfo: a!pagingInfo(
        startIndex: 1,
        batchSize: - 1
      )
    )
  )