Skip to content

Instantly share code, notes, and snippets.

@WillVivid
Created April 3, 2024 18:42
Show Gist options
  • Save WillVivid/bb99d57477993c1ca226c37afefbaf7c to your computer and use it in GitHub Desktop.
Save WillVivid/bb99d57477993c1ca226c37afefbaf7c to your computer and use it in GitHub Desktop.
Nested List
{
"headers":[
"Portfolio",
"State",
"Status",
"Number",
"Project manager"
],
"chartData":[
{
"group":"primary_portfolio",
"value":"",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio="
},
"children":[
{
"group":"state",
"value":"Pending",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=^state=-5"
},
"children":[
{
"group":"status",
"value":"Green",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=^state=-5^status=green"
},
"children":[
{
"group":"number",
"value":"SPRJ00035123",
"query":{
"type":"default",
"query":"40c02e94c3910a50cfdf34ee05013110"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"40c02e94c3910a50cfdf34ee05013110"
},
"children":[
]
}
]
}
]
}
]
},
{
"group":"state",
"value":"Closed Complete",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=^state=3"
},
"children":[
{
"group":"status",
"value":"Green",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=^state=3^status=green"
},
"children":[
{
"group":"number",
"value":"PRJ0010575",
"query":{
"type":"default",
"query":"5f3e720a1bc65110cad9cb36624bcb82"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"5f3e720a1bc65110cad9cb36624bcb82"
},
"children":[
]
}
]
},
{
"group":"number",
"value":"PRJ0010568",
"query":{
"type":"default",
"query":"b2bcf6c61bc65110cad9cb36624bcbc1"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"b2bcf6c61bc65110cad9cb36624bcbc1"
},
"children":[
]
}
]
},
{
"group":"number",
"value":"PRJ0011240",
"query":{
"type":"default",
"query":"ef22a9a61b8e7110cf82ece03d4bcb34"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"ef22a9a61b8e7110cf82ece03d4bcb34"
},
"children":[
]
}
]
}
]
}
]
}
]
},
{
"group":"primary_portfolio",
"value":"Sales",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=ed535e53933012003b4bb095e57ffbf6"
},
"children":[
{
"group":"state",
"value":"Closed Complete",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=ed535e53933012003b4bb095e57ffbf6^state=3"
},
"children":[
{
"group":"status",
"value":"Green",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=ed535e53933012003b4bb095e57ffbf6^state=3^status=green"
},
"children":[
{
"group":"number",
"value":"PRJ0010015",
"query":{
"type":"default",
"query":"42b6cf07db00c81025c85a35dc96198a"
},
"children":[
{
"group":"project_manager",
"value":"Chase Furler",
"query":{
"type":"default",
"query":"42b6cf07db00c81025c85a35dc96198a"
},
"children":[
]
}
]
}
]
}
]
}
]
},
{
"group":"primary_portfolio",
"value":"HR",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e"
},
"children":[
{
"group":"state",
"value":"Closed Complete",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^state=3"
},
"children":[
{
"group":"status",
"value":"Green",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=fce14b3beb131100b749215df106fe0e^state=3^status=green"
},
"children":[
{
"group":"number",
"value":"PRJ0010018",
"query":{
"type":"default",
"query":"b3aad733dbc04010f777526adc9619c8"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"b3aad733dbc04010f777526adc9619c8"
},
"children":[
]
}
]
}
]
}
]
}
]
},
{
"group":"primary_portfolio",
"value":"HR 1",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=523aff751bda1150cad9cb36624bcbd6"
},
"children":[
{
"group":"state",
"value":"Pending",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=523aff751bda1150cad9cb36624bcbd6^state=-5"
},
"children":[
{
"group":"status",
"value":"Green",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=523aff751bda1150cad9cb36624bcbd6^state=-5^status=green"
},
"children":[
{
"group":"number",
"value":"PRJ0010677",
"query":{
"type":"default",
"query":"0079bc6190d41010f877a7f03743b610"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"0079bc6190d41010f877a7f03743b610"
},
"children":[
]
}
]
}
]
}
]
}
]
},
{
"group":"primary_portfolio",
"value":"Application Modernization",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201"
},
"children":[
{
"group":"state",
"value":"Work in Progress",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^state=2"
},
"children":[
{
"group":"status",
"value":"Red",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^state=2^status=red"
},
"children":[
{
"group":"number",
"value":"PRJ0010680",
"query":{
"type":"default",
"query":"03da34a190d41010f877a7f03743b65a"
},
"children":[
{
"group":"project_manager",
"value":"Abel Tuter (architect)",
"query":{
"type":"default",
"query":"03da34a190d41010f877a7f03743b65a"
},
"children":[
]
}
]
}
]
},
{
"group":"status",
"value":"Yellow",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=188fc541535513004e77ddeeff7b1201^state=2^status=yellow"
},
"children":[
{
"group":"number",
"value":"PRJ0010658",
"query":{
"type":"default",
"query":"06e438ad90941010f877a7f03743b64e"
},
"children":[
{
"group":"project_manager",
"value":"Chase Furler",
"query":{
"type":"default",
"query":"06e438ad90941010f877a7f03743b64e"
},
"children":[
]
}
]
}
]
}
]
}
]
},
{
"group":"primary_portfolio",
"value":"Digital/Business Transformation",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=e2e15e53933012003b4bb095e57ffbb7"
},
"children":[
{
"group":"state",
"value":"Pending",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=e2e15e53933012003b4bb095e57ffbb7^state=-5"
},
"children":[
{
"group":"status",
"value":"Green",
"query":{
"type":"custom",
"query":"pm_project_list.do?sysparm_query=primary_portfolio=e2e15e53933012003b4bb095e57ffbb7^state=-5^status=green"
},
"children":[
{
"group":"number",
"value":"PRJ0010044",
"query":{
"type":"default",
"query":"048cbde8db50001025c85a35dc961930"
},
"children":[
{
"group":"project_manager",
"value":"",
"query":{
"type":"default",
"query":"048cbde8db50001025c85a35dc961930"
},
"children":[
]
}
]
}
]
}
]
}
]
}
]
}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment