I would like to do like:
SELECT
mat.idmat AS mat,
$P{mylist}.indexOf(mat.idmat) AS myorder,
...
FROM
...
WHERE
...
ORDER BY myorder
In this sql I have a list who index the position of each element, so i want to order using the list
I would like to do like:
SELECT
mat.idmat AS mat,
$P{mylist}.indexOf(mat.idmat) AS myorder,
...
FROM
...
WHERE
...
ORDER BY myorder
In this sql I have a list who index the position of each element, so i want to order using the list