Bitquery missing records from different combo of conditions

records are missing from different combo of conditions

the upper query should be able to query the result shown in the second query but it does not.

the record Im looking for is

{
  "ethereum": {
    "transfers": [
      {
        "any": "0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88",
        "date": {
          "date": "2021-07-02 00:00:00"
        },
        "currency": {
          "symbol": "BNB"
        },
        "amount": 0.029003473066051808,
        "entityId": null,
        "receiver": {
          "address": "0xa502f84bc86894361155035bf576bcb12e94b235"
        },
        "sender": {
          "address": "0xd7d069493685a581d27824fc46eda46b7efc0063"
        }
      }
    ]
  }
}

this query does not able to query this record even the txHash condition includes that hash

query {
  ethereum(network: bsc) {
    transfers(
      txHash: {in: ["0x6565f2a38a17dd9a21c931ab0b3cef081c67905dead0bd9532b148b49894847c", "0xbd8185e7a20533e8a48b0c9dcaea141a1e9c1bdb4b275a3cb724a3e145166525", "0xd3aca8b43180dce55e49e818602b0766bc4f5e869b170860819606da7001ce3b", "0x9a84206299b2fbe392b98b8549122f0efd837a95bf7e3852db7a2c8b3ca0011c", "0x1a72ef477990b682deaf039f1c899b0bd0fdb9db3487bb335f7d608b5d26da2f", "0x100dbbb0fd2eae35e8612810cfacac2218427745283ce7b05498e6995f81d07f", "0xc78432c2a8de81b8fc813b32976ee7a805284b08bcbc20f010b67a0d8d8e6a76", "0x420b84302a7d1cb83285b832e298929fdb95f5f7393bc1f842e0d284667b2bb4", "0x98a5ae0f19ea5d0df2faa4aefc8f22d6d82fcbefa92f680822223b9eb6806c71", "0x6a78669732eb2a016b331672db567d974fcb3e36943d821d817d1a0f7c14b3c3", "0xdff502fd1534d51e8da492f886f147cd9e289f9cfdf450c65916d1bd06c57b7d", "0xf21f9141a80f4ac1fd3f40efeeb6e2b7304d3ce48a9fbbdc45db28be3781553c", "0x54f0839fa87b0279bea45a2373eb24405fa221667611b31f1fceb9faa045fcee", "0x996dadff4b5729885b022c956eb70a9c054a70de94d3432477fb8f31860f49be", "0xa8ff93d646a6b3315c59793ae82c52a39c68313e1bbabaa825e2fda5b6ae668c", "0xa1f73a2a6d61b75eca532e4c1e4dc2e686aed958b36bbe2700c55c92e21ef8f9", "0xdca87fe7b2e0351e15aad6d18f9d663918761f2c22a53047823f369430b29e39", "0x93d77590c0e452aa88854d19351be5acac7f41643c01f4dfcbafe5dd5a7133d9", "0xed173d534c8e9d995b75ee4104de6264c398c8101d50421d606848ce4f5d1884", "0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88", "0x5d637850390e548b53e62b9ca663d868471e34ffca6b42de211f6a5b2f08fd00", "0x658f3ccb957cfa4c4e0dc1a69201d0f7109bf63ceb6825921e12c79fd92e2763", "0x68456e0d864e7a2c0c55f210534efec4e4cf954366f65b29d4206fd2d603452c", "0x647c6d18aa02c4a351600060c5490ca24b9d143ca6dee8c60585f4c792dcec50", "0xc51a2791981c44770a9950147262e67354843ea9207c39496ba5baa025dda2a1", "0x02aef83c84a378a69c66f974d1f5d3e3fefb8d905145d1dd813f2fbdd2e916f8", "0x4a692cf544265c4e744c6257ebb1cbefc4459486a8779746ce4f75b3ae2dd459", "0xb0137345ab9bcdcad26bb9eebc157dce8dbd81d2745c6bcc708c8611051f16e3", "0x7050b0ac0e83e23424931619fab2dc29ce8e2fb0d1b4ae347e5b95582b546822", "0x75b7393254adca41837c71672d0c040fe50871093d8bf0fbb54e32fe544aa1c3", "0x25a8d052d34b72df6996d0805a515313af9dda46f9fea8f200299b66de29028b", "0xd9f5f855cc886af5c596aa71fffe186d319ceb4b2a95112f11ba5309c3d51d3c", "0x1070bab931645ff2c6b54724d69c5fb16bddddfc6d5e5e5b92062137c4e8fea7", "0xce15566d0d18860e1d305cebe482d4cdde9ebf5a61959f45d11482c19aeb6b56", "0x9d9441e2d180aede8d773760a1d47736eb52910e6a19c19795d86b5e7d5ea24c", "0xce57ebea1ac56855a17ea51683635820bdb94861aad4cf136deafc4e9df3dff2", "0x3ddf421390600327ac6a1fafcea5097899df6ba9467e758318498f085ad76922", "0x595cfcf264562cecfc774841dc66b8334c526a0abeabcebbf52e9c60409172b4", "0x94ea780a344f4987b3c295e661de29200f2d520aa1215d00a8e16f2ffae27c09", "0xd4cadb0d77d36723b39c20357768c6fc7f83331a15de31cf74c0f4c1ed675d9b", "0x9ced2d4eb26d651e2805763903733e84098c6cd1fb7b23b0e531f69b19a6d6a5", "0xa70c5587a3e1bd30d8f61661cbe58501dd35ccbf042b993585a98bd325814402", "0xcf6e8c431c9bec95633384e2666ac0ad2647d91470fccb7225ceb29bdbaa4d5a"]}
    ) {
    any(of: tx_hash)
      date {
        date(format: "%Y-%m-%d %H:%M:%S")
      }
      currency {
        symbol
      }
      amount
      entityId
      receiver{
        address
      }
      sender {
        address
      }
    }
  }
}

