List of where() Examples

Examples of where()

br.com.objectos.comuns.relational.search.Join.where()
com.adaptrex.core.ext.data.Store.where()
com.atlassian.jira.jql.builder.JqlQueryBuilder.where()
com.baasbox.util.QueryParams.where()
com.boco.bomc.vpn.db.bean.QueryCondition.where()
com.datastax.driver.core.querybuilder.Delete.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Select.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Update.where()
Adds a WHERE clause to this statement. This is a shorter/more readable version for {@code where().and(clause)}. @param clause the clause to add. @return the where clause of this query to which more clause can be added.
com.datastax.driver.core.querybuilder.Update.Assignments.where()
com.mysema.query.jpa.hibernate.HibernateQuery.where()
com.mysema.query.jpa.impl.JPAQuery.where()
com.mysema.query.sql.dml.SQLDeleteClause.where()
com.mysema.query.sql.dml.SQLUpdateClause.where()
com.mysql.clusterj.query.QueryDomainType.where()
com.taobao.tdhs.client.easy.Query.where()
start where condition for index @return Where
com.workingdogs.village.TableDataSet.where()
Sets the value for the SQL portion of the WHERE statement @param where TODO: DOCUMENT ME! @return instance of self @throws DataSetException TODO: DOCUMENT ME!
javax.persistence.criteria.CriteriaDelete.where()
Modify the query to restrict the target of the deletion according to the specified boolean expression. Replaces the previously added restriction(s), if any. @param restriction a simple or compound boolean expression @return the modified query
javax.persistence.criteria.CriteriaQuery.where()
javax.persistence.criteria.CriteriaUpdate.where()
Modify the query to restrict the target of the update according to the specified boolean expression. Replaces the previously added restriction(s), if any. @param restriction a simple or compound boolean expression @return the modified query
javax.persistence.criteria.Subquery.where()
Modify the subquery to restrict the result according to the specified boolean expression. Replaces the previously added restriction(s), if any. This method only overrides the return type of the corresponding AbstractQuery method. @param restriction a simple or compound boolean expression @return the modified subquery
net.sf.domainbeans.operation.annotation.Db.query.where()
nl.giantit.minecraft.database.query.DeleteQuery.where()
org.apache.empire.db.DBCommand.where()
Adds a compare expression to the list of constraints. If another restriction already exists for the same column it will be replaced. @param expr the DBCompareExpr object
org.apache.gora.sql.statement.Delete.where()
org.apache.isis.applib.annotation.Disabled.where()
org.apache.isis.applib.annotation.Hidden.where()
org.apache.isis.core.metamodel.facets.all.hide.HiddenFacet.where()
org.apache.isis.core.metamodel.facets.hide.HiddenFacet.where()
org.apache.isis.core.metamodel.facets.members.disabled.DisabledFacet.where()
org.apache.isis.core.progmodel.facets.members.disabled.DisabledFacet.where()
org.apache.isis.core.progmodel.facets.members.disabled.DisabledFacetAbstract.where()
org.apache.isis.core.progmodel.facets.members.hidden.HiddenFacetAbstract.where()
org.apache.juddi.query.util.DynamicQuery.WHERE()
org.apache.metamodel.query.Query.where()
org.apache.openjpa.jdbc.sql.Select.where()
Add the given where conditions.
org.apache.openjpa.persistence.query.DomainObject.where()
org.apache.openjpa.persistence.query.QueryDefinition.where()
Modifies the query definition to restrict the result of the query according to the specified predicate. Replaces the previously added restriction(s), if any. @param predicate -a simple or compound conditional predicate @return the modified QueryDefinition instance
org.apache.torque.criteria.Criteria.where()
"AND"s Criterion object with the conditions in this Criteria. Equivalent to #and(Criterion) but better to read if this is the first condition to be added to the Criteria. @param criterion A Criterion object. @return A modified Criteria object.
org.beangle.model.query.builder.OqlBuilder.where()
org.jboss.test.deployers.scope.support.TestClassAnnotation.where()
org.nutz.dao.sql.Criteria.where()
org.nutz.dao.util.cri.SimpleCriteria.where()
pt.webdetails.cpf.persistence.Filter.where()

