Search code examples
databaseorientdbnosql

How to filter contents in linked list using select statement?

A class has a property which holds link of rid's.ie testcaseLink:[#20:0,#20:1].I have a problem in selecting only certain rids from the testcaseLink using select statement.

Looking for something like select testcaseLink.get(#20:0) from tableName.Is there is any method to filter the contents of collections in orientdb

Solution

  • select testCaseLink[@rid=#20:6 OR @rid=#20:8] from tableName where ColumnName='Value' Solved the problem