org.opencrx.kernel.product1.cci2
Interface AbstractPriceLevelQuery

All Superinterfaces:

AbstractFilterAccountQuery, AbstractFilterProductQuery, AbstractFilterQuery, AlertSenderQuery, AnyTypePredicate, AuditeeQuery, BasicObjectQuery, CloneableQuery, ContextCapableQuery, CreatableQuery, CrxObjectQuery, ExporterQuery, ExtentCapableQuery, ImporterQuery, IndexedQuery, ModifiableQuery, SecureObjectQuery

All Known Subinterfaces:

PriceLevelQuery, ProductPhasePriceLevelQuery

public interface AbstractPriceLevelQuery
extends AbstractFilterAccountQuery, CrxObjectQuery, AbstractFilterProductQuery

Method Summary

MultivaluedFeaturePredicate	assignedAccount() Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature assignedAccount has values or not.
OptionalFeaturePredicate	basedOn() Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature basedOn is null or not.
OptionalFeaturePredicate	description() Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature description is null or not.
AccountAssignmentQuery	forAllAssignedAccount() Adds a condition for the feature assignedAccount to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature assignedAccount satisfies the given condition.
AbstractPriceLevelQuery	forAllBasedOn() Adds a condition for the feature basedOn to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature basedOn satisfies the given condition.
StringTypePredicate	forAllDescription() Adds a condition for the feature description to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature description satisfies the given condition.
BooleanTypePredicate	forAllIsFinal() Adds a condition for the feature isFinal to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature isFinal satisfies the given condition.
ComparableTypePredicate<Short>	forAllPaymentMethod() Adds a condition for the feature paymentMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature paymentMethod satisfy the given condition.
PriceListEntryQuery	forAllPriceListEntry() Adds a condition for the feature priceListEntry to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceListEntry satisfies the given condition.
PriceModifierQuery	forAllPriceModifier() Adds a condition for the feature priceModifier to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceModifier satisfies the given condition.
ComparableTypePredicate<Short>	forAllPriceUsage() Adds a condition for the feature priceUsage to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature priceUsage satisfy the given condition.
ComparableTypePredicate<Short>	forAllShippingMethod() Adds a condition for the feature shippingMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature shippingMethod satisfy the given condition.
ComparableTypePredicate<Date>	forAllValidFrom() Adds a condition for the feature validFrom to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validFrom satisfies the given condition.
ComparableTypePredicate<Date>	forAllValidTo() Adds a condition for the feature validTo to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validTo satisfies the given condition.
OptionalFeaturePredicate	isFinal() Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature isFinal is null or not.
StringTypePredicate	name()
SimpleTypeOrder	orderByDescription() Allows to adds a sort instruction for AbstractPriceLevel depending the feature description Note: The order in which orderBy… instructions are given is relevant!
SimpleTypeOrder	orderByIsFinal() Allows to adds a sort instruction for AbstractPriceLevel depending the feature isFinal Note: The order in which orderBy… instructions are given is relevant!
SimpleTypeOrder	orderByName() Allows to adds a sort instruction for AbstractPriceLevel depending the feature name Note: The order in which orderBy… instructions are given is relevant!
MultivaluedTypeOrder	orderByPaymentMethod() Allows to adds a sort instruction for AbstractPriceLevel depending the feature paymentMethod Note: The order in which orderBy… instructions are given is relevant!
SimpleTypeOrder	orderByPriceCurrency() Allows to adds a sort instruction for AbstractPriceLevel depending the feature priceCurrency Note: The order in which orderBy… instructions are given is relevant!
MultivaluedTypeOrder	orderByPriceUsage() Allows to adds a sort instruction for AbstractPriceLevel depending the feature priceUsage Note: The order in which orderBy… instructions are given is relevant!
MultivaluedTypeOrder	orderByShippingMethod() Allows to adds a sort instruction for AbstractPriceLevel depending the feature shippingMethod Note: The order in which orderBy… instructions are given is relevant!
SimpleTypeOrder	orderByValidFrom() Allows to adds a sort instruction for AbstractPriceLevel depending the feature validFrom Note: The order in which orderBy… instructions are given is relevant!
SimpleTypeOrder	orderByValidTo() Allows to adds a sort instruction for AbstractPriceLevel depending the feature validTo Note: The order in which orderBy… instructions are given is relevant!
MultivaluedFeaturePredicate	paymentMethod() Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature paymentMethod has values or not.
ComparableTypePredicate<Short>	priceCurrency()
MultivaluedFeaturePredicate	priceListEntry() Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature priceListEntry has values or not.
MultivaluedFeaturePredicate	priceModifier() Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature priceModifier has values or not.
MultivaluedFeaturePredicate	priceUsage() Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature priceUsage has values or not.
MultivaluedFeaturePredicate	shippingMethod() Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature shippingMethod has values or not.
AccountAssignmentQuery	thereExistsAssignedAccount() Adds a condition for the feature assignedAccount to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature assignedAccount satisfies the given condition.
AbstractPriceLevelQuery	thereExistsBasedOn() Adds a condition for the feature basedOn to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature basedOn satisfies the given condition.
StringTypePredicate	thereExistsDescription() Adds a condition for the feature description to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature description satisfies the given condition.
BooleanTypePredicate	thereExistsIsFinal() Adds a condition for the feature isFinal to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature isFinal satisfies the given condition.
ComparableTypePredicate<Short>	thereExistsPaymentMethod() Adds a condition for the feature paymentMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature paymentMethod satisfy the given condition.
PriceListEntryQuery	thereExistsPriceListEntry() Adds a condition for the feature priceListEntry to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceListEntry satisfies the given condition.
PriceModifierQuery	thereExistsPriceModifier() Adds a condition for the feature priceModifier to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceModifier satisfies the given condition.
ComparableTypePredicate<Short>	thereExistsPriceUsage() Adds a condition for the feature priceUsage to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature priceUsage satisfy the given condition.
ComparableTypePredicate<Short>	thereExistsShippingMethod() Adds a condition for the feature shippingMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature shippingMethod satisfy the given condition.
ComparableTypePredicate<Date>	thereExistsValidFrom() Adds a condition for the feature validFrom to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validFrom satisfies the given condition.
ComparableTypePredicate<Date>	thereExistsValidTo() Adds a condition for the feature validTo to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validTo satisfies the given condition.
OptionalFeaturePredicate	validFrom() Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature validFrom is null or not.
OptionalFeaturePredicate	validTo() Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature validTo is null or not.

Methods inherited from interface org.opencrx.kernel.account1.cci2.AbstractFilterAccountQuery

accountFilterProperty, filteredAccount, forAllAccountFilterProperty, forAllFilteredAccount, thereExistsAccountFilterProperty, thereExistsFilteredAccount

Methods inherited from interface org.opencrx.kernel.generic.cci2.CrxObjectQuery

additionalExternalLink, attachedDocument, category, disabled, disabledReason, documentFolderAssignment, externalLink, forAllAdditionalExternalLink, forAllAttachedDocument, forAllCategory, forAllDisabled, forAllDisabledReason, forAllDocumentFolderAssignment, forAllExternalLink, forAllMedia, forAllNote, forAllPropertySet, forAllPropertySetEntry, forAllRating, forAllUserBoolean0, forAllUserBoolean1, forAllUserBoolean2, forAllUserBoolean3, forAllUserBoolean4, forAllUserCode0, forAllUserCode1, forAllUserCode2, forAllUserCode3, forAllUserCode4, forAllUserDate0, forAllUserDate1, forAllUserDate2, forAllUserDate3, forAllUserDate4, forAllUserDateTime0, forAllUserDateTime1, forAllUserDateTime2, forAllUserDateTime3, forAllUserDateTime4, forAllUserNumber0, forAllUserNumber1, forAllUserNumber2, forAllUserNumber3, forAllUserNumber4, forAllUserString0, forAllUserString1, forAllUserString2, forAllUserString3, forAllUserString4, media, note, orderByCategory, orderByDisabled, orderByDisabledReason, orderByExternalLink, orderByUserBoolean0, orderByUserBoolean1, orderByUserBoolean2, orderByUserBoolean3, orderByUserBoolean4, orderByUserCode0, orderByUserCode1, orderByUserCode2, orderByUserCode3, orderByUserCode4, orderByUserDate0, orderByUserDate1, orderByUserDate2, orderByUserDate3, orderByUserDate4, orderByUserDateTime0, orderByUserDateTime1, orderByUserDateTime2, orderByUserDateTime3, orderByUserDateTime4, orderByUserNumber0, orderByUserNumber1, orderByUserNumber2, orderByUserNumber3, orderByUserNumber4, orderByUserString0, orderByUserString1, orderByUserString2, orderByUserString3, orderByUserString4, propertySet, propertySetEntry, rating, thereExistsAdditionalExternalLink, thereExistsAttachedDocument, thereExistsCategory, thereExistsDisabled, thereExistsDisabledReason, thereExistsDocumentFolderAssignment, thereExistsExternalLink, thereExistsMedia, thereExistsNote, thereExistsPropertySet, thereExistsPropertySetEntry, thereExistsRating, thereExistsUserBoolean0, thereExistsUserBoolean1, thereExistsUserBoolean2, thereExistsUserBoolean3, thereExistsUserBoolean4, thereExistsUserCode0, thereExistsUserCode1, thereExistsUserCode2, thereExistsUserCode3, thereExistsUserCode4, thereExistsUserDate0, thereExistsUserDate1, thereExistsUserDate2, thereExistsUserDate3, thereExistsUserDate4, thereExistsUserDateTime0, thereExistsUserDateTime1, thereExistsUserDateTime2, thereExistsUserDateTime3, thereExistsUserDateTime4, thereExistsUserNumber0, thereExistsUserNumber1, thereExistsUserNumber2, thereExistsUserNumber3, thereExistsUserNumber4, thereExistsUserString0, thereExistsUserString1, thereExistsUserString2, thereExistsUserString3, thereExistsUserString4, userBoolean0, userBoolean1, userBoolean2, userBoolean3, userBoolean4, userCode0, userCode1, userCode2, userCode3, userCode4, userDate0, userDate1, userDate2, userDate3, userDate4, userDateTime0, userDateTime1, userDateTime2, userDateTime3, userDateTime4, userNumber0, userNumber1, userNumber2, userNumber3, userNumber4, userString0, userString1, userString2, userString3, userString4

