Find needed account

Those filters work in account_states and transactions tables

By address

User-friendly

Account states & other tables

Example of query account actual balance:

{
  raw_account_states(
    address__friendly: "EQAAFSPzZXu3pKo-VfQZRYcUjygur1-VLI9-wY9uwaobbUht"
  ) {
    account_storage_balance_grams
  }
}

Transactions

Example of query account balance changing by transactions:

{
  raw_transactions(
    address__friendly: "EQAAFSPzZXu3pKo-VfQZRYcUjygur1-VLI9-wY9uwaobbUht"
  ) {
    account_storage_balance_grams
    gen_utime
  }
}

Raw form only

Example of query account actual balance:

{
  raw_account_states(
    address: "001523F3657BB7A4AA3E55F4194587148F282EAF5F952C8F7EC18F6EC1AA1B6D"
    workchain: 0
  ) {
    account_storage_balance_grams
  }
}

By code or data hash

We not suggest finding accounts by code hash, better use filter by get methods

Contract	Code hash	Verifier
Wallet V1R1	A0CFC2C48AEE16A271F2CFC0B7382D81756CECB1017D077FAAAB3BB602F6868C	https://verifier.ton.org/EQAAQ-CfIZkUjmZ6ES9D_keK2yHz10U1ba49K0S86Whva74Z
Wallet V1R2	D4902FCC9FAD74698FA8E353220A68DA0DCF72E32BCB2EB9EE04217C17D3062C	https://verifier.ton.org/EQAAVd4c_2pMb4Bp8BxumyV8jutdwJ9R-q0dBqQj7tj_W8SX
Wallet V1R3	587CC789EFF1C84F46EC3797E45FC809A14FF5AE24F1E0C7A6A99CC9DC9061FF	https://verifier.ton.org/EQAAEgdraul87g9zvm5Lxtd9FNoebifojeyT90uG6zrWBvRh
Wallet V2R1	5C9A5E68C108E18721A07C42F9956BFB39AD77EC6D624B60C576EC88EEE65329	https://verifier.ton.org/EQAAC2tOLQxG4KuFcS_pb2Rta1MDdgx8wAtZnGf5bIEIMLft
Wallet V2R2	FE9530D3243853083EF2EF0B4C2908C0ABF6FA1C31EA243AACAA5BF8C7D753F1	https://verifier.ton.org/EQAAnU-irJsuuljRAWBRUhdvFB-rvGRHbdQSWXPSQYND6MVb
Wallet V3R1	B61041A58A7980B946E8FB9E198E3C904D24799FFA36574EA4251C41A566F581	https://verifier.ton.org/EQAY_2_A88HD43S96hbVGbCLB21e6_k1nbaqICwS3ZCrMBaZ
Wallet V3R2	84DAFA449F98A6987789BA232358072BC0F76DC4524002A5D0918B9A75D2D599	https://verifier.ton.org/EQALgHQ-KpmkwftbsdeZdA4DvVDCYkKvria9llb7_RMeZj_8
Wallet V4R1	64DD54805522C5BE8A9DB59CEA0105CCF0D08786CA79BEB8CB79E880A8D7322D
Wallet V4R2	FEB5FF6820E2FF0D9483E7E0D62C817D846789FB4AE580C878866D959DABD5C0	https://verifier.ton.org/EQDerEPTIh0O8lBdjWc6aLaJs5HYqlfBN2Ruj1lJQH_6vcaZ

{
  account_states(
    account_state_state_init_code_hash: "B61041A58A7980B946E8FB9E198E3C904D24799FFA36574EA4251C41A566F581"
  ) {
    address
    workchain
  }
}

By get methods

method_name in Func is compiling to crc16 integer, you can filter transactions or accounts states by get any get method:

Any get method

You can get account contain specific get method name crc16, for example all accounts with seqno method (85143):

{
  raw_account_states(account_state_state_init_code_method_name: "get_wallet"){
    address
    workchain
  }
}

Predefined get methods

Some of the methods predefined and contain special columns to query them. Example of query all NFTs in low-level manner:

{
  raw_account_states(account_state_state_init_code_has_get_nft_data: 1) {
    address
    workchain
  }
}

Get method name	crc16
dnsresolve	123660
get_jetton_data	106029
get_wallet_address	103289
get_collection_data	102491
get_nft_address_by_index	92067
get_nft_data	102351
royalty_params	85719
hello_world	113531
get_owner	80293
seqno	85143
get_public_key	78748
get_version	82320
get_marketplace_address	91689
get_sale_data	72748
get_plugin_list	107653
is_plugin_installed	76407
get_subwallet_id	81467
get_editor	90228
get_is_closed	110449
get_reveal_mode	116695
get_reveal_data	93270
get_wallet_data	97026
get_telemint_token_name	69506
get_telemint_auction_state	122498