| Package | Description |
|---|---|
| com.googlecode.genericdao.search | |
| net.pricefx.formulaengine | |
| net.pricefx.formulaengine.scripting | |
| net.pricefx.server.dto.calculation |
| Modifier and Type | Method and Description |
|---|---|
static Filter |
Filter.all(String property,
Filter filter)
Create a new Filter using the ALL operator.
|
static Filter |
Filter.and(Filter... filters)
Create a new Filter using the AND operator.
|
static Filter |
Filter.custom(String expression)
Create a new Filter using a custom JPQL/HQL expression.
|
static Filter |
Filter.custom(String expression,
Collection<?> values)
Create a new Filter using a custom JPQL/HQL expression.
|
static Filter |
Filter.custom(String expression,
Object... values)
Create a new Filter using a custom JPQL/HQL expression.
|
static Filter |
Filter.equal(String property,
Object value)
Create a new Filter using the == operator.
|
static Filter |
Filter.greaterOrEqual(String property,
Object value)
Create a new Filter using the >= operator.
|
static Filter |
Filter.greaterThan(String property,
Object value)
Create a new Filter using the > operator.
|
static Filter |
Filter.ilike(String property,
String value)
Create a new Filter using the ILIKE operator.
|
static Filter |
Filter.in(String property,
Collection<?> value)
Create a new Filter using the IN operator.
|
static Filter |
Filter.in(String property,
Object... value)
Create a new Filter using the IN operator.
|
static Filter |
Filter.isEmpty(String property)
Create a new Filter using the IS EMPTY operator.
|
static Filter |
Filter.isNotEmpty(String property)
Create a new Filter using the IS NOT EMPTY operator.
|
static Filter |
Filter.isNotNull(String property)
Create a new Filter using the IS NOT NULL operator.
|
static Filter |
Filter.isNull(String property)
Create a new Filter using the IS NULL operator.
|
static Filter |
Filter.lessOrEqual(String property,
Object value)
Create a new Filter using the <= operator.
|
static Filter |
Filter.lessThan(String property,
Object value)
Create a new Filter using the < operator.
|
static Filter |
Filter.like(String property,
String value)
Create a new Filter using the LIKE operator.
|
static Filter |
Filter.none(String property,
Filter filter)
Create a new Filter using the NONE operator.
|
static Filter |
Filter.not(Filter filter)
Create a new Filter using the NOT operator.
|
static Filter |
Filter.notEqual(String property,
Object value)
Create a new Filter using the != operator.
|
static Filter |
Filter.notIn(String property,
Collection<?> value)
Create a new Filter using the NOT IN operator.
|
static Filter |
Filter.notIn(String property,
Object... value)
Create a new Filter using the NOT IN operator.
|
static Filter |
Filter.or(Filter... filters)
Create a new Filter using the OR operator.
|
static Filter |
Filter.some(String property,
Filter filter)
Create a new Filter using the SOME operator.
|
| Modifier and Type | Method and Description |
|---|---|
void |
Filter.add(Filter filter)
Used with OP_OR and OP_AND filters.
|
static Filter |
Filter.all(String property,
Filter filter)
Create a new Filter using the ALL operator.
|
static Filter |
Filter.and(Filter... filters)
Create a new Filter using the AND operator.
|
static Filter |
Filter.none(String property,
Filter filter)
Create a new Filter using the NONE operator.
|
static Filter |
Filter.not(Filter filter)
Create a new Filter using the NOT operator.
|
static Filter |
Filter.or(Filter... filters)
Create a new Filter using the OR operator.
|
void |
Filter.remove(Filter filter)
Used with OP_OR and OP_AND filters.
|
static Filter |
Filter.some(String property,
Filter filter)
Create a new Filter using the SOME operator.
|
| Modifier and Type | Method and Description |
|---|---|
Filter |
DatamartContext.Calendar.timePeriodAsFilter(CalendarUtil.TimePeriod timePeriod,
String dateDimFieldName)
Helper method to build a filter representing
dateDimFieldName in [timePeriod.startPeriod, timePeriod.endPeriod]
Note the inclusion on both ends; this is to accommodate the most frequent use case where the TimePeriod is a single period, for
example InvoiceDate in [2015,2015]. |
| Modifier and Type | Method and Description |
|---|---|
void |
DatamartContext.DataSlice.addFilter(Filter filter) |
DatamartContext.Query |
DatamartContext.Query.having(Filter... filters)
Adds generic
Filters to the query's HAVING clause. |
DatamartContext.Query |
DatamartContext.Query.where(Filter... filters)
Adds generic
Filters to the query's WHERE clause. |
| Modifier and Type | Method and Description |
|---|---|
Filter |
PublicGroovyAPI.createElementNameFilter(String elementName,
Object fieldValue,
String... listTypedIds)
Creates a cross-list filter expression based on meta data.
|
Filter |
PublicGroovyAPI.customerToRelatedObjectsFilter(String relatedObjectTypeCode,
String customerId)
Creates a filter to be applied to a search on a related object type, limiting the result to objects of the related type that have a link to the given customer.
|
Filter |
PublicGroovyAPI.datamartFilter(Object groupOrSlice)
Translates a CustomerGroup/ProductGroup/DMDataSlice to its equivalent Filter representation,
mapping domain level field names to the corresponding Datamart field names in the process.
|
Filter |
PublicGroovyAPI.filterFromMap(Map<String,Object> filterMap)
Constructs a Filter object from a map representation of that filter (from the "wire format")
The map representation is the way the filter is described in the JSON requests between UI and server
|
Filter |
PublicGroovyAPI.productToRelatedObjectsFilter(String relatedObjectTypeCode,
String sku)
Creates a filter to be applied to a search on a related object type, limiting the result to objects of the related type that have a link to the given product.
|
Filter |
PublicGroovyAPI.relatedObjectToCustomersFilter(String relatedObjectTypedId)
Creates a filter to be applied to a Customer search, limiting the result to customers that are linked to the given related object, the latter defined by its typedId.
|
Filter |
PublicGroovyAPI.relatedObjectToProductsFilter(String relatedObjerelatedObjectTypedId)
Creates a filter to be applied to a Product search, limiting the result to products that are linked to the given related object, the latter defined by its typedId.
|
Filter |
PublicGroovyAPI.walkFilter(Filter filter,
Closure<?> visitBefore,
Closure<?> visitAfter,
boolean removeNulls)
Walks a filter and all its sub filters, visiting each filter in the tree.
|
| Modifier and Type | Method and Description |
|---|---|
int |
PublicGroovyAPI.count(String typeCode,
Filter... filters)
Similar to the
PublicGroovyAPI.find(java.lang.String, com.googlecode.genericdao.search.Filter...) methods this method querys an arbitrary object type. |
Object |
PublicGroovyAPI.customerExtension(String extensionName,
Filter... filters)
Equivalent of the standard syntax' "CXLookup" function.
|
void |
PublicGroovyAPI.emitRebateRecords(String dateFieldName,
String sortBy,
Filter... filters)
Emits the rebate records matching the given search criteria, to be consumed by a PA allocation task (a PA calculation task with a feeder formula calling
this method, and a regular formulaa accepting each emitted RebateRecord as its currentItem context, and distributing one or more RebateRecord accruals
over the set of PA rows havong contributed to those accruals in some way (by revenue, bvolume...).
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
int startRow,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
int startRow,
int maxRows,
String sortBy,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
int startRow,
int maxRows,
String sortBy,
List<String> fields,
boolean distinctValuesOnly,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
int startRow,
int maxRows,
String sortBy,
List<String> fields,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
int startRow,
int maxRows,
String sortBy,
Map<String,String> fields,
boolean distinctValuesOnly,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.find(String typeCode,
int startRow,
String sortBy,
Filter... filters)
The swiss army knife method of the API.
|
List<Object> |
PublicGroovyAPI.findLookupTableValues(String tableName,
Filter... filters)
Searches and returns values of a named lookup table.
|
Object |
PublicGroovyAPI.productCompetition(Filter... filters)
Equivalent of the standard syntax' "Competition" function.
|
Object |
PublicGroovyAPI.productExtension(String extensionName,
Filter... filters)
Equivalent of the standard syntax' "PXLookup" function.
|
Object |
PublicGroovyAPI.productXRef(Filter... filters)
Equivalent of the standard syntax' "XRefLookup" function.
|
AbstractProducer.ResultIterator |
PublicGroovyAPI.stream(String typeCode,
String sortBy,
Filter... filters)
Search for all types of objects with a freestyle query, and iterate over the result set.
|
AbstractProducer.ResultIterator |
PublicGroovyAPI.stream(String typeCode,
String sortBy,
List<String> fields,
boolean distinctValuesOnly,
Filter... filters)
Search for all types of objects with a freestyle query, and iterate over the result set.
|
AbstractProducer.ResultIterator |
PublicGroovyAPI.stream(String typeCode,
String sortBy,
List<String> fields,
Filter... filters)
Search for all types of objects with a freestyle query, and iterate over the result set.
|
AbstractProducer.ResultIterator |
PublicGroovyAPI.stream(String typeCode,
String sortBy,
Map<String,String> fields,
boolean distinctValuesOnly,
Filter... filters)
Search for all types of objects with a freestyle query, and iterate over the result set.
|
Filter |
PublicGroovyAPI.walkFilter(Filter filter,
Closure<?> visitBefore,
Closure<?> visitAfter,
boolean removeNulls)
Walks a filter and all its sub filters, visiting each filter in the tree.
|
| Modifier and Type | Method and Description |
|---|---|
ResultMatrix.ResultMatrixLinkCell |
ResultMatrix.linkToPriceGrid(Object value,
long priceGridID,
Filter filter) |
ResultMatrix.ResultMatrixLinkCell |
ResultMatrix.linkToPriceList(Object value,
long priceListID,
Filter filter) |
void |
ContextParameter.setFilters(Filter... filters) |
Copyright © 2016. All rights reserved.