// Get the LineItemCreativeAssociationService.
LineItemCreativeAssociationServiceInterface licaService =
dfpServices.get(session, LineItemCreativeAssociationServiceInterface.class);
// Create a statement to all LICAs for a line item.
StatementBuilder statementBuilder = new StatementBuilder()
.where("WHERE lineItemId = :lineItemId ")
.orderBy("lineItemId ASC, creativeId ASC")
.limit(StatementBuilder.SUGGESTED_PAGE_LIMIT)
.withBindVariableValue("lineItemId", lineItemId);
// Default for total result set size.
int totalResultSetSize = 0;
do {
// Get LICAs by statement.
LineItemCreativeAssociationPage page =
licaService.getLineItemCreativeAssociationsByStatement(statementBuilder.toStatement());
if (page.getResults() != null) {
totalResultSetSize = page.getTotalResultSetSize();
int i = page.getStartIndex();
for (LineItemCreativeAssociation lica : page.getResults()) {
if (lica.getCreativeSetId() != null) {
System.out.printf(
"%d) LICA with line item ID \"%d\" and creative set ID \"%d\" was found.\n", i++,
lica.getLineItemId(), lica.getCreativeSetId());
} else {
System.out.printf(
"%d) LICA with line item ID \"%d\" and creative ID \"%d\" was found.\n", i++,
lica.getLineItemId(), lica.getCreativeId());
}
}
}
statementBuilder.increaseOffsetBy(StatementBuilder.SUGGESTED_PAGE_LIMIT);
} while (statementBuilder.getOffset() < totalResultSetSize);
System.out.printf("Number of results found: %d\n", totalResultSetSize);
}