🐛 Bug Report: listDocuments by multiple document ID's returning error "Invalid query: Attribute not found in schema: _uid"

[marc1107]

👟 Reproduction steps

When I use the Java SDK to retreive all documents which have any of the ID's in a list by using the following query:

List<String> queries =  List.of(Query.Companion.or(
                eventIds.stream()
                        .map(eventId -> Query.Companion.equal("$id", eventId.toString()))
                        .toList()
        ));

and the following code to execute the query:

databases.listDocuments(
                "event-db",
                "event",
                queries,
                new CoroutineCallback<>((result, error) -> {
                    if (error != null) {
                        log.error(error.getMessage());
                    } else {
                        assert result != null;
                        log.info("{} Events found", result.getDocuments().size());
                        result.getDocuments().forEach(document -> events.add(appwriteDataToEvent(document)));
                    }

                    latch.countDown();
                }));

👍 Expected behavior

It should return all the documents (in this case events) which have one of the id's in the eventId List (which is a List of UUID's).

👎 Actual Behavior

It actually throws the following error:
Invalid query: Attribute not found in schema: _uid

It seems like it is converting the "$id" to "_uid".

Discord thread: https://discord.com/channels/564160730845151244/1245305111539093585

🎲 Appwrite version

Version 1.5.x

💻 Operating system

MacOS

🧱 Your Environment

Appwrite v1.5.5 self hosted, Kotlin SDK v5.0.2

👀 Have you spent some time to check if this issue has been raised before?

• I checked and didn't find similar issue

🏢 Have you read the Code of Conduct?

• I have read the Code of Conduct

[stnguyen90]

@marc1107, thanks for raising this issue! 🙏🏼 It's odd that you can query on $id like:

Query.equal("$id", ["id1", "id2"])

but it doesn't work when nested like:

Query.or([
  Query.equal("$id", ["id1"]),
  Query.equal("$id", ["id2"])
])

Let me bring this up to the team.