Filters

filtering data in a request you can apply filters to any field depending on type chose any field from table schema https //docs dton io/transactions and account states syntax field filter example { "endpoint" "https //dton io/graphql/", "query" "{\nraw transactions(parsed dns domain contains \\"dton\\"){\n address\n workchain\n parsed dns domain\n }\n}" } 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 friendly filter by user friendly form of address accepts bounceable, non bounceable and raw form (workchain\ address) friendly in filter on a list of addresses in user friendly form accepts bounceable, non bounceable and raw form (workchain\ address) 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 { "endpoint" "https //dton io/graphql/", "query" "{\n raw transactions(\n and \[{workcain 1, seqno 1}, {seqno 2}]\n ) {\n seqno\n workchain\n }\n}" } 2\ or this filter is used to apply a logical or to multiple conditions { "endpoint" "https //dton io/graphql/", "query" "{\n raw transactions(\n or \[{seqno 1}, {seqno 2}]\n ) {\n seqno\n shard\n }\n}" } 3\ not this filter is used to negate a condition { "endpoint" "https //dton io/graphql/", "query" "{\n raw transactions(\n not {seqno 1}\n ) {\n seqno\n shard\n }\n}" } 4\ nested filters (max depth 3) { "endpoint" "https //dton io/graphql/", "query" "{\n raw transactions(or \[\n {seqno 0}, \n {seqno 1}, \n {seqno 2}, \n {and {seqno gt 10, seqno lte 15}}]) {\n seqno\n }\n}" }