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.eclipse.persistence.jpa.jpql.parser.OrderByItem

                                   CollectionExpression collectionExpression,
                                   int index,
                                   boolean hasComma,
                                   boolean virtualSpace) {


      OrderByItem item = (OrderByItem) collectionExpression.getChild(index);


      if (item.getOrdering() == Ordering.DEFAULT) {
        AbstractContentAssistVisitor.this.addIdentifier(ASC);
        AbstractContentAssistVisitor.this.addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem

                                   CollectionExpression collectionExpression,
                                   int index,
                                   boolean hasComma,
                                   boolean virtualSpace) {


      OrderByItem item = (OrderByItem) collectionExpression.getChild(index);


      if (item.getOrdering() == Ordering.DEFAULT) {
        AbstractContentAssistVisitor.this.addIdentifier(ASC);
        AbstractContentAssistVisitor.this.addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem

                                   CollectionExpression collectionExpression,
                                   int index,
                                   boolean hasComma,
                                   boolean virtualSpace) {


      OrderByItem item = (OrderByItem) collectionExpression.getChild(index);


      if (item.getOrdering() == Ordering.DEFAULT) {
        AbstractContentAssistVisitor.this.addIdentifier(ASC);
        AbstractContentAssistVisitor.this.addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem

    /**
     * {@inheritDoc}
     */
    public void addAtTheEndOfChild(AbstractOrderByClause expression, Expression child, int index) {


      OrderByItem item = (OrderByItem) child;


      if (item.getOrdering() == Ordering.DEFAULT) {
        addIdentifier(ASC);
        addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem

    /**
     * {@inheritDoc}
     */
    public void addAtTheEndOfChild(OrderByClause expression, Expression child, int index) {


      OrderByItem item = (OrderByItem) child;


      if (item.getOrdering() == Ordering.DEFAULT) {
        addIdentifier(ASC);
        addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      OrderByItem expression = stateObject.getExpression();


      // Order by item
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ASC/DESC
      if (!stateObject.isDefault()) {


        if (shouldOutput(expression) || expression.hasSpaceAfterExpression()) {
          writer.append(SPACE);
        }


        String ordering = stateObject.getOrdering().name();
        String actualOrdering = (expression != null) ? expression.getActualOrdering() : null;


        if (!ordering.equalsIgnoreCase(actualOrdering)) {
          actualOrdering = ordering;
        }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem

                                   CollectionExpression collectionExpression,
                                   int index,
                                   boolean hasComma,
                                   boolean virtualSpace) {


      OrderByItem item = (OrderByItem) collectionExpression.getChild(index);


      if (item.getOrdering() == Ordering.DEFAULT) {
          visitor.addIdentifier(ASC);
          visitor.addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      OrderByItem expression = stateObject.getExpression();


      // Order by item
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ASC/DESC
      if (!stateObject.isDefault()) {


        if (shouldOutput(expression) || expression.hasSpaceAfterExpression()) {
          writer.append(SPACE);
        }


        String ordering = stateObject.getOrdering().name();
        String actualOrdering = (expression != null) ? expression.getActualOrdering() : null;


        if (!ordering.equalsIgnoreCase(actualOrdering)) {
          actualOrdering = ordering;
        }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem

    /**
     * {@inheritDoc}
     */
    public void addAtTheEndOfChild(OrderByClause expression, Expression child, int index) {


      OrderByItem item = (OrderByItem) child;


      if (item.getOrdering() == Ordering.DEFAULT) {
        addIdentifier(ASC);
        addIdentifier(DESC);
      }
    }

View Full Code Here

Examples of org.eclipse.persistence.jpa.jpql.parser.OrderByItem


    if (stateObject.isDecorated()) {
      toText(stateObject);
    }
    else {
      OrderByItem expression = stateObject.getExpression();


      // Order by item
      if (stateObject.hasStateObject()) {
        stateObject.getStateObject().accept(this);
      }


      // ASC/DESC
      if (!stateObject.isDefault()) {


        if (shouldOutput(expression) || expression.hasSpaceAfterExpression()) {
          writer.append(SPACE);
        }


        String ordering = stateObject.getOrdering().name();
        String actualOrdering = (expression != null) ? expression.getActualOrdering() : null;


        if (!ordering.equalsIgnoreCase(actualOrdering)) {
          actualOrdering = ordering;
        }

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.