logo

SJQL Support

SJQL Support

This project source code is available on github at https://github.com/deanhiller/playorm.

Playorm supports Scalable JQL. Below table lists different SJQL query language constructs that are supported for a datastore in Playorm.

SJQL clause In-memory Cassandra MongoDB
SELECT
UPDATE
DELETE
WHERE
AND
OR
IN
INNER JOIN
LEFT JOIN
=
>
<
>=
<=
PARTITIONS

Important note:

  • WHERE clause is only supported for those fields which are indexed or if a field is a Primary key (Row key). So you need to either have @NoSqlId or @NoSqlIndexed annotation on the field if you want to use that in WHERE clause.

 << Back to Documentation Index