Examples of OrderBy

com.avaje.ebean.OrderBy
Represents an Order By for a Query.
Is a ordered list of OrderBy.Property objects each specifying a property and whether it is ascending or descending order.

Typically you will not construct an OrderBy yourself but use one that exists on the Query object.
com.coherentlogic.fred.client.core.domain.OrderBy
com.datasalt.pangool.tuplemr.OrderBy
OrderBy is a convenience builder used by {@link TupleMRConfig} , similar to{@link Criteria}. The main difference is that {@link OrderBy} is mutableusing the concatenation pattern and allows to specify schemaOrder. The OrderBy instances are converted to immutable Criteria objects by {@link TupleMRConfig}.
com.google.api.ads.adwords.axis.v201306.cm.OrderBy
Specifies how the resulting information should be sorted.
com.google.api.ads.adwords.axis.v201309.cm.OrderBy
Specifies how the resulting information should be sorted.
com.google.api.ads.adwords.jaxws.v201309.cm.OrderBy
3.org/2001/XMLSchema}anyType"> <sequence> <element name="field" type="{http://www.w3.org/2001/XMLSchema}string" minOccurs="0"/> <element name="sortOrder" type="{https://adwords.google.com/api/adwords/cm/v201309}SortOrder" minOccurs="0"/> </sequence> </restriction> </complexContent> </complexType>
com.google.api.adwords.v201306.cm.OrderBy
Specifies how the resulting information should be sorted.
com.google.api.adwords.v201309.cm.OrderBy
Specifies how the resulting information should be sorted.
com.google.code.lightssh.common.model.page.OrderBy
排序域
com.googlecode.gql4j.GqlQuery.OrderBy
com.j256.ormlite.stmt.query.OrderBy
Internal class handling the SQL 'ORDER BY' operation. Used by {@link QueryBuilder#orderBy(String,boolean)} and{@link QueryBuilder#orderByRaw(String)}. @author graywatson
com.salesforce.phoenix.compile.OrderByCompiler.OrderBy
com.samskivert.depot.clause.OrderBy
com.vaadin.addon.sqlcontainer.query.OrderBy
OrderBy represents a sorting rule to be applied to a query made by the SQLContainer's QueryDelegate. The sorting rule is simple and contains only the affected column's name and the direction of the sort.
com.vaadin.data.util.sqlcontainer.query.OrderBy
OrderBy represents a sorting rule to be applied to a query made by the SQLContainer's QueryDelegate. The sorting rule is simple and contains only the affected column's name and the direction of the sort.
javax.persistence.OrderBy
org.apache.ode.ql.tree.nodes.OrderBy
org.apache.phoenix.compile.OrderByCompiler.OrderBy
org.apache.torque.sql.OrderBy
An order by clause. @version $Id: OrderBy.java 1448414 2013-02-20 21:06:35Z tfischer $
org.codehaus.jparsec.examples.sql.ast.OrderBy
The "order by" clause. @author Ben Yu
org.crank.crud.criteria.OrderBy
org.hibernate.annotations.OrderBy
org.jboss.dna.jcr.xpath.XPath.OrderBy
org.modeshape.jcr.query.xpath.XPath.OrderBy
org.qi4j.api.query.grammar.OrderBy
Query sorting segment.
org.teiid.language.OrderBy
Represents an ORDER BY clause in a command.
org.teiid.query.sql.lang.OrderBy
Represents the ORDER BY clause of a query. The ORDER BY clause states what order the rows of a result should be returned in. Each element in the ORDER BY represents a sort that is completed in the order listed. The optional keywords ASC and DESC can be put after each element to specify whether the sort is ascending or descending.
se.unlogic.standardutils.dao.annotations.OrderBy

Examples of org.teiid.query.sql.lang.OrderBy


    Criteria crit = new CompareCriteria(new ElementSymbol("b"), CompareCriteria.EQ, new ElementSymbol("aString")); //$NON-NLS-1$ //$NON-NLS-2$


    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy(elements);


    Query query = new Query(select, from, crit, orderBy, null);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c",  //$NON-NLS-1$
         query);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

  @Test public void testOrderByDesc(){
    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    ArrayList orderTypes = new ArrayList();
    orderTypes.add(Boolean.FALSE);
    OrderBy orderBy = new OrderBy(elements, orderTypes);
    
    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c desc",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC",  //$NON-NLS-1$
         query);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

  /** SELECT a FROM db.g WHERE b = aString order by c,d*/
  @Test public void testOrderBys(){
    ArrayList elements = new ArrayList();
    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    elements.add(new ElementSymbol("d")); //$NON-NLS-1$
    OrderBy orderBy = new OrderBy(elements);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c,d",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c, d",  //$NON-NLS-1$
         query);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    elements.add(new ElementSymbol("d")); //$NON-NLS-1$
    ArrayList orderTypes = new ArrayList();
    orderTypes.add(Boolean.FALSE);
    orderTypes.add(Boolean.FALSE);
    OrderBy orderBy = new OrderBy(elements, orderTypes);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c desc,d desc",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC, d DESC",  //$NON-NLS-1$
         query);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

    elements.add(new ElementSymbol("c")); //$NON-NLS-1$
    elements.add(new ElementSymbol("d")); //$NON-NLS-1$
    ArrayList orderTypes = new ArrayList();
    orderTypes.add(Boolean.FALSE);
    orderTypes.add(Boolean.TRUE);
    OrderBy orderBy = new OrderBy(elements, orderTypes);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c desc,d",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC, d",  //$NON-NLS-1$
         query);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

         "SELECT a FROM db.g WHERE b = aString ORDER BY c DESC, d",  //$NON-NLS-1$
         query);
  }  
  
  @Test public void testOrderByNullOrdering(){
    OrderBy orderBy = new OrderBy();
    OrderByItem item = new OrderByItem(new ElementSymbol("c"), true);
    item.setNullOrdering(NullOrdering.FIRST);
    orderBy.getOrderByItems().add(item);
    item = new OrderByItem(new ElementSymbol("d"), false);
    item.setNullOrdering(NullOrdering.LAST);
    orderBy.getOrderByItems().add(item);


    Query query = getOrderByQuery(orderBy);
    helpTest("SELECT a FROM db.g WHERE b = aString ORDER BY c NULLS FIRST,d desc nulls last",  //$NON-NLS-1$
         "SELECT a FROM db.g WHERE b = aString ORDER BY c NULLS FIRST, d DESC NULLS LAST",  //$NON-NLS-1$
         query);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

        Select select = new Select();
        ElementSymbol c1 = new ElementSymbol("c1", false); //$NON-NLS-1$
        select.addSymbol(c1);
        select.addSymbol(new ElementSymbol("c2", false));         //$NON-NLS-1$


        OrderBy orderBy = new OrderBy();
        orderBy.addVariable(c1);


        Query query = new Query();
        query.setSelect(select);
        query.setFrom(from);
        query.setOrderBy(orderBy);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

        
    Select select = new Select();
    select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$
    select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$


    OrderBy orderby = new OrderBy();
    orderby.addVariable(new ElementSymbol("1"), true); //$NON-NLS-1$


    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setOrderBy(orderby);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

        
    Select select = new Select();
    select.addSymbol(new ElementSymbol("x")); //$NON-NLS-1$
    select.addSymbol(new ElementSymbol("y")); //$NON-NLS-1$


    OrderBy orderby = new OrderBy();
    orderby.addVariable(new ExpressionSymbol("expr", new Constant(1)), true); //$NON-NLS-1$


    Query query = new Query();
    query.setSelect(select);
    query.setFrom(from);
    query.setOrderBy(orderby);

View Full Code Here

Examples of org.teiid.query.sql.lang.OrderBy

    }
    
    @Test public void testXmlAggWithOrderBy() throws Exception {
        String sql = "SELECT xmlAgg(1 order by e2)"; //$NON-NLS-1$
        AggregateSymbol as = new AggregateSymbol("foo", Reserved.XMLAGG, false, new Constant(1));
        as.setOrderBy(new OrderBy(Arrays.asList(new ElementSymbol("e2"))));
        Query query = new Query();
        query.setSelect(new Select(Arrays.asList(as)));
        helpTest(sql, "SELECT XMLAGG(1 ORDER BY e2)", query);
    }

View Full Code Here

0 1 2 3 4 5 6 7

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.