René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"display tables does not show complete data","articleBody":"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.\r\n\r\nThis seams to be true also I filter is not used, where the column oscategoryname is not displayed.\r\n\r\n\r\ntable output that is incorrect: (missing column)\r\n```\r\n(staging1)  \u003e list hosts filter=oscategoryname,id\r\ncount = 13\r\nhost:\r\n+--------------------------------------+\r\n|                  ID                  |\r\n+--------------------------------------+\r\n| 1b7d55f0-95bd-4aa0-a247-fa5bc99972cf |\r\n| eb3c8438-c8a0-44ee-a770-797feb684fc9 |\r\n| 1a7c2d6b-e4db-4e53-a623-3f9ba55746de |\r\n| 07cbb1ab-d0c5-43c7-9460-3ce8db7445de |\r\n| 57c2557f-3352-4849-aab3-23237023900b |\r\n| 5baf9623-2099-4ce0-8a1e-2bf6e6f776a6 |\r\n| be0a9906-acec-4bf3-b525-e38aba09a1ee |\r\n| ea90f627-e4ef-40a3-8359-cab5eb7c6e35 |\r\n| 5ff06d4a-d447-4e3e-8c2d-0bc85c013fca |\r\n| 0b2ac79f-6b95-422b-b2f3-72389887a367 |\r\n| 4afd50a7-2140-4d10-94d8-c7c77c005c36 |\r\n| 5307f1c4-8a46-45d8-b5cf-188da557719b |\r\n| f6d8fa63-6b28-4e16-956f-3b140d2f4214 |\r\n+--------------------------------------+\r\n(staging1)  \u003e list hosts filter=oscategoryname\r\ncount = 13\r\nhost:\r\n+----------------+\r\n| OSCATEGORYNAME |\r\n+----------------+\r\n| Windows        |\r\n+----------------+\r\n```\r\n\r\njson output that expose expected results: \r\n```\r\n(staging1)  \u003e set display json\r\n(staging1)  \u003e list hosts filter=oscategoryname\r\n{\r\n  \"count\": 13,\r\n  \"host\": [\r\n    {},\r\n    {},\r\n    {},\r\n    {},\r\n    {},\r\n    {\r\n      \"oscategoryname\": \"Windows\"\r\n    },\r\n    {},\r\n    {},\r\n    {},\r\n    {},\r\n    {},\r\n    {},\r\n    {}\r\n  ]\r\n}\r\n(staging1)  \u003e list hosts filter=oscategoryname,name\r\n{\r\n  \"count\": 13,\r\n  \"host\": [\r\n    {\r\n      \"name\": \"stg-xen05\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen06\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen76-01\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen76-02\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen76-03\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen01\",\r\n      \"oscategoryname\": \"Windows\"\r\n    },\r\n    {\r\n      \"name\": \"s-3438-VM\"\r\n    },\r\n    {\r\n      \"name\": \"test-xen01\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen02\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen03\"\r\n    },\r\n    {\r\n      \"name\": \"v-3437-VM\"\r\n    },\r\n    {\r\n      \"name\": \"stg-xen04\"\r\n    },\r\n    {\r\n      \"name\": \"test-xen02\"\r\n    }\r\n  ]\r\n}```\r\n\r\n\r\nI think it's just a matter of suporting empty fields in the table output.","author":{"url":"https://github.com/pdion891","@type":"Person","name":"pdion891"},"datePublished":"2020-05-01T15:41:46.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/63/cloudstack-cloudmonkey/issues/63"}