Examples of OrderByItem

com.googlecode.gql4j.GqlQuery.OrderByItem
org.apache.metamodel.query.OrderByItem
Represents an ORDER BY item. An OrderByItem sorts the resulting DataSet according to a SelectItem that may or may not be a part of the query already. @see OrderByClause @see SelectItem
org.eclipse.persistence.jpa.jpql.parser.OrderByItem
An orderby_item must be one of the following:
1. A {@link StateFieldPathExpression state_field_path_expression} that evaluates to an orderablestate field of an entity or embeddable class abstract schema type designated in the SELECT clause by one of the following:
  - A general_identification_variable
  - A single_valued_object_path_expression
2. A {@link StateFieldPathExpression state_field_path_expression} that evaluates to the samestate field of the same entity or embeddable abstract schema type as a {@link StateFieldPathExpression state_field_path_expression} in the SELECT clause
3. A {@link ResultVariable result_variable} that refers to an orderable item in the SELECTclause for which the same {@link ResultVariable result_variable} has been specified. This may bethe result of an aggregate_expression, a scalar_expression, or a {@link StateFieldPathExpression state_field_path_expression} in the SELECT clause.
The keyword ASC specifies that ascending ordering be used for the associated orderby_item; the keyword DESC specifies that descending ordering be used. Ascending ordering is the default.
The keyword NULLS FIRST specifies that nulls first ordering be used for the associated orderby_item; the keyword NULLS LAST specifies that nulls last ordering be used. Ascending ordering is the default.
JPA 1.0:
BNF: orderby_item ::= state_field_path_expression [ ASC | DESC ]
JPA 2.0
BNF: orderby_item ::= state_field_path_expression | result_variable [ ASC | DESC ]
EclipseLink 2.4:
BNF: orderby_item ::= state_field_path_expression | result_variable [ ASC | DESC ] [ NULLS FIRST | NULLS LAST ]
@version 2.4.2 @since 2.3 @author Pascal Filion
org.ofbiz.sql.OrderByItem
org.teiid.query.sql.lang.OrderByItem

Examples of org.ofbiz.sql.OrderByItem

                    )
                ),
                new BooleanCondition(new FieldValue("b", "firstName"), "LIKE", new StringValue("%foo%")),
                null,
                list(
                    new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, new FunctionCall("LOWER", GenericTestCaseBase.<Value>list(new FieldValue(null, "lastName")))),
                    new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, new FieldValue(null, "firstName")),
                    new OrderByItem(OrderByItem.Order.DESCENDING, OrderByItem.Nulls.DEFAULT, new FieldValue(null, "birthDate"))
                ),
                5,
                10
            );
            SQLStatement<?> stmt = stmtIt.next();

View Full Code Here

Examples of org.ofbiz.sql.OrderByItem

        assertEquals(label + ":parse", v, parser(v).parse_OrderByItem());
        basicTest(label, OrderByItem.class, v, o, matches);
    }


    public void testOrderByItem() throws Exception {
        OrderByItem v1 = new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, fv1);
        orderByItemTest("v1", v1, OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, fv1, null, false);
        OrderByItem v2 = new OrderByItem(OrderByItem.Order.ASCENDING, OrderByItem.Nulls.FIRST, fv1);
        orderByItemTest("v3", v2, OrderByItem.Order.ASCENDING, OrderByItem.Nulls.FIRST, fv1, v1, false);
        OrderByItem v3 = new OrderByItem(OrderByItem.Order.DESCENDING, OrderByItem.Nulls.LAST, fv1);
        orderByItemTest("v2", v3, OrderByItem.Order.DESCENDING, OrderByItem.Nulls.LAST, fv1, v1, false);
        OrderByItem v4 = new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, fc1);
        orderByItemTest("v4", v4, OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, fc1, v1, false);
        OrderByItem v5 = new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, fv4);
        orderByItemTest("v5", v5, OrderByItem.Order.DEFAULT, OrderByItem.Nulls.DEFAULT, fv4, v1, false);
        OrderByItem v6 = new OrderByItem(OrderByItem.Order.DEFAULT, OrderByItem.Nulls.LAST, fv4);
        orderByItemTest("v6", v6, OrderByItem.Order.DEFAULT, OrderByItem.Nulls.LAST, fv4, v1, false);
    }

View Full Code Here

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

         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$

View Full Code Here

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

    }
    
    public void visit(OrderBy obj) {
      //add/correct aliases if necessary
        for (int i = 0; i < obj.getVariableCount(); i++) {
            OrderByItem item = obj.getOrderByItems().get(i);
            SingleElementSymbol element = item.getSymbol();
            if (item.isUnrelated()) {
              visitNode(element);
              continue;
            }
            String name = visitor.namingContext.getElementName(element, false);
            boolean needsAlias = visitor.namingContext.aliasColumns;
            if (name != null) {
              
              Expression expr = SymbolMap.getExpression(element);
                          
              if (!(expr instanceof SingleElementSymbol)) {
                  expr = new ExpressionSymbol(element.getShortName(), expr);
              } else if (expr instanceof ElementSymbol) {
                needsAlias &= needsAlias(name, (ElementSymbol)expr);
              } 
                          
              if (needsAlias) {
                  element = new AliasSymbol(element.getShortName(), (SingleElementSymbol)expr);
              } else if (expr instanceof ElementSymbol) {
                element = (ElementSymbol)expr;
                visitNode(element);
              }
              item.setSymbol(element);
              element.setOutputName(name);
            }
        }
    }

View Full Code Here

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

                    List<ElementSymbol> schema = new ArrayList<ElementSymbol>(orderIndecies.length + 1);
                    ElementSymbol element = new ElementSymbol("val"); //$NON-NLS-1$
                        element.setType(inputType);
                        schema.add(element);
                    for (ListIterator<OrderByItem> iterator = aggSymbol.getOrderBy().getOrderByItems().listIterator(); iterator.hasNext();) {
                      OrderByItem item = iterator.next();
                      orderIndecies[iterator.previousIndex()] = collectExpression(item.getSymbol());
                      element = new ElementSymbol(String.valueOf(iterator.previousIndex()));
                            element.setType(inputType);
                      schema.add(element);
                      OrderByItem newItem = item.clone();
                      newItem.setSymbol(element);
                      orderByItems.add(newItem);
            }
                    SortingFilter filter = new SortingFilter(functions[i], getBufferManager(), getConnectionID(), false);
                    filter.setIndecies(orderIndecies);
                    filter.setElements(schema);

View Full Code Here

0 1 2 3

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.