Guest User

Untitled

a guest
Jan 22nd, 2018
73
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.57 KB | None | 0 0
  1. public function getPagedDatapoints($termId, $start, $pageSize)
  2. {
  3. $queryB = $this->getEntityManager()->createQueryBuilder();
  4.  
  5. $queryB->select('dp')
  6. ->from('SE\Entity\DataPoint', 'dp')
  7. ->where('dp.term = ?1')
  8. ->orderBy('dp.dateTime', 'DESC')
  9. ->setFirstResult($start)
  10. ->setMaxResults($pageSize);
  11.  
  12. $query = $queryB->getQuery();
  13. $query->setParameter(1, $termId);
  14.  
  15. $results = $query->getResult();
  16.  
  17. return $results;
  18.  
  19. }
Add Comment
Please, Sign In to add comment