Hello,

I was trying the new API from version 4.1. I tried to retrieve progress of all of my projects and it happened that it returns to me 0. I found that progress is not a variable from Project but it is a variable from a PlanningElement that is a member variable of Project.

So I assumed that only the data for Project was retrieved from database and not the one for the other sql elements inside a Project...

You will find my attempt to fix that bug with a patch attached with this post (I work with git).

Basically, I defined a new function

getAllSqlElementsFromCriteria

We must define it for each SqlElements containing other SqlElements. Surely there is a better way to achieve that...

Here it is how I fixed Project (I know there is other SqlElements than Project that contains SqlElements but I don't use them for now):

  public function getAllSqlElementsFromCriteria($critArray, $initializeIfEmpty=false, $clauseWhere=null, $clauseOrderBy=null, 
                                                $getIdInKey=false, $withoutDependentObjects=false, $maxElements=null) {
      $projects = array();
      $projects = parent::getAllSqlElementsFromCriteria($critArray, $initializeIfEmpty, $clauseWhere, $clauseOrderBy,
              $getIdInKey, $withoutDependentObjects, $maxElements);
      foreach ($projects as $project) {
        $project->ProjectPlanningElement = SqlElement::getSingleSqlElementFromCriteria('ProjectPlanningElement', array('refType'=>'Project', 'refId'=>$project->id));
      }
      
      return $projects;
  }

The patch: