Order by an array

[Shanlie Suresh]

Is it possible use order by of an array similar to mysql?

SELECT * FROM mytable WHERE id IN (3,2,1,4) ORDER BY FIELD(id,3,2,1,4);

Thanks,

Shanlie

[Luigi Dell'Aquila]

Hi Shanlie,

Do you mean a custom ordering (first records with 3, then with 2 and so on)?

No it's not currently supported, but you can open an issue for this, we'll consider it for an enhancement in next releases

Thanks

Luigi

--

---
You received this message because you are subscribed to the Google Groups "OrientDB" group.
To unsubscribe from this group and stop receiving emails from it, send an email to orient-database+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.