Hi!
I have a big problem with my query. Can you hel me to show the result?
I create a function in Page.php that contain my query and that return $result. then I copy $result uin my template but nothig happen. what is wrong?
This is my code:

function TakeValue(){
      $sqlQuery = new SQLQuery();
      $sqlQuery->select[] = array(
          'nome AS nome',
          'tipologia AS tipologia'
         
      );
      $sqlQuery->from[] = "
       RicercaPollSubmission
      ";
      $sqlQuery->where = "
       Tipologia(RicercaPollSubmission.tipologia) = 1
      ";
      
      // get the raw SQL
      $rawSQL = $sqlQuery->sql();
      
      // execute and return a Query-object
      $result = $sqlQuery->execute();
      
      //turn it into SilverStripe objects
      $result = new DataObjectSet();
      foreach($query as $row) {
      $result->push(new TakeValueDataObject($row));

      }
      return $result;
}