Instead when the condition is tighter, it is able to query that record

query {
  ethereum(network: bsc) {
    transfers(
      txHash: {in: ["0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88"]} ) {
    any(of: tx_hash)
      date {
        date(format: "%Y-%m-%d %H:%M:%S")
      }
      currency {
        symbol
      }
      amount
      entityId
      receiver(receiver:{in: ["0xa502f84bc86894361155035bf576bcb12e94b235"]}){
        address
      }
      sender {
        address
      }
    }
  }
}

Hi @lulucaca I ran the query and I got the desired result. Ofcourse the upper query has multiple txHash while the lower query only has one.

Was I able to understand your problem?

The upper query is not able to produce the result from the lower query but that is a bug. Are you able to re-produce my experience?

The upper query is bound to produce a different result than the lower query because of the number of addresses in the txHash filter. The result I am getting is as follows

{
  "": {
    "ethereum": {
      "transfers": [
        {
          "any": "0x658f3ccb957cfa4c4e0dc1a69201d0f7109bf63ceb6825921e12c79fd92e2763",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 15.14870888023167,
          "entityId": null,
          "receiver": {
            "address": "0x0612fc74988c91f0078a9fcbc86bd05f001b1ab7"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0xf21f9141a80f4ac1fd3f40efeeb6e2b7304d3ce48a9fbbdc45db28be3781553c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 2.2992711858199852,
          "entityId": null,
          "receiver": {
            "address": "0x09b619afafb8a6f69afee546145dc219b38a6a9e"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x68456e0d864e7a2c0c55f210534efec4e4cf954366f65b29d4206fd2d603452c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.9432932740351331,
          "entityId": null,
          "receiver": {
            "address": "0x0c2eb071a6a3f4d4e0e0b1d860c69d6aa298a343"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x75b7393254adca41837c71672d0c040fe50871093d8bf0fbb54e32fe544aa1c3",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 22.23797973468387,
          "entityId": null,
          "receiver": {
            "address": "0x1337d6ae8aafaba822fc41bbdc065d4da724e034"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x3ddf421390600327ac6a1fafcea5097899df6ba9467e758318498f085ad76922",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 1.5526074418443192,
          "entityId": null,
          "receiver": {
            "address": "0x19c0646517009a6893e6e8d567ace9aee46dc0ea"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x94ea780a344f4987b3c295e661de29200f2d520aa1215d00a8e16f2ffae27c09",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 5.397580038054522,
          "entityId": null,
          "receiver": {
            "address": "0x1d03203949d1dcd55eb38a663c6207d1781a9f00"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0xd9f5f855cc886af5c596aa71fffe186d319ceb4b2a95112f11ba5309c3d51d3c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 1.3659297413945906,
          "entityId": null,
          "receiver": {
            "address": "0x2175f92208bdd3d2bf467d2f2c259a3fd92ff202"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0xb0137345ab9bcdcad26bb9eebc157dce8dbd81d2745c6bcc708c8611051f16e3",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 2.1977003966252804,
          "entityId": null,
          "receiver": {
            "address": "0x21f1eb785a6a9e837839022dd92af4278bd82bf4"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0xce57ebea1ac56855a17ea51683635820bdb94861aad4cf136deafc4e9df3dff2",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.9351945558487654,
          "entityId": null,
          "receiver": {
            "address": "0x2351fd617474af6131fe56d3dacbe5924df85387"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0xcf6e8c431c9bec95633384e2666ac0ad2647d91470fccb7225ceb29bdbaa4d5a",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 4.026878539273836,
          "entityId": null,
          "receiver": {
            "address": "0x2b80f3ca0234cd3fdfdf146c3c286cabe0721e1f"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x4a692cf544265c4e744c6257ebb1cbefc4459486a8779746ce4f75b3ae2dd459",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 24.240224472076715,
          "entityId": null,
          "receiver": {
            "address": "0x4746ce3816a5f687923f32d958e7fdbcadafdfa6"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x25a8d052d34b72df6996d0805a515313af9dda46f9fea8f200299b66de29028b",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.6743388168246058,
          "entityId": null,
          "receiver": {
            "address": "0x4cb752c6dbf37cc34632ea624e1142464aec59f7"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x5d637850390e548b53e62b9ca663d868471e34ffca6b42de211f6a5b2f08fd00",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.6271116221031052,
          "entityId": null,
          "receiver": {
            "address": "0x4f434e6f8028be14bb3fe92dd31de53d2a85d7af"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0xed173d534c8e9d995b75ee4104de6264c398c8101d50421d606848ce4f5d1884",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 2.9394446056840096,
          "entityId": null,
          "receiver": {
            "address": "0x548de799a0d166c1d92ff6481976697e300fdb9c"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x93d77590c0e452aa88854d19351be5acac7f41643c01f4dfcbafe5dd5a7133d9",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.47626877620099933,
          "entityId": null,
          "receiver": {
            "address": "0x59d2e0a2be0db463c36038a5fd2535f58ab3b38f"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x54f0839fa87b0279bea45a2373eb24405fa221667611b31f1fceb9faa045fcee",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 4.045143410937982,
          "entityId": null,
          "receiver": {
            "address": "0x5c6512733582bb3609a1142bc9bdb1607e122007"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x996dadff4b5729885b022c956eb70a9c054a70de94d3432477fb8f31860f49be",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.9206088088468293,
          "entityId": null,
          "receiver": {
            "address": "0x62ef0521a7e0da5a097aecc140958282638688f1"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        {
          "any": "0x658f3ccb957cfa4c4e0dc1a69201d0f7109bf63ceb6825921e12c79fd92e2763",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x0612fc74988c91f0078a9fcbc86bd05f001b1ab7"
          }
        },
        {
          "any": "0xf21f9141a80f4ac1fd3f40efeeb6e2b7304d3ce48a9fbbdc45db28be3781553c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x09b619afafb8a6f69afee546145dc219b38a6a9e"
          }
        },
        {
          "any": "0x68456e0d864e7a2c0c55f210534efec4e4cf954366f65b29d4206fd2d603452c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x0c2eb071a6a3f4d4e0e0b1d860c69d6aa298a343"
          }
        },
        {
          "any": "0x75b7393254adca41837c71672d0c040fe50871093d8bf0fbb54e32fe544aa1c3",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x1337d6ae8aafaba822fc41bbdc065d4da724e034"
          }
        },
        {
          "any": "0x3ddf421390600327ac6a1fafcea5097899df6ba9467e758318498f085ad76922",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x19c0646517009a6893e6e8d567ace9aee46dc0ea"
          }
        },
        {
          "any": "0x94ea780a344f4987b3c295e661de29200f2d520aa1215d00a8e16f2ffae27c09",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x1d03203949d1dcd55eb38a663c6207d1781a9f00"
          }
        },
        {
          "any": "0xd9f5f855cc886af5c596aa71fffe186d319ceb4b2a95112f11ba5309c3d51d3c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x2175f92208bdd3d2bf467d2f2c259a3fd92ff202"
          }
        },
        {
          "any": "0xb0137345ab9bcdcad26bb9eebc157dce8dbd81d2745c6bcc708c8611051f16e3",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x21f1eb785a6a9e837839022dd92af4278bd82bf4"
          }
        },
        {
          "any": "0xce57ebea1ac56855a17ea51683635820bdb94861aad4cf136deafc4e9df3dff2",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x2351fd617474af6131fe56d3dacbe5924df85387"
          }
        },
        {
          "any": "0xcf6e8c431c9bec95633384e2666ac0ad2647d91470fccb7225ceb29bdbaa4d5a",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x2b80f3ca0234cd3fdfdf146c3c286cabe0721e1f"
          }
        },
        {
          "any": "0x4a692cf544265c4e744c6257ebb1cbefc4459486a8779746ce4f75b3ae2dd459",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x4746ce3816a5f687923f32d958e7fdbcadafdfa6"
          }
        },
        {
          "any": "0x25a8d052d34b72df6996d0805a515313af9dda46f9fea8f200299b66de29028b",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x4cb752c6dbf37cc34632ea624e1142464aec59f7"
          }
        },
        {
          "any": "0x5d637850390e548b53e62b9ca663d868471e34ffca6b42de211f6a5b2f08fd00",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x4f434e6f8028be14bb3fe92dd31de53d2a85d7af"
          }
        },
        {
          "any": "0xed173d534c8e9d995b75ee4104de6264c398c8101d50421d606848ce4f5d1884",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x548de799a0d166c1d92ff6481976697e300fdb9c"
          }
        },
        {
          "any": "0x93d77590c0e452aa88854d19351be5acac7f41643c01f4dfcbafe5dd5a7133d9",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x59d2e0a2be0db463c36038a5fd2535f58ab3b38f"
          }
        },
        {
          "any": "0x54f0839fa87b0279bea45a2373eb24405fa221667611b31f1fceb9faa045fcee",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x5c6512733582bb3609a1142bc9bdb1607e122007"
          }
        },
        {
          "any": "0x996dadff4b5729885b022c956eb70a9c054a70de94d3432477fb8f31860f49be",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x62ef0521a7e0da5a097aecc140958282638688f1"
          }
        },
        {
          "any": "0x9ced2d4eb26d651e2805763903733e84098c6cd1fb7b23b0e531f69b19a6d6a5",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x93b6725410a9385e7dfb2b5698d4bc54509de9cf"
          }
        },
        {
          "any": "0x02aef83c84a378a69c66f974d1f5d3e3fefb8d905145d1dd813f2fbdd2e916f8",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x9823b2394a4a6714107bacbf7173323f5c0e29fa"
          }
        },
        {
          "any": "0xce15566d0d18860e1d305cebe482d4cdde9ebf5a61959f45d11482c19aeb6b56",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0x9b6da90123f19f7b7b93b3afe0a1718e2ebbf191"
          }
        },
        {
          "any": "0xa8ff93d646a6b3315c59793ae82c52a39c68313e1bbabaa825e2fda5b6ae668c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xa509f21e3db52fec0b780c0ceb96c80c9f4b1022"
          }
        },
        {
          "any": "0xd4cadb0d77d36723b39c20357768c6fc7f83331a15de31cf74c0f4c1ed675d9b",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xaa24c7d352247095f01ed7e6b20df8d1f242bae0"
          }
        },
        {
          "any": "0xc51a2791981c44770a9950147262e67354843ea9207c39496ba5baa025dda2a1",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xbd2c152256f33805c8581c7dd6f68dbde150994a"
          }
        },
        {
          "any": "0xdca87fe7b2e0351e15aad6d18f9d663918761f2c22a53047823f369430b29e39",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xc7fa47915de4adc2ca3a46d9d2dd4c35eec7ef75"
          }
        },
        {
          "any": "0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xd4f02ce5b2ac30bfd781bde71dd16fad5e45d889"
          }
        },
        {
          "any": "0xa1f73a2a6d61b75eca532e4c1e4dc2e686aed958b36bbe2700c55c92e21ef8f9",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xd644c1b56c3f8faa7beb446c93da2f190bfaed9b"
          }
        },
        {
          "any": "0x595cfcf264562cecfc774841dc66b8334c526a0abeabcebbf52e9c60409172b4",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xdecdd927b847093d485464c20c544ef7f4cd41dd"
          }
        },
        {
          "any": "0x9d9441e2d180aede8d773760a1d47736eb52910e6a19c19795d86b5e7d5ea24c",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xe1e8d618eb6d40b33354161fb13c8f2d460b47bb"
          }
        },
        {
          "any": "0xa70c5587a3e1bd30d8f61661cbe58501dd35ccbf042b993585a98bd325814402",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xe388f5a21a20d1d3531731866aa685fe3d0ef10e"
          }
        },
        {
          "any": "0x647c6d18aa02c4a351600060c5490ca24b9d143ca6dee8c60585f4c792dcec50",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xe4bc85e95bd1c0e1301823e4d08d8011bbe2d66c"
          }
        },
        {
          "any": "0x1070bab931645ff2c6b54724d69c5fb16bddddfc6d5e5e5b92062137c4e8fea7",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xe59abb99142ffabf2f9619dd410baa96553871f7"
          }
        },
        {
          "any": "0xdff502fd1534d51e8da492f886f147cd9e289f9cfdf450c65916d1bd06c57b7d",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0,
          "entityId": null,
          "receiver": {
            "address": "0x8f0528ce5ef7b51152a59745befdd91d97091d2f"
          },
          "sender": {
            "address": "0xe9deb3bb6b18438105e14b95097c12980b5c4030"
          }
        },
        {
          "any": "0x9ced2d4eb26d651e2805763903733e84098c6cd1fb7b23b0e531f69b19a6d6a5",
          "date": {
            "date": "2021-07-02 00:00:00"
          },
          "currency": {
            "symbol": "ALPACA"
          },
          "amount": 0.3358469946628053,
          "entityId": null,
          "receiver": {
            "address": "0x93b6725410a9385e7dfb2b5698d4bc54509de9cf"
          },
          "sender": {
            "address": "0xa625ab01b08ce023b2a342dbb12a16f2c8489a8f"
          }
        },
        . . .
        . . . 
        . . . 
      ]
    }
  }
}

