Internal Website Search

1-10 of 87 resultsRefresh

Query filter comparing Dates

across some weird behaviour in query filters comparing this Date field. Could You please clarify ... before saving: Tue Feb 02 01:00:00 CET 2021 Match found 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

WHERE clause (JPQL / Criteria API)

The WHERE clause adds filtering capabilities to the FROM-SELECT structure ... for collecting as query results, the WHERE clause gets an opportunity to function as a filter ... >WHERE Predicate and Indexes Formally, the WHERE clause functions as a filter between the FROM

GROUP BY and HAVING clauses

filtering (if any) are sent to grouping by the GROUP BY clauses before arriving at the SELECT clause.filtered using the HAVING clause. The HAVING clause for the GROUP BY clause is like the WHERE clause ... clause stands as a filter between the GROUP BY clause and the SELECT clause in such a way

combined index not used

] 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 retaining

setFilter(filter)

.Queryvoid setFilter(  String filter) Set the filter for the query. The filter specification is a filter is not specified, then it defaults to "true

newQuery(cln, filter)

">Extent cln,   String filter) and filter; the class is taken from the Extent . - the Extent of candidate instances filter

newQuery(cls, cln, filter)

>  String filter) Create a new ... Collection , and filter. Collection of candidate instances filter

newQuery(cls, filter)

.jdo">Query newQuery(  Class cls,   String filter) with the Class of the candidate instances and filter. Class of results filter - the filter

[ODB1] Chapter 7 - JDOQL Queries

a persistent class) A filter, which is a boolean expression in a Java like syntax ... that contains only the instances of the candidate class satisfying the given filter. In addition ... above, the candidate class is Person and the filter is "this.age >= 18"

javax.jdo.Query

of instances, and the filter. There are optional elements: parameter declarations ... the candidate class, filter, parameter declarations, variable declarations, imports, ordering ... the filter if not explicitly declared in the subquery.