SpentHours, TotalSpentHours and TotalEstimatedHours null return

[ntirado89]

I am using the GetObjects method and the fields SpentHours, TotalSpentHours and TotalEstimatedHours return me null (IMG_01) on the web it shows me the correct information (IMG_02)

[zapadi]

Hi,
Could you tell me the redmine & redmine api version that you are using?

[ntirado89]

Environment:
Redmine version 4.0.4.stable
Ruby version 2.5.5-p157 (2019-03-15) [x64-mingw32]
Rails version 5.2.3
Environment production
Database adapter Mysql2
Mailer queue ActiveJob::QueueAdapters::AsyncAdapter
Mailer delivery smtp
SCM:
Git 2.19.1
Filesystem
Redmine plugins:
no plugin installed

[zapadi]

Hi,
I can't reproduce the issue
What is the redmine.net.api version and format(json|xml) that you are using?

[MarcinTroska]

Hi @zapadi - got the same issue as the reporter

My Redmine
Environment: Redmine version 3.4.4.stable Ruby version 2.5.1-p57 (2018-03-29) [x86_64-linux-gnu] Rails version 4.2.10 Environment production Database adapter Mysql2 SCM: Filesystem Redmine plugins: no plugin installed

Currently using nuget 4.0.1 - I did also downgrade the version 3 times but nothing changed

My test code

` Console.WriteLine("UpdateIssuesTime called");
var parameters = new NameValueCollection();
parameters.Add(RedmineKeys.STATUS, "New");

        var issues = _redmineManager.GetObjects<Issue>(parameters);

        Console.WriteLine($"var count {issues.Count()}");
        
        foreach (var issue in issues)
        {
            decimal workHours = 0;

            try
            {
                var timeParameters = new NameValueCollection();
                timeParameters.Add(RedmineKeys.ISSUE_ID, issue.Id.ToString());
                var timeTackers = _redmineManager.GetObjects<TimeEntry>(timeParameters);


                foreach (var item in timeTackers)
                {
                    try
                    {
                        workHours += item.Hours;
                    }
                    catch (Exception ex)
                    {
                        Console.WriteLine(ex.Message);
                    }

                    Console.WriteLine("workHours increased to : " + workHours);
                }
            }
            catch (Exception ex)
            {

                Console.WriteLine(ex.Message);
            }


            var estimationTime = issue.EstimatedHours ?? 0;

            Console.WriteLine($"ID: {issue.Id}");
            Console.WriteLine($"workHours: {issue?.TotalSpentHours}");
            Console.WriteLine($"workHours2: {workHours}");
            Console.WriteLine($"estimationTime: {issue?.EstimatedHours}");

            UpdateIssueTime(issue.Id.ToString(), (estimationTime - (float)workHours).ToString());`

At the moment i have 2 issues - both with EstimatedHours set to 20, only one issue has 2 TimeEntries each property for issue spent hours returns null.

But when I use _redmineManager.GetObjects for TimeEntry the entry for id 2 returns the correct hours and for id 1 it throws a nullreference exception.

any idea?

[zapadi]

Hello @MarcinTroska ,

I'll get back to you as soon as I have an answer to your issue.

[gpapotti]

Same problem here. Redmine version 4.0.1.stable, RedmineApi 4.2.0

[zapadi]

GetObject returns more properties than GetObjects for Issues and Users.
https://github.com/redmine/redmine/blob/master/app/views/issues/index.api.rsb vs https://github.com/redmine/redmine/blob/master/app/views/issues/show.api.rsb