total parameter not working correctly in listRows() (Node.js & Dart SDKs)
- 0
- 3
- Flutter
- Web
- Databases
- Cloud
- Functions
Hello Appwrite team,
I'm experiencing issues with the total parameter in the listRows() method (TablesDB) across multiple SDKs.
Issue 1: Node.js SDK (node-appwrite: ^21.1.0)
The total parameter doesn't affect the response as expected. According to the documentation, when total: false, the response should return total: 0. However, I'm getting the actual count regardless of the parameter value.
// Both calls return the same result (e.g., total: 700)
const response1 = await tables.listRows({
databaseId: 'main',
tableId: 'users',
queries: [sdk.Query.limit(1)],
total: true, // Returns total: 700
});
const response2 = await tables.listRows({
databaseId: 'main',
tableId: 'users',
queries: [sdk.Query.limit(1)],
total: false, // Also returns total: 700, expected: 0
});
Issue 2: Dart SDK (dart_appwrite: 20.1.0)
When trying to use the total parameter in Dart cloud functions, I get a type error:
type 'bool' is not a subtype of type 'Iterable<dynamic>'
Could you please investigate this issue?
Thank you!
I just noticed this issue too.
appwrite-20.3.2/lib/src/client_mixin.dart
} else if (method == HttpMethod.get) {
if (params.isNotEmpty) {
Map<String, dynamic> filteredParams = {};
params.forEach((key, value) {
if (value != null) {
if (value is int || value is double) {
filteredParams[key] = value.toString();
} else if (value is List) {
filteredParams["$key[]"] = value;
} else {
filteredParams[key] = value;
}
}
});
params = filteredParams;
}
uri = Uri(
fragment: uri.fragment,
path: uri.path,
host: uri.host,
scheme: uri.scheme,
queryParameters: params,
port: uri.port,
);```
This part causes it. The bool doesnt get filtered and Uri expects a String?|Iterable<String> and throws
Hi, just to let you know I've encountered the same issue with the flutter SDK and I've created the following issue on Github: https://github.com/appwrite/sdk-for-flutter/issues/292
Recommended threads
- MariaDB refuses to connect to appwrite
Earlier, I tried updating my Appwrite version from 18.1.x to the latest release because my Flutter package required it to function properly. I used the official...
- Custom API domain is unreachable
Earlier my custom api domain was working fine. Now it seems to be offline without a trace a few hours later. I didn't change anything, all the relevant DNS reco...
- "Invalid console fingerprint" when unpau...
I've tried logging out and logging back in, still can't figure out why this is happening.