Fetch by "key" in array

[richcorbs]

I'm trying to do the equivalent of an "in" query in Base like so:

db.projects.fetch({ "key": ["key-1", "key-2", "key-3"] })

It doesn't seem to work.

The documentation makes it look like this pattern works. But maybe it doesn't work for the "key" field?

{"fav_numbers": [2, 4, 8]}

Is there another way? I'd rather not have to make multiple queries (one per array element) to get what I'm after.

[jnsougata]

[ ❌ ] db.projects.fetch([{ "key": "key-1"}, { "key": "key-2"}.....{ "key": "key-N"}])
for reference check: https://docs.deta.sh/docs/base/queries/#equal

[jnsougata]

yes, previously I did the same mistake. the query we are trying to make is invalid. rather you can write a func and fetch those keys from base asynchronously

[abdelhai]

@richcorbs both of them are invalid

[richcorbs]

So at this point the only option is to loop through the ids and get/fetch them one at a time?

If I were querying by some other key the OR query would work. Correct?

[abdelhai]

try to figure out a way to query based on a different attribute other than the key. keys are special but limited for querying.
for keys, you still can query based on key prefixes and ranges, etc

[richcorbs]

I guess I could denormalize the key into a queryable key field. Looping seems ok for now.

[amjed-ali-k]

To avoid multiple queries, you can create a new duplicate field for key on each item.

{
"key" : "0c9f904ffb9540f7a1539add854b7bc3",
"id": "0c9f904ffb9540f7a1539add854b7bc3",
"value": "Sample"
}

and query them by the duplicate field.

  deta.Base("test").fetch([ {"id": "0c9f904ffb9540f7a1539add854b7bc3"}, {"id": "093889577a4b4955be79e8fde331720e"}]).items