Querying Data
| Function | Syntax | Description | Example |
|---|---|---|---|
all | Obj:all() | Returns all records from the table. | Person[] plist = Person:all(); |
equals | Obj:equals(a,b) | Returns records with value of | Person[] plist = Person:equals(deleted, false); |
notEquals | Obj:notEquals(a,b) | Returns records with value of a not equal to b. | Person[] plist = Person:notEquals(deleted, true); |
empty | Obj:empty(a) | Returns records with a equal to null. | Person[] plist = Person:empty(mobileNum); |
notEmpty | Obj:notEmpty(a) | Returns records with a not equal to null. | Person[] plist = Person:notEmpty(mobileNum); |
between | Obj:between(a,x,y) | Returns records with value of a within the range of values between x and y. | Person[] plist = Person:between(dob, date1, date2); |
notBetween | Obj:notBetween(a,x,y) | Returns records with value of a not within the range of values between x and y. | Person[] plist = Person:notBetween(dob, date1, date2); |
lessThanOrEqual | Obj:lessThanOrEqual(a,b) | Returns records with value of a less than or equal to b. | Person[] plist = Person:lessThanOrEqual(age, num); |
lessThan | Obj:lessThan(a,b) | Returns records with value of a less than b. | Person[] plist = Person:lessThan(age, num); |
greaterThan | Obj:greaterThan(a,b) | Returns records with value of a greater than b. | Person[] plist = Person:greaterThan(age, num); |
attributeIn | Obj:attributeIn(a,b) | Returns records with value of a matching any of the values b (replace b with a list of values of the same type as a). | Person[] plist = Person:attributeIn(state, state_list); |
notAttributeIn | Obj:notAttributeIn(a,b) | Returns records with value of a not matching any of the values b (replace b with a list of values of the same type as a). | Person[] plist = Person:notAttributeIn(state, state_list); |
relationshipIn | Obj:relationshipIn(a,b) | Returns records with a relationship/link between a and b, with attribute a being annotated as @OneToMany, @ManyToOne, etc. and b a persistent object instance. Attribute a can be likened to a foreign key. | Person[] plist = Person:relationshipIn(reportsTo, person); |
notRelationshipIn | Obj:notRelationshipIn(a,b) | Returns records without a relationship/link between a and b, with attribute a being annotated as @OneToMany, @ManyToOne, etc. and b a persistent object instance. Attribute a can be likened to a foreign key. | Person[] plist = Person:notRelationshipIn(reportsTo, person); |
contains | Obj:contains(a,b) | Returns records with substring b found anywhere within value of a. | Person[] plist = Person:contains(name, "a"); |
beginsWith | Obj:beginsWith(a,b) | Returns records with substring b found at the beginning of the value of a. | Person[] plist = Person:beginsWith(name, "a"); |
endsWith | Obj:endsWith(a,b) | Returns records with substring b found at the end of the value of a. | Person[] plist = Person:endsWith(name, "a"); |
notContains | Obj:notContains(a,b) | Returns records with substring b found nowhere within value of a. | Person[] plist = Person:notContains(name, "a"); |
notBeginWith | Obj:notBeginWith(a,b) | Returns records with substring b not found at the beginning of the value of a. | Person[] plist = Person:notBeginWith(name, "a"); |
notEndsWith | Obj:notEndsWith(a,b) | Returns records with substring b not found at the end of the value of a. | Person[] plist = Person:notEndsWith(name, "a"); |
union | Obj:union(selector1(a,b), selector2(x,y)) | Combines the results of two or more selectors. Does not return the same record twice. | Person[] plist = Person:union(equals(rating, "good"), equals(rating, "excellent")); |
diff | Obj:diff(selector1(a,b), selector2(x,y)) | Compares the results of two or more selectors and returns only the difference. | Person[] plist = Person:diff(equals(), equals()); |
intersect | Obj:intersect(selector1(a,b), selector2(x,y)) | Returns records for which all the selectors are true. | Person[] plist = Person:intersect(equals(deleted, false), equals(active, true)); |
and | Obj:and(selector1(a,b), selector2(x,y)) | Returns records for which all the selectors are true. | Person[] plist = Person:and(equals(deleted, false), equals(active, true)); |