You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@cloudstack.apache.org by GitBox <gi...@apache.org> on 2020/05/01 15:42:00 UTC
[GitHub] [cloudstack-cloudmonkey] pdion891 opened a new issue #63: display tables does not show complete data
pdion891 opened a new issue #63:
URL: https://github.com/apache/cloudstack-cloudmonkey/issues/63
Here is a test of list hosts api where using filter for 2 fields: name and oscategoryname which is OS preference in cloudstack UI. if I'm using table output , I only get on column because only one host have the OS preference set. but if I'm using json output I get all the information.
This seams to be true also I filter is not used, where the column oscategoryname is not displayed.
table output that is incorrect: (missing column)
```
(staging1) > list hosts filter=oscategoryname,id
count = 13
host:
+--------------------------------------+
| ID |
+--------------------------------------+
| 1b7d55f0-95bd-4aa0-a247-fa5bc99972cf |
| eb3c8438-c8a0-44ee-a770-797feb684fc9 |
| 1a7c2d6b-e4db-4e53-a623-3f9ba55746de |
| 07cbb1ab-d0c5-43c7-9460-3ce8db7445de |
| 57c2557f-3352-4849-aab3-23237023900b |
| 5baf9623-2099-4ce0-8a1e-2bf6e6f776a6 |
| be0a9906-acec-4bf3-b525-e38aba09a1ee |
| ea90f627-e4ef-40a3-8359-cab5eb7c6e35 |
| 5ff06d4a-d447-4e3e-8c2d-0bc85c013fca |
| 0b2ac79f-6b95-422b-b2f3-72389887a367 |
| 4afd50a7-2140-4d10-94d8-c7c77c005c36 |
| 5307f1c4-8a46-45d8-b5cf-188da557719b |
| f6d8fa63-6b28-4e16-956f-3b140d2f4214 |
+--------------------------------------+
(staging1) > list hosts filter=oscategoryname
count = 13
host:
+----------------+
| OSCATEGORYNAME |
+----------------+
| Windows |
+----------------+
```
json output that expose expected results:
```
(staging1) > set display json
(staging1) > list hosts filter=oscategoryname
{
"count": 13,
"host": [
{},
{},
{},
{},
{},
{
"oscategoryname": "Windows"
},
{},
{},
{},
{},
{},
{},
{}
]
}
(staging1) > list hosts filter=oscategoryname,name
{
"count": 13,
"host": [
{
"name": "stg-xen05"
},
{
"name": "stg-xen06"
},
{
"name": "stg-xen76-01"
},
{
"name": "stg-xen76-02"
},
{
"name": "stg-xen76-03"
},
{
"name": "stg-xen01",
"oscategoryname": "Windows"
},
{
"name": "s-3438-VM"
},
{
"name": "test-xen01"
},
{
"name": "stg-xen02"
},
{
"name": "stg-xen03"
},
{
"name": "v-3437-VM"
},
{
"name": "stg-xen04"
},
{
"name": "test-xen02"
}
]
}```
I think it's just a matter of suporting empty fields in the table output.
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-cloudmonkey] rhtyd commented on issue #63: display tables does not show complete data
Posted by GitBox <gi...@apache.org>.
rhtyd commented on issue #63:
URL: https://github.com/apache/cloudstack-cloudmonkey/issues/63#issuecomment-645785781
@pdion891 thanks, I've fixed it on master; please test and let me know if you've the issue. Thanks
My testing:
```
> list hosts filter=id,oscategoryid,oscategoryname, pagesize=500 page=1
host:
count = 24
+--------------------------------------+--------------------------------------+----------------+
| ID | OSCATEGORYID | OSCATEGORYNAME |
+--------------------------------------+--------------------------------------+----------------+
| 12e30701-5918-4862-9a5a-292a382e29af | | |
| 5289ccf0-f350-4268-9937-3850ac611513 | | |
| 956c4fa1-2baf-41e1-8eea-6ce72a2617e8 | | |
| 9d202292-8fee-4b82-bf4d-36222ecc0e9c | | |
| 79cd2559-817f-42b8-9d7e-5641726d773b | | |
| 4934e9d3-bc6f-436b-b271-f1d703452ed5 | | |
| a9488ce3-f9f0-4380-9f61-10cc409ac58c | | |
| 4f944183-7cfe-41c7-a34c-b7230bb503d5 | e4992bed-5fdf-11ea-9a56-1e006800018c | CentOS |
| 8e8e68e7-19ea-4a78-bbdb-6e79d27729c9 | e4992bed-5fdf-11ea-9a56-1e006800018c | CentOS |
| 942af538-8d46-4452-b6cc-9ac8ac2a6de2 | | |
| 9893618c-30a6-4e8a-a8fb-ee72840ebc8c | | |
| f2b681dd-316c-4ddd-b6ab-b9ecd3232c38 | | |
| 5303bc89-7199-45cb-ba59-fbeb28a38657 | | |
| 642e87a0-4278-44e5-9b71-bf464aa45a35 | e49c021c-5fdf-11ea-9a56-1e006800018c | Oracle |
| 36752913-03ba-4dbc-be44-37f2c1969175 | e49a5fe0-5fdf-11ea-9a56-1e006800018c | Debian |
| d0f3705d-3bc8-4b7f-8079-0a2635faa9ff | | |
| 098ee8f2-430b-4141-ae41-846485ad1d42 | | |
| 8b754adc-f41d-45b5-827f-886a423714fd | e4992bed-5fdf-11ea-9a56-1e006800018c | CentOS |
| bfa82049-0235-4b82-8696-c2c0b9e85023 | | |
| ca77fd0a-5d1c-4f79-866f-75a71096c124 | | |
| 6fad5751-153b-4d9f-96ba-658fbfd8bea2 | | |
| 7c5f508d-6b8a-4bd4-9621-0366cd7bd339 | | |
| fcd16af9-f021-46f7-8a16-e2fc1b9a8be6 | | |
| f1376486-80f5-495a-8fa6-0dfa82aef03c | | |
+--------------------------------------+--------------------------------------+----------------+
```
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org
[GitHub] [cloudstack-cloudmonkey] rhtyd closed issue #63: display tables does not show complete data
Posted by GitBox <gi...@apache.org>.
rhtyd closed issue #63:
URL: https://github.com/apache/cloudstack-cloudmonkey/issues/63
----------------------------------------------------------------
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
For queries about this service, please contact Infrastructure at:
users@infra.apache.org