GRAPH QL Filters

Hey Team
The GraphQL API in Appwrite currently only supports single document fetches (databasesGetDocument) properly. So trying to pass databasesListDocuments with filters in GraphQL will always throw Invalid query method.
Is there any work around for this .

Checkout the List Rows section in these docs: https://appwrite.io/docs/products/databases/rows

The latest TablesDB supports fetching multiple records

Can Someone for reference provide a repo as the docs do not provide the correct syntax

Well, I don't have a repo. But you can refer this -

  tablesListRows(
    databaseId: "<DATABASE_ID>",
    tableId: "<TABLE_ID>",
    queries: ["equal(\"<COLUMN_NAME>\", \"<VALUE>\")"]
  ) {
    total
    rows {
      $id
      genre
    }
  }
}

query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal("book_title", ["gaaa"])"]
) {
total
rows {
_id
data
}
}
}

Book Response: {'errors': [{'message': 'Invalid query: Syntax error', 'extensions': {'category': 'appwrite'}, 'locations': [{'line': 3, 'column': 13}], 'path': ['tablesDBListRows'], 'trace': [{'file': '/usr/src/code/src/Appwrite/GraphQL/Resolvers.php', 'line': 56, 'call': 'Appwrite\GraphQL\Resolvers::resolve(instance of Utopia\App, instance of Appwrite\Utopia\Request, instance of Appwrite\Utopia\Response, instance of Closure, instance of Closure)'}, {'file': '/usr/src/code/src/Appwrite/Promises/Swoole.php', 'line': 21, 'call': 'Appwrite\GraphQL\Resolvers::Appwrite\GraphQL\{closure}(instance of Closure, instance of Closure)'}, {'call': 'Appwrite\Promises\Swoole::Appwrite\Promises\{closure}()'}]}], 'data': {'tablesDBListRows': None}}
No book found with the given title.

book_query = f"""
query {{
tablesListRows(
databaseId: "{DATABASE_ID}",
tableId: "{BOOK_COLLECTION_ID}",
queries: ["equal("book_title", ["gaaa"])"]
) {{
total
rows {{
_id
data
}}
}}
}}
"""

Book Response: {'errors': [{'message': 'Cannot query field "tablesListRows" on type "Query". Did you mean "tablesDBListRows", "tablesDBGetRow", "tablesDBListRowLogs", "databasesListLogs", or "sitesListLogs"?', 'extensions': {'category': 'graphql'}, 'locations': [{'line': 3, 'column': 13}]}]}

If You see I tried the syntax which was sent by you but I am facing two different problems with different syntax

Hey! You are still writing it incorrectly. You should write it like this - ```query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal("book_title", ["gaaa"])"]
) {
total
rows {
_id
data
}
}
}

The error was coming from this part "equal("book_title", ["gaaa"])" which should be written like this: "equal(\"book_title\", [\"gaaa\"])"

book_query = f"""
query {{
tablesDBListRows(
databaseId: "{DATABASE_ID}",
tableId: "{BOOK_COLLECTION_ID}",
queries: ["equal(\"book_title\", [\"gaaa\"])"]
) {{
total
rows {{
_id
data
}}
}}
}}
"""

Book Response: {'errors': [{'message': 'Invalid query: Syntax error', 'extensions': {'category': 'appwrite'}, 'locations': [{'line': 3, 'column': 13}], 'path': ['tablesDBListRows'], 'trace': [{'file': '/usr/src/code/src/Appwrite/GraphQL/Resolvers.php', 'line': 56, 'call': 'Appwrite\GraphQL\Resolvers::resolve(instance of Utopia\App, instance of Appwrite\Utopia\Request, instance of Appwrite\Utopia\Response, instance of Closure, instance of Closure)'}, {'file': '/usr/src/code/src/Appwrite/Promises/Swoole.php', 'line': 21, 'call': 'Appwrite\GraphQL\Resolvers::Appwrite\GraphQL\{closure}(instance of Closure, instance of Closure)'}, {'call': 'Appwrite\Promises\Swoole::Appwrite\Promises\{closure}()'}]}], 'data': {'tablesDBListRows': None}}
Error fetching book: 'NoneType' object has no attribute 'get'

Still running into error

Ok. Try removing the square braces: ```book_query = f"""
query {{
tablesDBListRows(
databaseId: "{DATABASE_ID}",
tableId: "{BOOK_COLLECTION_ID}",
queries: ["equal(\"book_title\", \"gaaa\")"]
) {{
total
rows {{
_id
data
}}
}}
}}
"""

