com.atlassian.jira.entity
Class Select.WhereContext<E>

java.lang.Object
  com.atlassian.jira.entity.Select.ExecutableContext<E>
      com.atlassian.jira.entity.Select.WhereClauseAwareContext<E>
          com.atlassian.jira.entity.Select.WhereContext<E>

Type Parameters:

E - the type of value that the query yields, which is either implied by the factory method used or inferred from the NamedEntityBuilder that was supplied to it

All Implemented Interfaces:

SelectQuery<E>

Enclosing class:

Select

public static class Select.WhereContext<E>
extends Select.WhereClauseAwareContext<E>

A partially constructed query that may accept .where and .orderBy clauses.

As a readability aid, most .whereX clauses my also be specified with a {.andX} clause after the first one has been specified.

Nested Class Summary

Nested classes/interfaces inherited from interface com.atlassian.jira.entity.SelectQuery

SelectQuery.ExecutionContext<E>

Field Summary

Fields inherited from class com.atlassian.jira.entity.Select.ExecutableContext

queryBuilder

Method Summary

Select.WhereContext<E>	andCondition(org.ofbiz.core.entity.EntityCondition condition)
Select.WhereContext<E>	andEqual(String field, Long value)
Select.WhereContext<E>	andEqual(String field, String value)
Select.WhereContext<E>	andLike(String field, String pattern)
Select.OrderByContext<E>	orderBy(String... orderByColumns) Specifies the ordering for the return values.
Select.WhereContext<E>	where(String fieldName, org.ofbiz.core.entity.EntityOperator operator, Long value)
Select.WhereContext<E>	whereCondition(org.ofbiz.core.entity.EntityCondition condition)
Select.WhereContext<E>	whereEqual(String fieldName, Long value)
Select.WhereContext<E>	whereEqual(String fieldName, String value)

Methods inherited from class com.atlassian.jira.entity.Select.WhereClauseAwareContext

byId, whereLike, whereNull

Methods inherited from class com.atlassian.jira.entity.Select.ExecutableContext

runWith, runWith

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Method Detail

whereEqual

public Select.WhereContext<E> whereEqual(String fieldName,
                                         String value)

Specified by:

whereEqual in class Select.WhereClauseAwareContext<E>

whereEqual

public Select.WhereContext<E> whereEqual(String fieldName,
                                         Long value)

Specified by:

whereEqual in class Select.WhereClauseAwareContext<E>

where

public Select.WhereContext<E> where(String fieldName,
                                    org.ofbiz.core.entity.EntityOperator operator,
                                    Long value)

Specified by:

where in class Select.WhereClauseAwareContext<E>

whereCondition

public Select.WhereContext<E> whereCondition(org.ofbiz.core.entity.EntityCondition condition)

Specified by:

whereCondition in class Select.WhereClauseAwareContext<E>

andEqual

public Select.WhereContext<E> andEqual(String field,
                                       String value)

andEqual

public Select.WhereContext<E> andEqual(String field,
                                       Long value)

andLike

public Select.WhereContext<E> andLike(String field,
                                      String pattern)

andCondition

public Select.WhereContext<E> andCondition(org.ofbiz.core.entity.EntityCondition condition)

orderBy

public Select.OrderByContext<E> orderBy(String... orderByColumns)

Specifies the ordering for the return values. This is required if you wish to specify a LIMIT for the query, as some databases cannot enumerate the returned rows except in the context of a well defined ordering (and which rows get returned would not be reliable without it, anyway).

Specified by:

orderBy in class Select.WhereClauseAwareContext<E>

Parameters:

orderByColumns - one or more columns by which to order the results

Returns:

a partially constructed query. Use .limit to continue building the query or .runWith to complete it by specifying an execution method.