Filters

Filtering data in a request

You can apply filters to any field depending on type. Syntax: field__filter Example:

{
  transactions(parsed_dns_domain__contains: "dton"){
    address
    workchain
    parsed_dns_domain
  }
}

Available filters:

  • exact - Exact match (this is default one when you use seqno: 1 e.g.)

  • contains - Case-sensitive containment test

  • in - In a given list

  • gt - Greater than

  • gte - Greater than or equal to

  • lt - Less than

  • lte - Less than or equal to

  • range - In a given range [val_from, val_to], both included

  • isnull - Takes either True or False, which correspond to SQL queries of IS NULL and IS NOT NULL, respectively

AND / OR / NOT

1. and__: This filter is used to apply a logical AND to multiple conditions. (default one when you use several keys: {workchain: -1, seqno: 1} = workchain = 1 AND seqno = 1

{
  transactions(
    and__: [{workcain: -1, seqno: 1}, {seqno: 2}]
  ) {
    seqno
    workcain
  }
}

2. or__: This filter is used to apply a logical OR to multiple conditions.

{
  transactions(
    or__: [{seqno: 1}, {seqno: 2}]
  ) {
    seqno
    shard
  }
}

3. not__: This filter is used to negate a condition.

{
  transactions(
    not__: {seqno: 1}
  ) {
    seqno
    shard
  }
}

Nested Filters (max depth: 3)

{
  transactions(or__: [
      {seqno: 0}, 
      {seqno: 1}, 
      {seqno: 2}, 
      {and__: {seqno__gt: 10, seqno__lte: 15}}]) {
    seqno
  }
}

Last updated