List of addOrderBy() Examples

Examples of addOrderBy()

com.cloud.utils.db.Filter.addOrderBy()
com.iisigroup.cap.dao.utils.ISearch.addOrderBy()
Specify that results must be ordered by the passed column Null by default. 預設為升羃排序 @param orderBy the order by @return T extends ISearch
com.mysema.query.DefaultQueryMetadata.addOrderBy()
com.mysema.query.QueryMetadata.addOrderBy()
Add the given order specifiers @param o
org.apache.ojb.broker.metadata.CollectionDescriptor.addOrderBy()
Adds a field for orderBy @param fieldName The field name to be used @param sortAscending true for ASCENDING, false for DESCENDING
org.apache.ojb.broker.query.QueryByCriteria.addOrderBy()
Adds a field for orderBy @param fieldName The field name to be used @param sortAscending true for ASCENDING, false for DESCENDING
org.apache.ojb.broker.query.ReportQueryByMtoNCriteria.addOrderBy()
org.boco.seamUtility.QueryBuilder.addOrderBy()
org.hibernate.sql.QuerySelect.addOrderBy()
org.jooq.SelectQuery.addOrderBy()
Adds ordering fields, ordering by the default sort order. @param fields The ordering fields

Examples of org.hibernate.sql.QuerySelect.addOrderBy()

    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)

View Full Code Here

Examples of org.hibernate.sql.QuerySelect.addOrderBy()

    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)

View Full Code Here

Examples of org.hibernate.sql.QuerySelect.addOrderBy()

    sql.setGroupByTokens( groupByTokens.iterator() );
    sql.setHavingTokens( havingTokens.iterator() );
    sql.setOrderByTokens( orderByTokens.iterator() );


    if ( collectionPersister != null && collectionPersister.hasOrdering() ) {
      sql.addOrderBy( collectionPersister.getSQLOrderByString( fetchName ) );
    }


    scalarColumnNames = NameGenerator.generateColumnNames( returnTypes, getFactory() );


    // initialize the Set of queried identifier spaces (ie. tables)

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()

    @Test
    public void testFetch() throws Exception {
        SelectQuery q = create().selectQuery();
        q.addFrom(TAuthor());
        q.addSelect(TAuthor().getFields());
        q.addOrderBy(TAuthor_LAST_NAME());


        Result<?> result = q.fetch();


        assertEquals(2, result.size());
        assertEquals("Coelho", result.get(0).getValue(TAuthor_LAST_NAME()));

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()

    @Test
    public void testSelectQuery() throws Exception {
        SelectQuery q = create().selectQuery();
        q.addFrom(TAuthor());
        q.addSelect(TAuthor().getFields());
        q.addOrderBy(TAuthor_LAST_NAME());


        int rows = q.execute();
        Result<?> result = q.getResult();


        assertEquals(2, rows);

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()

                .where(TBook_ID().in(1, 2, 3))
                .getQuery();


        query.addGroupBy(TBook_ID());
        query.addHaving(count().greaterOrEqual(1));
        query.addOrderBy(TBook_ID());
        query.execute();


        Result<Record> result = query.getResult();


        assertEquals(3, result.size());

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()


        SelectQuery q2 = create().selectQuery();
        q2.addFrom(a);
        q2.addJoin(b, b_authorID.equal(a_authorID));
        q2.addConditions(b_title.notEqual("1984"));
        q2.addOrderBy(lower(b_title));


        int rows1 = q1.execute();
        int rows2 = q2.execute();


        assertEquals(3, rows1);

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()

        Field<Integer> position = position(VLibrary_AUTHOR(), "o").as("p");
        q.addSelect(VLibrary_AUTHOR());
        q.addSelect(position);


        // https://issues.apache.org/jira/browse/DERBY-5005
        q.addOrderBy(field(VLibrary_AUTHOR().getName()));


        q.execute();
        Record r1 = q.getResult().get(1); // George Orwell
        Record r2 = q.getResult().get(2); // Paulo Coelho

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()

            .otherwise("C");


        SelectQuery query = create().selectQuery();
        query.addSelect(case1, case2, case3);
        query.addFrom(TBook());
        query.addOrderBy(TBook_PUBLISHED_IN());
        query.execute();


        Result<Record> result = query.getResult();
        assertEquals(null, result.getValue(0, case1));
        assertEquals(null, result.getValue(1, case1));

View Full Code Here

Examples of org.jooq.SelectQuery.addOrderBy()

            .otherwise("don't know").as("case3");


        query = create().selectQuery();
        query.addSelect(case4);
        query.addFrom(TBook());
        query.addOrderBy(TBook_PUBLISHED_IN());
        query.execute();


        result = query.getResult();


        // Note: trims are necessary, as certain databases use

View Full Code Here

0 1 2 3 4 5

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.