Not able to retrieve the exact information from az devops project list --output table command

Facing issues while running the Az DevOps commands and not able to retrieve the exact information as mentioned below.

when we run the below command we get the expected information

az DevOps project list

Output :

{

"continuationToken": null,

"value": [

{

"abbreviation": null,

"defaultTeamImageUrl": null,

"description": "Project to store development standards",

"id": "5a80632b-2cc3-4749-94ed-5a3c80676395",

"lastUpdateTime": "2019-10-04T09:32:49.367000+00:00",

"name": "Standards",

"revision": 81,

"state": "wellFormed",

"url": "https://dev.azure.com/cndlfntdkngdm/_apis/projects/5a80632b-2cc3-4749-94ed-5a3c80676395",

"visibility": "private"

},

{

"abbreviation": null,

"defaultTeamImageUrl": null,

"description": null,

"id": "3069873b-52d2-4347-8fd6-c847fe2bf91c",

"lastUpdateTime": "2020-03-13T15:12:53.163000+00:00",

"name": "DevOps",

"revision": 115,

"state": "wellFormed",

"url": "https://dev.azure.com/cndlfntdkngdm/_apis/projects/3069873b-52d2-4347-8fd6-c847fe2bf91c",

"visibility": "private"

},

{

"abbreviation": null,

"defaultTeamImageUrl": null,

"description": null,

"id": "5de3cbf7-044d-44cd-a999-48c08390bf48",

"lastUpdateTime": "2020-02-25T08:49:15.757000+00:00",

"name": "SingleSignOn",

"revision": 114,

"state": "wellFormed",

"url": "https://dev.azure.com/cndlfntdkngdm/_apis/projects/5de3cbf7-044d-44cd-a999-48c08390bf48",

"visibility": "private"

},

{

"abbreviation": null,

"defaultTeamImageUrl": null,

"description": null,

"id": "44441a19-ae3c-4c44-9011-ef3b46ed8c19",

"lastUpdateTime": "2020-02-19T07:14:46.680000+00:00",

"name": "Integration",

"revision": 97,

"state": "wellFormed",

"url": "https://dev.azure.com/cndlfntdkngdm/_apis/projects/44441a19-ae3c-4c44-9011-ef3b46ed8c19",

"visibility": "private"

},

{

"abbreviation": null,

"defaultTeamImageUrl": null,

"description": "Project to collate Ultima Questionnaire data",

"id": "ce2687da-b15b-4385-97fd-ce7c7c2e51ec",

"lastUpdateTime": "2019-11-27T07:13:54.273000+00:00",

"name": "Ultima",

"revision": 95,

"state": "wellFormed",

"url": "https://dev.azure.com/cndlfntdkngdm/_apis/projects/ce2687da-b15b-4385-97fd-ce7c7c2e51ec",

"visibility": "private"

},

{

"abbreviation": null,

"defaultTeamImageUrl": null,

"description": "Project to document the administration of the Organisation",

"id": "60a1b7c6-f132-4aad-9afb-0436586537b4",

"lastUpdateTime": "2019-08-22T07:52:17.893000+00:00",

"name": "Administration",

"revision": 40,

"state": "wellFormed",

"url": "https://dev.azure.com/cndlfntdkngdm/_apis/projects/60a1b7c6-f132-4aad-9afb-0436586537b4",

"visibility": "private"

}

]

}

**Issues 1**

If we run the below command we are expecting all the columns as an output. But we are getting only 3 columns as below.

az DevOps project list --output table


Why do we only get 3 columns, when output is to a table?

**Issue 2**

As per here:- https://github.com/Azure/azure-devops-cli-extension/blob/master/doc/samples.md#query-output

If we run the below query we are not getting any output even though all their projects are “private”:-

az devops project list --query "[?visibility=='private'].{ProjectName: name, ProjectDescription: description}"

Result: No Output

**Issue 3**

If we run the below command we are getting output as null.

az DevOps project list --query "{name: name}"

Output:
they get:-

{

"name": null

}

Could you please look into this issue and let us know the exact commands to execute.