Methods inherited from interface org.opencrx.kernel.base.cci2.AuditeeQuery

audit, forAllAudit, thereExistsAudit

Methods inherited from interface org.opencrx.kernel.base.cci2.IndexedQuery

forAllIndexEntry, indexEntry, thereExistsIndexEntry

Methods inherited from interface org.opencrx.kernel.base.cci2.SecureObjectQuery

accessGrantedByParent, accessLevelBrowse, accessLevelDelete, accessLevelUpdate, forAllAccessGrantedByParent, forAllOwner, forAllOwningGroup, forAllOwningUser, orderByAccessLevelBrowse, orderByAccessLevelDelete, orderByAccessLevelUpdate, orderByOwner, owner, owningGroup, owningUser, thereExistsAccessGrantedByParent, thereExistsOwner, thereExistsOwningGroup, thereExistsOwningUser

Methods inherited from interface org.openmdx.base.cci2.ContextCapableQuery

context, forAllContext, thereExistsContext

Methods inherited from interface org.openmdx.base.cci2.CreatableQuery

createdAt, createdBy, forAllCreatedBy, orderByCreatedAt, orderByCreatedBy, thereExistsCreatedBy

Methods inherited from interface org.openmdx.base.cci2.ExtentCapableQuery

identity, orderByIdentity

Methods inherited from interface org.openmdx.base.cci2.ModifiableQuery

forAllModifiedBy, modifiedAt, modifiedBy, orderByModifiedAt, orderByModifiedBy, thereExistsModifiedBy

Methods inherited from interface org.w3c.cci2.AnyTypePredicate

elementOf, elementOf, equals, equalTo, notAnElementOf, notAnElementOf, notEqualTo

Methods inherited from interface org.opencrx.kernel.product1.cci2.AbstractFilterProductQuery

filteredProduct, forAllFilteredProduct, forAllProductFilterProperty, productFilterProperty, thereExistsFilteredProduct, thereExistsProductFilterProperty

Method Detail

assignedAccount

MultivaluedFeaturePredicate assignedAccount()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature assignedAccount has values or not.

thereExistsAssignedAccount

AccountAssignmentQuery thereExistsAssignedAccount()

Adds a condition for the feature assignedAccount to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature assignedAccount satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllAssignedAccount

AccountAssignmentQuery forAllAssignedAccount()

Adds a condition for the feature assignedAccount to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature assignedAccount satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

basedOn

OptionalFeaturePredicate basedOn()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature basedOn is null or not.

thereExistsBasedOn

AbstractPriceLevelQuery thereExistsBasedOn()

Adds a condition for the feature basedOn to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature basedOn satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllBasedOn

AbstractPriceLevelQuery forAllBasedOn()

Adds a condition for the feature basedOn to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature basedOn satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

description

OptionalFeaturePredicate description()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature description is null or not.

thereExistsDescription

StringTypePredicate thereExistsDescription()

Adds a condition for the feature description to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature description satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllDescription

StringTypePredicate forAllDescription()

Adds a condition for the feature description to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature description satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

orderByDescription

SimpleTypeOrder orderByDescription()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature description Note: The order in which orderBy… instructions are given is relevant!

isFinal

OptionalFeaturePredicate isFinal()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature isFinal is null or not.

thereExistsIsFinal

BooleanTypePredicate thereExistsIsFinal()

Adds a condition for the feature isFinal to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature isFinal satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllIsFinal

BooleanTypePredicate forAllIsFinal()

Adds a condition for the feature isFinal to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature isFinal satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

orderByIsFinal

SimpleTypeOrder orderByIsFinal()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature isFinal Note: The order in which orderBy… instructions are given is relevant!

name

StringTypePredicate name()

orderByName

SimpleTypeOrder orderByName()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature name Note: The order in which orderBy… instructions are given is relevant!

paymentMethod

MultivaluedFeaturePredicate paymentMethod()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature paymentMethod has values or not.

