Fetches shared excluded placements. Supports filtering and sorting.
Typical usage:
var sharedExcludedPlacementSelector = excludedPlacementList.excludedPlacements()
.withCondition("PlacementUrl CONTAINS 'test'")
.withLimit(1)
.withIds([10,20])
.orderBy("SharedSetId DESC");
var sharedExcludedPlacementIterator = sharedExcludedPlacementSelector.get();
while (sharedExcludedPlacementIterator.hasNext()) {
var sharedExcludedPlacement = sharedExcludedPlacementIterator.next();
}
Methods:
get()
Fetches the requested shared excluded placements and returns an iterator.
Return values:
orderBy(orderBy)
Specifies the ordering of the resulting entities.
orderBy
parameter can have one of the
following forms:
orderBy("Name")
- orders results by Name, in ascending order.
orderBy("SharedSetId ASC")
- orders results by SharedSetId, in ascending order.
orderBy("Name DESC")
- orders results by Name, in descending order.
See SharedExcludedPlacementSelector.withCondition(String) for enumeration of columns that can be used.
orderBy()
may be called multiple times. Consider the following example:
sharedExcludedPlacementSelector = sharedExcludedPlacementselector
.orderBy("SharedSetId DESC");
The results will be ordered by SharedSetId in descending order.
Arguments:
Name | Type | Description |
orderBy |
String |
Ordering to apply. |
Return values:
withCondition(condition)
Adds the specified condition to the selector in order to narrow down the results.
Multiple conditions may be added to the same selector:
sharedExcludedPlacementSelector = sharedExcludedPlacementSelector
.withCondition("SharedSetId > 5")
.withCondition("Name CONTAINS 'shared excluded placement'");
All specified conditions are
AND
-ed together. The above example will retrieve
shared excluded placements that have a Shared Set Id greater than 5 and contains
"shared excluded placement" in its name.
The parameter to be passed into this method must be of the following form:
"COLUMN_NAME OPERATOR VALUE"
Operators
The operator that can be used in a condition depends on the type of column.
- For
Long
columns (e.g. SharedSetId):
< <= > >= = !=
- For
String
columns (e.g. Name):
= != STARTS_WITH STARTS_WITH_IGNORE_CASE CONTAINS
CONTAINS_IGNORE_CASE DOES_NOT_CONTAIN DOES_NOT_CONTAIN_IGNORE_CASE
Conditions using
IN
,
NOT_IN
,
CONTAINS_ALL
,
CONTAINS_ANY
and
CONTAINS_NONE
operators look as follows:
withCondition("Name IN [Value1, Value2]")
Operators are case-sensitive:
starts_with
won't work.
Columns
All column names are case-sensitive, and so are all values of enumerated columns (such as
Status).
Column |
Type |
Example |
Shared Set Criterion Attributes
|
Id |
Long |
withCondition("Id = 5") |
SharedSetId |
Long |
withCondition("SharedSetId = 5") |
PlacementUrl |
String |
withCondition("PlacementUrl CONTAINS 'test'") |
Arguments:
Name | Type | Description |
condition |
String |
Condition to add to the selector. |
Return values:
withLimit(limit)
Specifies limit for the selector to use. For instance,
withLimit(50)
returns only the
first 50 entities.
Arguments:
Name | Type | Description |
limit |
int |
How many entities to return. |
Return values: