ObjectDB ObjectDB

Internal Website Search

1-10 of 80 resultsRefresh
173

Query filter comparing Dates

in query filters comparing this Date field. Could You please clarify why are there zero-size result ... for filter : this.date == datum Date from DB instance : Tue Feb 02 00:00:00 CET 2021 Date from filter param : Tue Feb 02 01:00:00 CET 2021 Match found for filter : this.type.equals("type1
71

WHERE clause (JPQL / Criteria API)

The WHERE clause adds filtering capabilities to the FROM-SELECT structure. It is essential in any ... to function as a filter. The boolean expression in the WHERE clause, which is also known as ... and Indexes Formally, the WHERE clause functions as a filter between the FROM and the SELECT clauses
28

GROUP BY and HAVING clauses

) that are generated by the FROM clause iteration and pass the WHERE clause filtering (if any) are sent ... with HAVING Groups in JPQL grouping queries can be filtered using the HAVING clause. The HAVING clause ... The HAVING clause stands as a filter between the GROUP BY clause and the SELECT clause in such a way
22

combined index not used

. [Step 1b] Filter the results of step 1a retaining only results that satisfy: (a.endDate>=:1). [Step 1c] Retrieve fields in Action (a) instances. [Step 1d] Filter the results of step 1c retaining only results that satisfy: (a.state=3). [Step 1e] Filter the results of step 1d
10

setFilter(filter)

Method javax.jdo.Query void setFilter( String filter ) Set the filter for the query. The filter ... of the instances in the candidate collection. If the filter is not specified, then it defaults to "true", which has the effect of filtering the input Collection only for class type. An element of the candidate
9

newQuery(cln, filter)

Method javax.jdo.PersistenceManager Query newQuery( Extent cln, String filter ) Create a new Query with the candidate Extent and filter; the class is taken from the Extent. Parameters: cln - the Extent of candidate instances filter - the filter for candidate instances Returns: the new Query Since: JDO 1.0
9

newQuery(cls, cln, filter)

Method javax.jdo.PersistenceManager Query newQuery( Class cls, Collection cln, String filter ) Create a new Query with the Class of the candidate instances, candidate Collection, and filter. Parameters: cls - the Class of candidate instances cln - the Collection of candidate instances filter
9

newQuery(cls, filter)

Method javax.jdo.PersistenceManager Query newQuery( Class cls, String filter ) Create a new Query with the Class of the candidate instances and filter. Parameters: cls - the Class of results filter - the filter for candidate instances Returns: the new Query Since: JDO 1.0
7

[ODB1] Chapter 7 - JDOQL Queries

a persistent class) A filter, which is a boolean expression in a Java like syntax The query result ... satisfying the given filter. In addition to these three main components, queries can include ... the query above, the candidate class is Person and the filter is "this.age >= 18". When a candidate
2

javax.jdo.Query

of instances, and the filter. There are optional elements: parameter declarations, variable declarations ... are copied for use as the subquery. The parts copied include the candidate class, filter, parameter ... which they are declared in the subquery, or in the order they are found in the filter if not explicitly declared in

Getting Started

ObjectDB is very easy to use. Follow the Getting Started Tutorial and the Quick Tour manual chapter and in minutes you may be able to write and run first Java programs against ObjectDB.

Prior knowledge or experience in database programming (SQL, JDBC, ORM, JPA, etc.) is not required, but some background in using the Java language is essential.

Need Help?

  1. Search ObjectDB website
  2. Read the FAQ
  3. Follow the Tutorials
  4. View or post in the forum
  5. Search or file an issue
  6. Contact support