N1QL Sort by via Place holder

[vsr1]

Identifiers, Filed names , reserve keywords can’t be used as place holders. Those must be static to optimizer decide on the plan during prepare time. Place holders are available only during execution. Only values can be place holders.

If you need dynamic key (dictionary access) order only (not direction of order). Query will do explicit order and optimizer can’t use index order.

SELECT *
FROM default AS d
WHERE …
ORDER BY d.[$3] DESC;

$3 must be string of field in the document, if not string it raises error.

Order by filed (list)

Hi @vsr1 is it possible to order by field? something like: select * from bucket where foo=bar order by field (xxx, “us”, “gb”, “es”) ? I can’t find any documentation related to this, and if I try the above I get an error: “Number of arguments to function FIELD must be 2. - at end of input” What I need is to be able to order the results in a specific order based on a list of values, not just ASC or DESC