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 javax.persistence.criteria.CriteriaQuery.where()

        Root<Customer> customer = cquery.from(Customer.class);


        //Get Metamodel from Root
        EntityType<Customer> Customer_ = customer.getModel();


        cquery.where(cb.equal(
                customer.get(Customer_.getSingularAttribute("name", String.class)), 
                cb.nullLiteral(String.class)));


        Query q = em.createQuery(cquery);
    }

View Full Code Here

Examples of javax.persistence.criteria.CriteriaUpdate.where()


    public void updateMovie() {
        CriteriaBuilder builder = em.getCriteriaBuilder();
        CriteriaUpdate updateCriteria = builder.createCriteriaUpdate(Movie.class);
        Root<Movie> updateRoot = updateCriteria.from(Movie.class);
        updateCriteria.where(builder.equal(updateRoot.get(Movie_.name), "Inception"));
        updateCriteria.set(updateRoot.get(Movie_.name), "INCEPTION");
        Query q = em.createQuery(updateCriteria);
        q.executeUpdate();
        em.flush();
    }

View Full Code Here

Examples of javax.persistence.criteria.Subquery.where()


                            if (var instanceof String && ((String)var).contains("%")) {
                                /*
                                 * This is a like query
                                 */
                                subquery.where(builder.like(builder.lower(fromAttr.get(fields[1])), var.toString().toLowerCase()));   
                            }
                            else {
                                /*
                                 * This is strong equals query
                                 */

View Full Code Here

Examples of net.sf.domainbeans.operation.annotation.Db.query.where()

    return null;
  }


  private Object doQuery() {
    query qry = getMethod().getAnnotation(query.class);
    String whereClause = qry.where();
    String cleanWhereClause = whereClause.replaceAll(":this.", ":");
    String queryString  = "from "+getOriginalObject().getClass().getCanonicalName()+((whereClause.length()==0)?"":" where "+cleanWhereClause);
    Query query = getEntityManager().createQuery(queryString);
    if(whereClause.lastIndexOf(":this.")>0){
      String[] whereCondition = whereClause.split(" ");

View Full Code Here

Examples of nl.giantit.minecraft.database.query.DeleteQuery.where()

      // Send MySQL Query syntax to console for debugging purposes!
      this.db.getPlugin().getLogger().info(this.query);
    }
    
    DeleteQuery dQ = this.db.delete("sqlite_sequence");
    dQ.where("name", table.replace("#__", this.db.getPrefix()));
    dQ.parse().exec(debug);
    
    return this.db.updateQuery(this);
  }

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

    }
    cmd.select(DEP.NAME.as("DEPARTMENT"));
    cmd.select(DEP.BUSINESS_UNIT);
    cmd.join(EMP.DEPARTMENT_ID, DEP.DEPARTMENT_ID);
        // Set constraints and order
        cmd.where(EMP.LASTNAME.length().isGreaterThan(0));
        cmd.orderBy(EMP.LASTNAME, EMP.FIRSTNAME);


        /*
        // Example for limitRows() and skipRows()
        if (db.getDriver().isSupported(DBDriverFeature.QUERY_LIMIT_ROWS))

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

            boolean allNull = true;
            DBColumn[] idxColumns = idx.getColumns();
            for (int i=0; i<idxColumns.length; i++)
            {   // Check if column has changed
                Object value = record.getValue(idxColumns[i]);
                cmd.where(idxColumns[i].is(value));
                if (value!=null)
                    allNull = false;
            }
            // Check whether all constraints are null
            if (allNull)

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                {   // Multiple key columns
                    Object value = record.getValue(keyColumns[0]);
                    DBCompareExpr notExpr = keyColumns[0].is(value);
                    for (int i=1; i<keyColumns.length; i++)
                    {   // Check if column has changed
                        cmd.where(keyColumns[i].is(value));
                    }
                    cmd.where(notExpr.not());
                }
                else
                {   // Single key column

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                    DBCompareExpr notExpr = keyColumns[0].is(value);
                    for (int i=1; i<keyColumns.length; i++)
                    {   // Check if column has changed
                        cmd.where(keyColumns[i].is(value));
                    }
                    cmd.where(notExpr.not());
                }
                else
                {   // Single key column
                    Object value = record.getValue(keyColumns[0]);
                    cmd.where(keyColumns[0].isNot(value));

View Full Code Here

Examples of org.apache.empire.db.DBCommand.where()

                    cmd.where(notExpr.not());
                }
                else
                {   // Single key column
                    Object value = record.getValue(keyColumns[0]);
                    cmd.where(keyColumns[0].isNot(value));
                }
            }
            // Query now
            DBReader reader = new DBReader();
            try {

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.