Examples of org.apache.isis.core.progmodel.facets.members.hidden.HiddenFacetAbstract.where()


        final Facet facet = facetedMethod.getFacet(HiddenFacet.class);
        final HiddenFacetAbstract hiddenFacetAbstract = (HiddenFacetAbstract) facet;


        assertEquals(When.UNTIL_PERSISTED, hiddenFacetAbstract.when());
        assertEquals(Where.ANYWHERE, hiddenFacetAbstract.where());
    }


    public void testHiddenWhereCollectionTableAnnotationPickedUpOn() {
        class Customer {
            @Hidden(where=Where.PARENTED_TABLES)

View Full Code Here

Examples of org.apache.juddi.query.util.DynamicQuery.WHERE()

    }


    // Make sure keys aren't implicated in another transfer request
    DynamicQuery checkKeysQry = new DynamicQuery();
    checkKeysQry.append("select ttk.entityKey from TransferTokenKey ttk ");
    checkKeysQry.WHERE().pad().appendGroupedOr(params.toArray(new DynamicQuery.Parameter[0]));


    Query qry = checkKeysQry.buildJPAQuery(em);
    List<?> obj = qry.getResultList();
    if (obj != null && obj.size() > 0)
      throw new TokenAlreadyExistsException(new ErrorMessage("errors.gettransfertoken.KeyExists", (String)obj.get(0)));

View Full Code Here

Examples of org.apache.metamodel.query.Query.where()

        QueryPostprocessDataContext dc = new CsvDataContext(file);
        Table table = dc.getDefaultSchema().getTableByName("csv_people.csv");


        Query q = new Query();
        q.from(table);
        q.where(new FilterItem(new SelectItem(table.getColumnByName("id")), OperatorType.EQUALS_TO, 1));
        q.select(table.getColumnByName("name"));
        DataSet data = dc.executeQuery(q);
        assertTrue(data.next());
        assertEquals("Row[values=[mike]]", data.getRow().toString());
        assertFalse(data.next());

View Full Code Here

Examples of org.apache.metamodel.query.Query.where()

                    // This is the first split query: no higherThan filter and
                    // include
                    // IS NULL
                    FilterItem nullFilter = new FilterItem(new SelectItem(column), OperatorType.EQUALS_TO, null);
                    FilterItem orFilterItem = new FilterItem(lowerThanFilter, nullFilter);
                    q.where(orFilterItem);
                } else if (i + 1 == numSplits) {
                    // This is the lats split query: no lowerThan filter,
                    FilterItem orFilterItem = new FilterItem(higherThanFilter, equalsFilter);
                    q.where(orFilterItem);
                } else {

View Full Code Here

Examples of org.apache.metamodel.query.Query.where()

                    FilterItem orFilterItem = new FilterItem(lowerThanFilter, nullFilter);
                    q.where(orFilterItem);
                } else if (i + 1 == numSplits) {
                    // This is the lats split query: no lowerThan filter,
                    FilterItem orFilterItem = new FilterItem(higherThanFilter, equalsFilter);
                    q.where(orFilterItem);
                } else {
                    higherThanFilter = new FilterItem(higherThanFilter, equalsFilter);
                    lowerThanFilter = new FilterItem(lowerThanFilter, equalsFilter);
                    q.where(higherThanFilter);
                    q.where(lowerThanFilter);

View Full Code Here

Examples of org.apache.metamodel.query.Query.where()

                    FilterItem orFilterItem = new FilterItem(higherThanFilter, equalsFilter);
                    q.where(orFilterItem);
                } else {
                    higherThanFilter = new FilterItem(higherThanFilter, equalsFilter);
                    lowerThanFilter = new FilterItem(lowerThanFilter, equalsFilter);
                    q.where(higherThanFilter);
                    q.where(lowerThanFilter);
                }
                result.add(q);
            }
        }

View Full Code Here

Examples of org.apache.metamodel.query.Query.where()

                    q.where(orFilterItem);
                } else {
                    higherThanFilter = new FilterItem(higherThanFilter, equalsFilter);
                    lowerThanFilter = new FilterItem(lowerThanFilter, equalsFilter);
                    q.where(higherThanFilter);
                    q.where(lowerThanFilter);
                }
                result.add(q);
            }
        }
        return result;

View Full Code Here

Examples of org.apache.openjpa.jdbc.sql.Select.where()

            return sel;
        }


        // now set sql criteria; it goes on the inner select if present
        if (inner != null)
            inner.where(where);
        else
            sel.where(where);


        // apply grouping and having.  this does not select the grouping
        // columns, just builds the GROUP BY clauses.  we don't build the

View Full Code Here

Examples of org.apache.openjpa.persistence.query.DomainObject.where()

    }


    public void testFetchJoin() {
        DomainObject d = qb.createQueryDefinition(Department.class);
        d.leftJoinFetch("employees");
        d.where(d.get("deptNo").equal(1));
        
        
        String jpql = "select d from Department d" +
                      " LEFT JOIN FETCH d.employees" +
                      " where d.deptNo = 1";

View Full Code Here

Examples of org.apache.openjpa.persistence.query.QueryDefinition.where()

    }
    
    public void testParamater() {
        QueryDefinition qdef = qb.createQueryDefinition();
        DomainObject customer = qdef.addRoot(Customer.class);
        qdef.where(customer.get("status").equal(qdef.param("status")));
        
        String jpql = "select c from Customer c " +
                      " where c.status = :status";
        compare(jpql, qdef, "status", 1);
    }

View Full Code Here

0 1 2 3 4 5 6 7 8

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.