gistfile1.txt

@Override
  public ItemCollection findAll(ItemCriteriaImpl criteria) {

    final ItemCollection collection = new ItemCollection();

    final Query query = entityManager.createNativeQuery("CALL api_get_location_item_availability_v1_0(?, ?, ?, ?, ?, ?, ?)", ItemDto.class)
        .setParameter(1, criteria.getLocationNumber())
        .setParameter(2, criteria.getBusinessDate())
        .setParameter(3, criteria.getDepartmentNumber())
        .setParameter(4, "ENG")
        .setParameter(5, criteria.getLimit())
        .setParameter(6, criteria.getOffset())
        .setParameter(7, "INTEGER");

    List<ItemDto> list = query.getResultList();
    for (ItemDto dto : list) {
      if (dto == null) continue;
      collection.getItems().add(dto);
    }

    // Set total number of results
    collection.getPaging()
        .setLimit(criteria.getLimit())
        .setOffset(criteria.getOffset());

    return collection;
  }