// in postgres, it seems that default order by is "order by version" (and perhaps then id),
// so I had "order by id" here, stopping moving lines in alerts CRUD
return (Collections.unmodifiableList(entityManager.createQuery("SELECT o FROM " + IModel.DATABASE_PRE + "Alert o order by id")
.setFirstResult(firstResult).setMaxResults(maxResults).getResultList()));
} catch (Exception ex) {
throw new CustomException(ex);
}
}