[jira] [Commented] (CLOUDSTACK-9653) listCapacity API shows incorrect output when sortBy=usage option is added

["ASF GitHub Bot (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CLOUDSTACK-9653?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15728367#comment-15728367 ] 

ASF GitHub Bot commented on CLOUDSTACK-9653:
--------------------------------------------

GitHub user rashmidixit opened a pull request:

    https://github.com/apache/cloudstack/pull/1819

    CLOUDSTACK-9653 The system capacity was not getting calculated correctly

    When listCapacity is used with the sortBy=usage option, the capacity was not getting calculated correctly.
    
    Root Cause: The group by options for pod and zone was incorrectly specified. Results were additionally added up. Result was incorrect.
    
    Once the correct group by clause is specified, only the results of the query need to be returned.

You can merge this pull request into a Git repository by running:

    $ git pull https://github.com/Accelerite/cloudstack ListCapacityIssue

Alternatively you can review and apply these changes as the patch at:

    https://github.com/apache/cloudstack/pull/1819.patch

To close this pull request, make a commit to your master/trunk branch
with (at least) the following in the commit message:

    This closes #1819
    
----
commit 97b6b117e1448115613318aef1679ac00c93375e
Author: rashmidixit <ra...@persistent.co.in>
Date:   2016-12-05T08:55:27Z

    The system capacity was not getting calculated correctly

----


> listCapacity API shows incorrect output when sortBy=usage option is added
> -------------------------------------------------------------------------
>
>                 Key: CLOUDSTACK-9653
>                 URL: https://issues.apache.org/jira/browse/CLOUDSTACK-9653
>             Project: CloudStack
>          Issue Type: Bug
>      Security Level: Public(Anyone can view this level - this is the default.) 
>          Components: API
>    Affects Versions: 4.6.0, 4.7.0, 4.8.0, 4.9.0
>            Reporter: Rashmi Dixit
>            Assignee: Rashmi Dixit
>             Fix For: 4.9.1.0
>
>
> listCapacity API does not sum up values correctly when used with sortBy=usage option.



--
This message was sent by Atlassian JIRA
(v6.3.4#6332)