query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal(\"book_title\", \"gaaa\")"]
) {
total
rows {
_id
data
}
}
}

127.0.0.1 - - [14/Nov/2025 11:12:41] "POST /graphql HTTP/1.1" 200 -
Book Response: {'errors': [{'message': 'Invalid query: Syntax error', 'extensions': {'category': 'appwrite'}, 'locations': [{'line': 3, 'column': 13}], 'path': ['tablesDBListRows'], 'trace': [{'file': '/usr/src/code/src/Appwrite/GraphQL/Resolvers.php', 'line': 56, 'call': 'Appwrite\GraphQL\Resolvers::resolve(instance of Utopia\App, instance of Appwrite\Utopia\Request, instance of Appwrite\Utopia\Response, instance of Closure, instance of Closure)'}, {'file': '/usr/src/code/src/Appwrite/Promises/Swoole.php', 'line': 21, 'call': 'Appwrite\GraphQL\Resolvers::Appwrite\GraphQL\{closure}(instance of Closure, instance of Closure)'}, {'call': 'Appwrite\Promises\Swoole::Appwrite\Promises\{closure}()'}]}], 'data': {'tablesDBListRows': None}}
Error fetching book: 'NoneType' object has no attribute 'get'

Can you please add an underscore before your column name? And share the outputs?

query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal("_book_title", "gaaa")"]
) {
total
rows {
_id
data
}
}
}

127.0.0.1 - - [14/Nov/2025 11:18:10] "POST /graphql HTTP/1.1" 200 -
Book Response: {'errors': [{'message': 'Invalid query: Syntax error', 'extensions': {'category': 'appwrite'}, 'locations': [{'line': 3, 'column': 13}], 'path': ['tablesDBListRows'], 'trace': [{'file': '/usr/src/code/src/Appwrite/GraphQL/Resolvers.php', 'line': 56, 'call': 'Appwrite\GraphQL\Resolvers::resolve(instance of Utopia\App, instance of Appwrite\Utopia\Request, instance of Appwrite\Utopia\Response, instance of Closure, instance of Closure)'}, {'file': '/usr/src/code/src/Appwrite/Promises/Swoole.php', 'line': 21, 'call': 'Appwrite\GraphQL\Resolvers::Appwrite\GraphQL\{closure}(instance of Closure, instance of Closure)'}, {'call': 'Appwrite\Promises\Swoole::Appwrite\Promises\{closure}()'}]}], 'data': {'tablesDBListRows': None}}
Error fetching book: 'NoneType' object has no attribute 'get'

query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal("book_title", "gaaa")"]
) {
total
rows {
_id
data
book_title
}
}
}

query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal("book_title", "gaaa")"]
) {
total
rows {
_id
data
book_title
}
}
}

Book Response: {'errors': [{'message': 'Field "tablesDBListRows" argument "queries" requires type String, found book_title.', 'extensions': {'category': 'graphql'}, 'locations': [{'line': 6, 'column': 34}]

Hey! Please write it like this. Sorry I missed the backslashes in my previous reply. Here's the actual one:

book_query = f"""
query {{
  tablesDBListRows(
    databaseId: "{DATABASE_ID}",
    tableId: "{BOOK_COLLECTION_ID}",
    queries: ["equal(\"book_title\", \"gaaa\")"]
  ) {{
    total
    rows {{
      _id
      data
      book_title
    }}
  }}
}}
"""

query {
tablesDBListRows(
databaseId: "690b62ea0019a21bfd2c",
tableId: "book",
queries: ["equal("book_title", "gaaa")"]
) {
total
rows {
_id
data
book_title
}
}
}

127.0.0.1 - - [14/Nov/2025 12:22:15] "POST /graphql HTTP/1.1" 200 -
Book Response: {'errors': [{'message': 'Cannot query field "book_title" on type "Row".', 'extensions': {'category': 'graphql'}, 'locations': [{'line': 12, 'column': 15}]}]}
No book found with the given title.

book_query = f"""
query {{
tablesDBListRows(
databaseId: "{DATABASE_ID}",
tableId: "{BOOK_COLLECTION_ID}",
queries: ["equal(\"book_title\", \"gaaa\")"]
) {{
total
rows {{
_id
data
book_title
}}
}}
}}
"""

@user
Can you kindly provide a solution for filters in graph ql as the docs are not up to date

@user kindly provide a solution for the graph ql queries