Statement filterStatement =
new StatementBuilder("WHERE type = :type LIMIT 500")
.putValue("type", CompanyType.ADVERTISER.toString()).toStatement();
// Get the companies by statement.
CompanyPage page =
companyService.getCompaniesByStatement(filterStatement);
if (page.getResults() != null) {
Company[] companies = page.getResults();
// Update each local company object by appending LLC. to its name.
for (Company company : companies) {
company.setName(company.getName() + " LLC.");
}