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.empire.db.DBCommand.where()

        // Database definition
        OracleSYSDatabase sysDB = new OracleSYSDatabase(this);
        // Check Columns
        DBCommand sysDBCommand = sysDB.createCommand();
        sysDBCommand.select(sysDB.CI.getColumns());
        sysDBCommand.where (sysDB.CI.C_OWNER.is(owner));
        
        OracleDataDictionnary dataDictionnary = new OracleDataDictionnary();
        DBReader rd = new DBReader();
        try
        {

View Full Code Here

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

        cmd.select(EMP.GENDER, EMP.PHONE_NUMBER, PHONE_EXT_NUMBER);
        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()

            for (Object[] item : items)
            {
                keys[i++] = StringUtils.arrayToString(item, "");
            }
            if (isInvertSelection())
                cmd.where(keyExpr.notIn(keys));
            else
                cmd.where(keyExpr.in(keys));
        }
        // clear previous settings without the where causes
        cmd.clearSelect();

View Full Code Here

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

                keys[i++] = StringUtils.arrayToString(item, "");
            }
            if (isInvertSelection())
                cmd.where(keyExpr.notIn(keys));
            else
                cmd.where(keyExpr.in(keys));
        }
        // clear previous settings without the where causes
        cmd.clearSelect();
        cmd.clearGroupBy();
        return cmd;

View Full Code Here

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

        cmd.join  (DEP.C_DEPARTMENT_ID, EMP.C_DEPARTMENT_ID);


        // Set filter constraints
        SearchInfo si = getSearchInfo();
        if (si.getDepartmentId()!=null)
            cmd.where(EMP.C_DEPARTMENT_ID.is(si.getDepartmentId()));
        if (StringUtils.isNotEmpty( si.getFirstName()) )
            cmd.where(EMP.C_FIRSTNAME.likeUpper( si.getFirstName()+"%" )
                  .or(EMP.C_FIRSTNAME.is(null)));
        if (StringUtils.isNotEmpty( si.getLastName()) )
            cmd.where(EMP.C_LASTNAME.likeUpper( si.getLastName()+"%" ));

View Full Code Here

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

        // Set filter constraints
        SearchInfo si = getSearchInfo();
        if (si.getDepartmentId()!=null)
            cmd.where(EMP.C_DEPARTMENT_ID.is(si.getDepartmentId()));
        if (StringUtils.isNotEmpty( si.getFirstName()) )
            cmd.where(EMP.C_FIRSTNAME.likeUpper( si.getFirstName()+"%" )
                  .or(EMP.C_FIRSTNAME.is(null)));
        if (StringUtils.isNotEmpty( si.getLastName()) )
            cmd.where(EMP.C_LASTNAME.likeUpper( si.getLastName()+"%" ));
        
        cmd.orderBy(EMP.C_LASTNAME);

View Full Code Here

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

            cmd.where(EMP.C_DEPARTMENT_ID.is(si.getDepartmentId()));
        if (StringUtils.isNotEmpty( si.getFirstName()) )
            cmd.where(EMP.C_FIRSTNAME.likeUpper( si.getFirstName()+"%" )
                  .or(EMP.C_FIRSTNAME.is(null)));
        if (StringUtils.isNotEmpty( si.getLastName()) )
            cmd.where(EMP.C_LASTNAME.likeUpper( si.getLastName()+"%" ));
        
        cmd.orderBy(EMP.C_LASTNAME);
        cmd.orderBy(EMP.C_FIRSTNAME);
        
        // Init BeanList

View Full Code Here

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

        DBCmdParam curDepParam = cmd.addParam(); // Current Department
        DBCmdParam genderParam = cmd.addParam(); // Gender ('M' or 'F')
        // Define the query
        cmd.select(T_EMP.C_FULLNAME);
        cmd.join  (T_EMP.C_EMPLOYEE_ID, db.V_EMPLOYEE_INFO.C_EMPLOYEE_ID);
        cmd.where (T_EMP.C_GENDER.is(genderParam));
        cmd.where (db.V_EMPLOYEE_INFO.C_CURRENT_DEP_ID.is(curDepParam));


        System.out.println("Perfoming two queries using a the same command with different parameter values.");
        
        DBReader r = new DBReader();

View Full Code Here

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

        DBCmdParam genderParam = cmd.addParam(); // Gender ('M' or 'F')
        // Define the query
        cmd.select(T_EMP.C_FULLNAME);
        cmd.join  (T_EMP.C_EMPLOYEE_ID, db.V_EMPLOYEE_INFO.C_EMPLOYEE_ID);
        cmd.where (T_EMP.C_GENDER.is(genderParam));
        cmd.where (db.V_EMPLOYEE_INFO.C_CURRENT_DEP_ID.is(curDepParam));


        System.out.println("Perfoming two queries using a the same command with different parameter values.");
        
        DBReader r = new DBReader();
        try {

View Full Code Here

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

        // Define shortcuts for tables used - not necessary but convenient
        SampleAdvDB.Employees EMP = T_EMP;
        // Select required columns
        cmd.select(T_EMP.getColumns());
        // Set Constraints
        cmd.where(T_EMP.C_RETIRED.is(false));


        // Query Records and print output
        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.