How to listDocuments using or query by document ids

[ivory harbor]

I'm encountering a problem when executing a query to get all the documents for an array of id's in Java.

This is my the query I'm passing:

                eventIds.stream()
                        .map(eventId -> Query.Companion.equal("$id", eventId.toString()))
                        .toList()
        ));```

When executing this query using databases.listDocuments() I'm getting the following error:
```Invalid query: Attribute not found in schema: _uid```

It seems like it's converting the $ character to _u in the query.
If I try to do the same with an attribute I set myself, let's say the attribute "name" everything works as expected.
But I want to select the documents by their documentId and not by an attribute I set myself.

Appreciate any help, I'm sure it's just a little mistake I'm making here.

This is my Java code for the listDocuments():
```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();
                    }));```

[topaz trail]

Hey there 👋 Code looks good to me. What Appwrite version are you running?

[ivory harbor]

I'm on version 1.5.5 self hosted

[topaz trail]

Hmm honestly, I am not sure what could be the issue. Let me cc @blazing wharf for this one

[blazing wharf]

ya seems like a bug. can you create a github issue for this?

[ivory harbor]

Thank you for your help. I created issue #8219 for this bug. Feel free to let me know if any information is missing.

[blazing wharf]

thanks! For now...how about you try doing something like:

List<String> queries =  List.of(
    Query.Companion.equal(
       "$id",
        eventIds.toList()
    ));

[ivory harbor]

Thank you very much, that solution worked and is even prettier than mine