thereExistsPaymentMethod

ComparableTypePredicate<Short> thereExistsPaymentMethod()

Adds a condition for the feature paymentMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature paymentMethod satisfy the given condition.

Since the multiplicity for this attribute is 0..n, the attribute may have no values. in which case the condition is not satisfied

forAllPaymentMethod

ComparableTypePredicate<Short> forAllPaymentMethod()

Adds a condition for the feature paymentMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature paymentMethod satisfy the given condition.

Since the multiplicity for this attribute is 0..n, the attribute may have no values. in which case the condition is satisfied

orderByPaymentMethod

MultivaluedTypeOrder orderByPaymentMethod()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature paymentMethod Note: The order in which orderBy… instructions are given is relevant!

priceCurrency

ComparableTypePredicate<Short> priceCurrency()

orderByPriceCurrency

SimpleTypeOrder orderByPriceCurrency()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature priceCurrency Note: The order in which orderBy… instructions are given is relevant!

priceListEntry

MultivaluedFeaturePredicate priceListEntry()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature priceListEntry has values or not.

thereExistsPriceListEntry

PriceListEntryQuery thereExistsPriceListEntry()

Adds a condition for the feature priceListEntry to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceListEntry satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllPriceListEntry

PriceListEntryQuery forAllPriceListEntry()

Adds a condition for the feature priceListEntry to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceListEntry satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

priceModifier

MultivaluedFeaturePredicate priceModifier()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature priceModifier has values or not.

thereExistsPriceModifier

PriceModifierQuery thereExistsPriceModifier()

Adds a condition for the feature priceModifier to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceModifier satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllPriceModifier

PriceModifierQuery forAllPriceModifier()

Adds a condition for the feature priceModifier to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature priceModifier satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

priceUsage

MultivaluedFeaturePredicate priceUsage()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature priceUsage has values or not.

thereExistsPriceUsage

ComparableTypePredicate<Short> thereExistsPriceUsage()

Adds a condition for the feature priceUsage to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature priceUsage satisfy the given condition.

Since the multiplicity for this attribute is 0..n, the attribute may have no values. in which case the condition is not satisfied

forAllPriceUsage

ComparableTypePredicate<Short> forAllPriceUsage()

Adds a condition for the feature priceUsage to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature priceUsage satisfy the given condition.

Since the multiplicity for this attribute is 0..n, the attribute may have no values. in which case the condition is satisfied

orderByPriceUsage

MultivaluedTypeOrder orderByPriceUsage()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature priceUsage Note: The order in which orderBy… instructions are given is relevant!

shippingMethod

MultivaluedFeaturePredicate shippingMethod()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the feature shippingMethod has values or not.

thereExistsShippingMethod

ComparableTypePredicate<Short> thereExistsShippingMethod()

Adds a condition for the feature shippingMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature shippingMethod satisfy the given condition.

Since the multiplicity for this attribute is 0..n, the attribute may have no values. in which case the condition is not satisfied

forAllShippingMethod

ComparableTypePredicate<Short> forAllShippingMethod()

Adds a condition for the feature shippingMethod to the predicate for AbstractPriceLevel, which evaluates to false unless the values of the feature shippingMethod satisfy the given condition.

Since the multiplicity for this attribute is 0..n, the attribute may have no values. in which case the condition is satisfied

orderByShippingMethod

MultivaluedTypeOrder orderByShippingMethod()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature shippingMethod Note: The order in which orderBy… instructions are given is relevant!

validFrom

OptionalFeaturePredicate validFrom()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature validFrom is null or not.

thereExistsValidFrom

ComparableTypePredicate<Date> thereExistsValidFrom()

Adds a condition for the feature validFrom to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validFrom satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllValidFrom

ComparableTypePredicate<Date> forAllValidFrom()

Adds a condition for the feature validFrom to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validFrom satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

orderByValidFrom

SimpleTypeOrder orderByValidFrom()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature validFrom Note: The order in which orderBy… instructions are given is relevant!

validTo

OptionalFeaturePredicate validTo()

Adds a constraint to the predicate for AbstractPriceLevel testing whether the value of the feature validTo is null or not.

thereExistsValidTo

ComparableTypePredicate<Date> thereExistsValidTo()

Adds a condition for the feature validTo to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validTo satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is not satisfied

forAllValidTo

ComparableTypePredicate<Date> forAllValidTo()

Adds a condition for the feature validTo to the predicate for AbstractPriceLevel, which evaluates to false unless the value of the feature validTo satisfies the given condition.

Since the attribute is optional its value may be null, in which case the condition is satisfied

orderByValidTo

SimpleTypeOrder orderByValidTo()

Allows to adds a sort instruction for AbstractPriceLevel depending the feature validTo Note: The order in which orderBy… instructions are given is relevant!