A Question for Filtering Record Data

Hi Appian Guys,



a!queryRecordType
( recordType: recordType!SellerTeam, filters: a!queryFilter( field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis" operator: "includes". value: "Alex" ), pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500) )


I want to get teams of including "Alex" only, could anyone give me some good advises?

  Discussion posts and replies are publicly visible

Parents
  • a!queryRecordType(
      recordType: recordType!SellerTeam,
      filters: a!queryLogicalExpression(
        operator: "OR",
        filters: {
          a!queryFilter(
            field: recordType!SellerTeam.fields.sellerName,   # example value is "Alex; Alexis"
            operator: "includes",
            value: "Alex;"
          ),
          a!queryFilter(
            field: recordType!SellerTeam.fields.sellerName,   # example value is "Alex; Alexis"
            operator: "ends with",
            value: "Alex"
          )
        }
      ),
      pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
    )

  • That's great!! but i added two conditions for entire logic.

    a!queryRecordType(
    recordType: recordType!SellerTeam,
    filters: a!queryLogicalExpression(
    operator: "OR",
    filters: {
    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "includes",
    value: "; Alex;"
    ),
    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "ends with",
    value: "; Alex"
    ),

    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "=",
    value: "Alex"
    ),

    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "starts with",
    value: "Alex; "
    ),
    }
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
    )

Reply
  • That's great!! but i added two conditions for entire logic.

    a!queryRecordType(
    recordType: recordType!SellerTeam,
    filters: a!queryLogicalExpression(
    operator: "OR",
    filters: {
    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "includes",
    value: "; Alex;"
    ),
    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "ends with",
    value: "; Alex"
    ),

    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "=",
    value: "Alex"
    ),

    a!queryFilter(
    field: recordType!SellerTeam.fields.sellerName, # example value is "Alex; Alexis"
    operator: "starts with",
    value: "Alex; "
    ),
    }
    ),
    pagingInfo: a!pagingInfo(startIndex: 1, batchSize: 500)
    )

Children
No Data