Query Examples with Other Options

When you do not specify other options to find except the table path, the command returns all documents. The following example returns all documents that are in the /data/movies table:

find /data/movies        

The following example returns at most 32 documents within a range of IDs that includes the specified starting ID and excludes the specified ending ID:

find /data/movies --fromid movie0000001 --toid movie0000100 --limit 32          

The following example returns the document that has the specified ID:

findbyid /data/movies --id movie0000002          

The following example performs a find operation with a projection and condition and limits the result to 10 documents:

find /tbl --c {
              "$and":[
                 {"$eq":{"a.b[0].boolean":false}},
                 {"$or":[
                    {"$ne":{"a.c.d":5}},
                    {"$gt":{"a.b[1].decimal":1}},
                    {"$lt":{"a.b[1].decimal":10}}
                 ]}
              ]}
           --fields m,a.c.e --limit 10

The projection is on fields on m and a.c.e. The condition is the following expression:

(a.b.[0].boolean == false && (a.c.d != 5 || a.b[1].decimal > 1 || a.b[1].decimal < 10))

The following example is identical to the previous one, except it also includes an ordering on the result:

find /tbl --c {
              "$and":[
                 {"$eq":{"a.b[0].boolean":false}},
                 {"$or":[
                    {"$ne":{"a.c.d":5}},
                    {"$gt":{"a.b[1].decimal":1}},
                    {"$lt":{"a.b[1].decimal":10}}
                 ]}
               ]}
           --fields m,a.c.e 
           --orderby m,a.c.e:desc
           --limit 10