Issue with the `score` and `boost` functions not working with array operations in GROQ queries.

Any clue why the

score

and

boost

function do not work with array operations?

In fact any query that joins any other document fails if put inside

score

Hi Victor. Unfortunately, the

score()

function does not accept the dereference operator nor joins/subqueries. There’s a gotcha at the end of this section of the docs .

Ohh I see

Any workarounds?

I guess I could hack some webhook that inserts a hidden _tags value with the array in the form I need

It would be cool that document schemas could defined some kind of GROQ projection that acts similiar to SQL trigger

To compute values

Maybe an initial query that resolves the reference and then this becomes your second query that now “knows” which

_ref

to use (eliminating the need to dereference).

mmm

oh

Maybe this is an XY problem. Is this what you’re after?

It would be cool that document schemas could defined some kind of GROQ projection

Maybe there’s another way to go about it. Can you elaborate a bit on what you want to accomplish?

Sorry I was speculating a possible solution

The solution you mention could be enought

But I don't know if understand how to write the corresponding GROQ query

I’ll see if I can offer something more concrete, but I may not be able to get to it for a few days. In the meantime, you can chain projections together and each will pass its result to the next. In this (admittedly not great) example, the final projection is the one that returns a result and it’s using a dereference from the previous projection. It returns the

_id

if the author’s name contained “Victor” and null if it didn’t.

You can think of the output from this:

As replacing the

*

in a typical GROQ query (with respect to the second projection). In other words, the output from the above becomes the new “source” data.

I got it working using the examples you provided

Thank you!!

Great to hear!