Possibility to query only for specific Record Id in ArrayId without WHERE?

[Zercerium]

Hi,

i think this example should make it clear.

populate some data:

CREATE temp:['London',rand:uuid:v7()];
CREATE temp:['London',rand:uuid:v7()];
CREATE temp:['London',rand:uuid:v7()];
CREATE temp:['London',rand:uuid:v7()];
CREATE temp:['Munich',rand:uuid:v7()];
CREATE temp:['Munich',rand:uuid:v7()];
CREATE temp:['Munich',rand:uuid:v7()];
CREATE temp:['Munich',rand:uuid:v7()];

it is possible to query only ids which are from London without a WHERE statement?
I thought this would be possible: SELECT * FROM temp:['London',NONE]..=['London',NONE]; which should return 4 entries. (A workaround would be to specify the max possible uuid as a string instead of NONE.)

I also think this https://surrealdb.com/docs/surrealdb/surrealql/datamodel/ids#record-ranges example is a bit misleading because SELECT * FROM temperature:['London', '2022-08-29T08:03:39']..; should intuitively only returns readings from London, after the specified time. This is not the case; it also returns all readings from locations which are alphabetical sorted after London.
For example SELECT * FROM temp:['London',NONE]..; would return 8 entries. This makes not really sense for this specific example in my opinion.

[AlexFrid]

Hey @Zercerium, I see what you mean.

The current way of doing it would be like this

SELECT * FROM temp:['London',NONE]..['Munich',NONE]

We'll update that in docs, but feel free to open a feature request to suggest an alternative behaviour.

[Zercerium]

Hi thanks a lot for the reply.

Sadly the suggestion breaks as fast as you insert for example "Luxembourg".

I will open a feature request in the following days :)

[AlexFrid]

Sounds good, thanks for raising that, it has prompted us to think about how to do this better 🙌

[Zercerium]

for tracking #3737
thanks a lot for your great work with surreal. really like the ideas & approaches