The result I got matches with the format of the “desired” result but ofcourse is not the same.

it is not desired.

the upper query search for all the transfers from a number of address of txHash and one of the txHash=0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88

the result is only desired when the upper query also gives you a transfer that receiver=0xa502f84bc86894361155035bf576bcb12e94b235 from txHash=0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88 which is queryable from lower query.

the lower query is to invalidate the upper query. the result from upper query is NOT desired. do you understand?

Yeah understood. Try this

I do not want to narrow my query to get supposedly desired result but my provided lower query invalidated the upper query. is this an existing bug? what’s the next step?

I’m suspecting the indexing would not be optimal to allow the engine the query the result. which lead to miss record from upper query.

or is there any hidden limits from the querying engine? your proposed query somewhat is able to query on certain receiver but the result from upper query is still problematic? do we agree on this ?

I see this record in both queries

no I do not. check below query and look at the result. it does not give you
txHash= 0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88
receiver= 0xa502f84bc86894361155035bf576bcb12e94b235
sender= 0xd7d069493685a581d27824fc46eda46b7efc0063

Don’t use anyof

use it like this

{
  ethereum(network: bsc) {
    transfers(
      txHash: {in: ["0x6565f2a38a17dd9a21c931ab0b3cef081c67905dead0bd9532b148b49894847c", "0xbd8185e7a20533e8a48b0c9dcaea141a1e9c1bdb4b275a3cb724a3e145166525", "0xd3aca8b43180dce55e49e818602b0766bc4f5e869b170860819606da7001ce3b", "0x9a84206299b2fbe392b98b8549122f0efd837a95bf7e3852db7a2c8b3ca0011c", "0x1a72ef477990b682deaf039f1c899b0bd0fdb9db3487bb335f7d608b5d26da2f", "0x100dbbb0fd2eae35e8612810cfacac2218427745283ce7b05498e6995f81d07f", "0xc78432c2a8de81b8fc813b32976ee7a805284b08bcbc20f010b67a0d8d8e6a76", "0x420b84302a7d1cb83285b832e298929fdb95f5f7393bc1f842e0d284667b2bb4", "0x98a5ae0f19ea5d0df2faa4aefc8f22d6d82fcbefa92f680822223b9eb6806c71", "0x6a78669732eb2a016b331672db567d974fcb3e36943d821d817d1a0f7c14b3c3", "0xdff502fd1534d51e8da492f886f147cd9e289f9cfdf450c65916d1bd06c57b7d", "0xf21f9141a80f4ac1fd3f40efeeb6e2b7304d3ce48a9fbbdc45db28be3781553c", "0x54f0839fa87b0279bea45a2373eb24405fa221667611b31f1fceb9faa045fcee", "0x996dadff4b5729885b022c956eb70a9c054a70de94d3432477fb8f31860f49be", "0xa8ff93d646a6b3315c59793ae82c52a39c68313e1bbabaa825e2fda5b6ae668c", "0xa1f73a2a6d61b75eca532e4c1e4dc2e686aed958b36bbe2700c55c92e21ef8f9", "0xdca87fe7b2e0351e15aad6d18f9d663918761f2c22a53047823f369430b29e39", "0x93d77590c0e452aa88854d19351be5acac7f41643c01f4dfcbafe5dd5a7133d9", "0xed173d534c8e9d995b75ee4104de6264c398c8101d50421d606848ce4f5d1884", "0x511999ebc5640a1d38c3de2df91fc306678ba66d6fe3df34cb2533e994504a88", "0x5d637850390e548b53e62b9ca663d868471e34ffca6b42de211f6a5b2f08fd00", "0x658f3ccb957cfa4c4e0dc1a69201d0f7109bf63ceb6825921e12c79fd92e2763", "0x68456e0d864e7a2c0c55f210534efec4e4cf954366f65b29d4206fd2d603452c", "0x647c6d18aa02c4a351600060c5490ca24b9d143ca6dee8c60585f4c792dcec50", "0xc51a2791981c44770a9950147262e67354843ea9207c39496ba5baa025dda2a1", "0x02aef83c84a378a69c66f974d1f5d3e3fefb8d905145d1dd813f2fbdd2e916f8", "0x4a692cf544265c4e744c6257ebb1cbefc4459486a8779746ce4f75b3ae2dd459", "0xb0137345ab9bcdcad26bb9eebc157dce8dbd81d2745c6bcc708c8611051f16e3", "0x7050b0ac0e83e23424931619fab2dc29ce8e2fb0d1b4ae347e5b95582b546822", "0x75b7393254adca41837c71672d0c040fe50871093d8bf0fbb54e32fe544aa1c3", "0x25a8d052d34b72df6996d0805a515313af9dda46f9fea8f200299b66de29028b", "0xd9f5f855cc886af5c596aa71fffe186d319ceb4b2a95112f11ba5309c3d51d3c", "0x1070bab931645ff2c6b54724d69c5fb16bddddfc6d5e5e5b92062137c4e8fea7", "0xce15566d0d18860e1d305cebe482d4cdde9ebf5a61959f45d11482c19aeb6b56", "0x9d9441e2d180aede8d773760a1d47736eb52910e6a19c19795d86b5e7d5ea24c", "0xce57ebea1ac56855a17ea51683635820bdb94861aad4cf136deafc4e9df3dff2", "0x3ddf421390600327ac6a1fafcea5097899df6ba9467e758318498f085ad76922", "0x595cfcf264562cecfc774841dc66b8334c526a0abeabcebbf52e9c60409172b4", "0x94ea780a344f4987b3c295e661de29200f2d520aa1215d00a8e16f2ffae27c09", "0xd4cadb0d77d36723b39c20357768c6fc7f83331a15de31cf74c0f4c1ed675d9b", "0x9ced2d4eb26d651e2805763903733e84098c6cd1fb7b23b0e531f69b19a6d6a5", "0xa70c5587a3e1bd30d8f61661cbe58501dd35ccbf042b993585a98bd325814402", "0xcf6e8c431c9bec95633384e2666ac0ad2647d91470fccb7225ceb29bdbaa4d5a"]}
      date: {since: "2021-06-01", till: "2021-08-01"}
    ) {
      transaction{
        hash
      }
      date {
        date(format: "%Y-%m-%d %H:%M:%S")
      }
      currency {
        symbol
      }
      amount
      entityId
      receiver {
        address
      }
      sender {
        address
      }
    }
  }
}

can you save a query as a bitquery link which can query that txHash with the same condition I had (the upper query)? I cannot still query it no matter if i use anyof or not.

1 Like

Here you go @lulucaca

Was this problem resolved?

Thx sayon. ok i see the difference now and its actually caused by querying anyof attributes. any explanation?

but this is resolved with knowledge of knowing not to use one of the attributes…

1 Like