/**
  * Performs a dynamic query on the database and returns an ordered range of the matching rows.
  *
  * <p>Useful when paginating results. Returns a maximum of <code>end - start</code> instances.
  * <code>start</code> and <code>end</code> are not primary keys, they are indexes in the result
  * set. Thus, <code>0</code> refers to the first result in the set. Setting both <code>start
  * </code> and <code>end</code> to {@link com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}
  * will return the full result set. If <code>orderByComparator</code> is specified, then the query
  * will include the given ORDER BY logic. If <code>orderByComparator</code> is absent and
  * pagination is required (<code>start</code> and <code>end</code> are not {@link
  * com.liferay.portal.kernel.dao.orm.QueryUtil#ALL_POS}), then the query will include the default
  * ORDER BY logic from {@link fi.csc.avaa.kotus.kielikartastot.db.model.impl.IlmioModelImpl}. If
  * both <code>orderByComparator</code> and pagination are absent, for performance reasons, the
  * query will not have an ORDER BY clause and the returned result set will be sorted on by the
  * primary key in an ascending order.
  *
  * @param dynamicQuery the dynamic query
  * @param start the lower bound of the range of model instances
  * @param end the upper bound of the range of model instances (not inclusive)
  * @param orderByComparator the comparator to order the results by (optionally <code>null</code>)
  * @return the ordered range of matching rows
  * @throws SystemException if a system exception occurred
  */
 @Override
 @SuppressWarnings("rawtypes")
 public List dynamicQuery(
     DynamicQuery dynamicQuery, int start, int end, OrderByComparator orderByComparator)
     throws SystemException {
   return ilmioPersistence.findWithDynamicQuery(dynamicQuery, start, end, orderByComparator);
 }
 /**
  * Performs a dynamic query on the database and returns the matching rows.
  *
  * @param dynamicQuery the dynamic query
  * @return the matching rows
  * @throws SystemException if a system exception occurred
  */
 @Override
 @SuppressWarnings("rawtypes")
 public List dynamicQuery(DynamicQuery dynamicQuery) throws SystemException {
   return ilmioPersistence.findWithDynamicQuery(dynamicQuery);
 }