"Object of class stdClass could not be converted to string" since 1.38

[leonardfischer]

Hi there,

first of all - thanks for the great API client! Since I updated to the latest version (1.38.1) I get errors when searching for Jira issues. But this happenes only sometimes (it seems to depend on the found issues):

$issues = (new IssueService($configuration))->search($jql, 0, 5)->issues;

Results in

Object of class stdClass could not be converted to string
[...] Base->error()
[vendor/netresearch/jsonmapper/src/JsonMapper.php:213] settype()
[vendor/netresearch/jsonmapper/src/JsonMapper.php:278] JsonMapper->map()
[vendor/netresearch/jsonmapper/src/JsonMapper.php:384] JsonMapper->map()
[vendor/netresearch/jsonmapper/src/JsonMapper.php:263] JsonMapper->mapArray()
[vendor/lesstif/php-jira-rest-client/src/Issue/IssueService.php:526] JsonMapper->map()
[...] JiraRestApi\Issue\IssueService->search()

I use PHP 7.2.15 and collect Jira issues via CLI command. When reverting to the previous version (1.37) the code works without any problems.

The error itself happens in netresearch/jsonmapper but I saw there hasn't been any release in the last years.

[lesstif]

hi @leonardfischer

i'm sorry, i can't reproduced it.
could you show me the server's response json when an exception occurs please?

[leonardfischer]

Hey @lesstif sure, no problem.
I could narrow it down to one issue... But I'm required to blank out some values due to data privacy... Also I did not format it here, since the times I tried to format it the result looked broken (due to some SQL syntax i think)

{"expand":"names,schema","startAt":3,"maxResults":1,"total":101,"issues":[{"expand":"operations,versionedRepresentations,editmeta,changelog,renderedFields","id":"46361","self":"https://#.atlassian.net/rest/api/3/issue/46361","key":"#-6898","fields":{"statuscategorychangedate":"2019-05-17T06:07:02.837-0500","issuetype":{"self":"https://#.atlassian.net/rest/api/3/issuetype/1","id":"1","description":"","iconUrl":"https://#.atlassian.net/secure/viewavatar?size=xsmall&avatarId=10303&avatarType=issuetype","name":"Bug","subtask":false,"avatarId":10303},"timespent":null,"project":{"self":"https://#.atlassian.net/rest/api/3/project/10000","id":"10000","key":"#","name":"#","projectTypeKey":"software","simplified":false,"avatarUrls":{"48x48":"https://#.atlassian.net/secure/projectavatar?pid=10000&avatarId=10010","24x24":"https://#.atlassian.net/secure/projectavatar?size=small&s=small&pid=10000&avatarId=10010","16x16":"https://#.atlassian.net/secure/projectavatar?size=xsmall&s=xsmall&pid=10000&avatarId=10010","32x32":"https://#.atlassian.net/secure/projectavatar?size=medium&s=medium&pid=10000&avatarId=10010"},"projectCategory":{"self":"https://#.atlassian.net/rest/api/3/projectCategory/10001","id":"10001","description":"","name":"Internal"}},"customfield_11000":null,"fixVersions":[{"self":"https://#.atlassian.net/rest/api/3/version/16156","id":"16156","description":"Major","name":"1.13","archived":false,"released":false,"releaseDate":"2019-06-24"},{"self":"https://#.atlassian.net/rest/api/3/version/16172","id":"16172","description":"Minor","name":"1.13.1","archived":false,"released":false,"releaseDate":"2019-08-26"}],"customfield_11200":null,"customfield_12411":null,"aggregatetimespent":null,"customfield_11201":null,"resolution":null,"customfield_12410":null,"customfield_11401":null,"customfield_11400":null,"customfield_10027":{"self":"https://#.atlassian.net/rest/api/3/customFieldOption/10009","value":"2 Basic","id":"10009"},"customfield_10500":null,"customfield_10501":[],"customfield_10502":null,"customfield_10700":null,"customfield_12406":{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":"text","text":"net with suffix is sorted ASC or DESC"}]}]},"customfield_12405":{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":"text","text":"Sorting works"}]}]},"customfield_10503":null,"customfield_10504":null,"customfield_12408":{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":"text","text":"Create some Layer-3 Nets with IP-Range  "}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"id":"8184a53e-cba4-4d78-85fe-843e5b7cec40","type":"file","collection":"jira-46361-customfield-73898","width":200,"height":183}}]},{"type":"paragraph","content":[{"type":"text","text":" "},{"type":"hardBreak"},{"type":"text","text":"Edit the Object-List like  "}]},{"type":"mediaSingle","attrs":{"layout":"center"},"content":[{"type":"media","attrs":{"id":"ce8a2786-5259-4ca8-b2b5-0df2a70dc326","type":"file","collection":"jira-46361-customfield-73898","width":200,"height":183}}]},{"type":"paragraph","content":[{"type":"text","text":" and save"},{"type":"hardBreak"},{"type":"text","text":"Now sort \\"net with suffix\\""}]}]},"customfield_12407":{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":"text","text":"Database error : Query error: \'SELECT obj_main.#obj_"},{"type":"text","text":"id AS \'id\', (SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE #objid = obj_main.#objid AND #objstatus = 2 ) \'#cmdb_dao_category_s_net_ip_addresses","marks":[{"type":"em"}]},{"type":"text","text":"_ip_address_link\' , (SELECT REPLACE(CONCAT(\'"}]},{"type":"paragraph","content":[{"type":"text","text":"·         \', GROUP_CONCAT((CASE WHEN IS_IPV6(#cats_net_list_"},{"type":"text","text":"address) THEN CONCAT(INET6_NTOA(INET6_ATON(#cats_net_listaddress)), \' / \', #cats_net_listcidr_suffix) WHEN IS_IPV4(#cats_net_listaddress) THEN CONCAT(INET_NTOA(INET_ATON(#cats_net_listaddress)), \' / \', #cats_net_list","marks":[{"type":"em"}]},{"type":"text","text":"_cidr_suffix) ELSE \'-\' END) SEPARATOR \'"}]},{"type":"paragraph","content":[{"type":"text","text":"·         \'), \'"}]},{"type":"paragraph","content":[{"type":"text","text":"\'), \'"}]},{"type":"paragraph","content":[{"type":"text","text":"·          "}]},{"type":"paragraph","content":[{"type":"text","text":"\', \'\') FROM #cats_net_list WHERE #cats_net_list_"},{"type":"text","text":"#objid = obj_main.#objid AND #cats_net_liststatus = 2 GROUP BY #cats_net_list#objid ) \'#cmdb_dao_category_s_netaddress_with_suffix\' , (SELECT CONCAT_WS(\' > \', (SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub5.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub4.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub3.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub2.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub1.#catg_location_list#objid = #objid)) AS title FROM #catg_location_list AS main LEFT JOIN #catg_location_list AS sub1 ON sub1.#catg_location_list#objid = main.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub2 ON sub2.#catg_location_list#objid = sub1.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub3 ON sub3.#catg_location_list#objid = sub2.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub4 ON sub4.#catg_location_list#objid = sub3.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub5 ON sub5.#catg_location_list#objid = sub4.#catg_location_listparentid WHERE main.#catg_location_list#objid = obj_main.#objid AND main.#catg_location_liststatus = 2 ) \'#cmdb_dao_category_g_locationlocation_path\' , (CONCAT(DATE_FORMAT(obj_main.#objcreated, \'%d.%m.%Y %H:%i:%s\'), \' (\' , obj_main.#objcreated_by, \')\') ) \'#cmdb_dao_category_g_globalcreated\' , (CONCAT(DATE_FORMAT(obj_main.#objupdated, \'%d.%m.%Y %H:%i:%s\'), \' (\' , obj_main.#objupdated_by, \')\') ) \'#cmdb_dao_category_g_globalchanged\' , (SELECT CONCAT(\\"{#\\", #cmdb_statuscolor, \\"} \\", #cmdb_statustitle) FROM #cmdb_status WHERE obj_main.#obj#cmdb_statusid = #cmdb_statusid AND #cmdb_statusstatus = 2 ) \'#cmdb_dao_category_g_globalcmdb_status\' FROM #obj AS obj_main WHERE TRUE AND obj_main.#obj#obj_typeid = 31 AND obj_main.#objstatus = 2 GROUP BY obj_main.#objid ORDER BY `#cats_net_listaddress_range_from_long` DESC LIMIT 0, 150\': Unknown column \'#cats_net_list","marks":[{"type":"em"}]},{"type":"text","text":"_address_range_from_long\' in \'order clause\'"}]}]},"customfield_10505":null,"resolutiondate":null,"workratio":-1,"watches":{"self":"https://#.atlassian.net/rest/api/3/issue/#-6898/watchers","watchCount":1,"isWatching":false},"lastViewed":null,"created":"2019-05-17T06:07:02.120-0500","customfield_12000":null,"customfield_12200":null,"customfield_10022":"","customfield_10100":"0|zzylwp:","priority":{"self":"https://#.atlassian.net/rest/api/3/priority/2","iconUrl":"https://#.atlassian.net/images/icons/priorities/critical.svg","name":"Sehr wichtig","id":"2"},"customfield_10024":null,"customfield_12402":null,"customfield_10026":null,"labels":["jira_escalated"],"customfield_12401":null,"customfield_11900":"{}","timeestimate":null,"aggregatetimeoriginalestimate":null,"versions":[{"self":"https://#.atlassian.net/rest/api/3/version/16182","id":"16182","description":"Minor","name":"1.12.3","archived":false,"released":true,"releaseDate":"2019-05-06"}],"issuelinks":[],"assignee":null,"updated":"2019-05-17T06:07:17.640-0500","status":{"self":"https://#.atlassian.net/rest/api/3/status/1","description":"Das Ticket ist bei uns eingegangen","iconUrl":"https://#.atlassian.net/images/icons/statuses/open.png","name":"Offen","id":"1","statusCategory":{"self":"https://#.atlassian.net/rest/api/3/statuscategory/2","id":2,"key":"new","colorName":"blue-gray","name":"Aufgaben"}},"timeoriginalestimate":null,"description":{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":"text","text":"As soon as we click on the column header \\"Net with suffix\\" [1] in the Layer 3 net, there is an error [2]."},{"type":"hardBreak"},{"type":"text","text":"The list can then no longer be displayed - there is always an error [2]."},{"type":"hardBreak"},{"type":"text","text":"A saving in the object lists configuration of \\"Layer-3-Netz\\" helps - the list is visible again."},{"type":"hardBreak"},{"type":"text","text":"Sorting again by \\"Net with Suffix\\" brings back the same situation."}]}]},"customfield_11300":"SQL error when the category \\"Layer-3 net\\" is sorted by \\"Net with suffix\\".","customfield_10401":null,"customfield_10600":null,"customfield_10601":null,"customfield_10007":null,"customfield_10008":"#-2090","aggregatetimeestimate":null,"summary":"SQL Fehler wenn die Kategorie \\"Layer-3-Netz\\" nach \\"Netz mit Suffix\\" sortiert wird","creator":{"self":"https://#.atlassian.net/rest/api/3/user?accountId=5bb37b4d7d8be513a9d0cba1","name":"mxx","key":"mxx","accountId":"5bb37b4d7d8be513a9d0cba1","emailAddress":"mxx@#.com","avatarUrls":{"48x48":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=48&s=48","24x24":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=24&s=24","16x16":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=16&s=16","32x32":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=32&s=32"},"displayName":"yy xx","active":true,"timeZone":"Europe/Berlin","accountType":"atlassian"},"subtasks":[],"reporter":{"self":"https://#.atlassian.net/rest/api/3/user?accountId=5bb37b4d7d8be513a9d0cba1","name":"mxx","key":"mxx","accountId":"5bb37b4d7d8be513a9d0cba1","emailAddress":"mxx@#.com","avatarUrls":{"48x48":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=48&s=48","24x24":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=24&s=24","16x16":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=16&s=16","32x32":"https://avatar-cdn.atlassian.com/5bb37b4d7d8be513a9d0cba1?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=32&s=32"},"displayName":"yy xx","active":true,"timeZone":"Europe/Berlin","accountType":"atlassian"},"aggregateprogress":{"progress":0,"total":0},"customfield_12100":null,"customfield_10000":null,"customfield_12301":1.0,"customfield_10001":null,"customfield_12300":{"version":1,"type":"doc","content":[{"type":"paragraph","content":[{"type":"text","text":"7535"}]}]},"customfield_10002":null,"customfield_10201":[{"self":"https://#.atlassian.net/rest/api/3/customFieldOption/10700","value":"in Changelog aufnehmen","id":"10700"}],"customfield_10400":null,"customfield_11600":null,"environment":null,"customfield_11800":{"hasEpicLinkFieldDependency":false,"showField":false,"nonEditableReason":{"reason":"PLUGIN_LICENSE_ERROR","message":"Portfolio for Jira must be licensed for the Parent Link to be available."}},"duedate":null,"progress":{"progress":0,"total":0}}}]}

edit
When limiting the output to the following, it also works:
$issues = (new IssueService($configuration))->search($jql, 0, 5, ['key', 'summary', 'created'])->issues;

[lesstif]

hi @leonardfischer .
i think that some issue's field not mapped to class mapper, but i can't decode your json data, so it's difficult to resolve.

could you send decodable json data to me via personal channel(like email) please?

[leonardfischer]

Hey @lesstif
I'm afraid I can't send you a "raw" response without blanked out values... But I can give you different formats of the decoded JSON (as stdObject and array):

$responseObject = stdClass::__set_state([
    'expand'     => 'names,schema',
    'startAt'    => 3,
    'maxResults' => 1,
    'total'      => 101,
    'issues'     => [
        0 => stdClass::__set_state([
            'expand' => 'operations,versionedRepresentations,editmeta,changelog,renderedFields',
            'id'     => '46361',
            'self'   => 'https://#.atlassian.net/rest/api/3/issue/46361',
            'key'    => '#-6898',
            'fields' => stdClass::__set_state([
                'statuscategorychangedate'      => '2019-05-17T06:07:02.837-0500',
                'issuetype'                     => stdClass::__set_state([
                    'self'        => 'https://#.atlassian.net/rest/api/3/issuetype/1',
                    'id'          => '1',
                    'description' => '',
                    'iconUrl'     => 'https://#.atlassian.net/secure/viewavatar?size=xsmall&avatarId=10303&avatarType=issuetype',
                    'name'        => 'Bug',
                    'subtask'     => false,
                    'avatarId'    => 10303,
                ]),
                'timespent'                     => null,
                'project'                       => stdClass::__set_state([
                    'self'            => 'https://#.atlassian.net/rest/api/3/project/10000',
                    'id'              => '10000',
                    'key'             => '#',
                    'name'            => '#',
                    'projectTypeKey'  => 'software',
                    'simplified'      => false,
                    'avatarUrls'      => stdClass::__set_state([
                        '48x48' => 'https://#.atlassian.net/secure/projectavatar?pid=10000&avatarId=10010',
                        '24x24' => 'https://#.atlassian.net/secure/projectavatar?size=small&s=small&pid=10000&avatarId=10010',
                        '16x16' => 'https://#.atlassian.net/secure/projectavatar?size=xsmall&s=xsmall&pid=10000&avatarId=10010',
                        '32x32' => 'https://#.atlassian.net/secure/projectavatar?size=medium&s=medium&pid=10000&avatarId=10010',
                    ]),
                    'projectCategory' => stdClass::__set_state([
                        'self'        => 'https://#.atlassian.net/rest/api/3/projectCategory/10001',
                        'id'          => '10001',
                        'description' => '',
                        'name'        => 'Internal',
                    ]),
                ]),
                'customfield_11000'             => null,
                'fixVersions'                   => [
                    0 => stdClass::__set_state([
                        'self'        => 'https://#.atlassian.net/rest/api/3/version/16156',
                        'id'          => '16156',
                        'description' => 'Major',
                        'name'        => '1.13',
                        'archived'    => false,
                        'released'    => false,
                        'releaseDate' => '2019-06-24',
                    ]),
                    1 => stdClass::__set_state([
                        'self'        => 'https://#.atlassian.net/rest/api/3/version/16172',
                        'id'          => '16172',
                        'description' => 'Minor',
                        'name'        => '1.13.1',
                        'archived'    => false,
                        'released'    => false,
                        'releaseDate' => '2019-08-26',
                    ]),
                ],
                'customfield_11200'             => null,
                'customfield_12411'             => null,
                'aggregatetimespent'            => null,
                'customfield_12410'             => null,
                'resolution'                    => null,
                'customfield_11201'             => null,
                'customfield_11401'             => null,
                'customfield_11400'             => null,
                'customfield_10500'             => null,
                'customfield_10027'             => stdClass::__set_state([
                    'self'  => 'https://#.atlassian.net/rest/api/3/customFieldOption/10009',
                    'value' => '2 Basic',
                    'id'    => '10009',
                ]),
                'customfield_10501'             => [],
                'customfield_10502'             => null,
                'customfield_10700'             => null,
                'customfield_12406'             => stdClass::__set_state([
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'net with suffix is sorted ASC or DESC',
                                ]),
                            ],
                        ]),
                    ],
                ]),
                'customfield_12405'             => stdClass::__set_state([
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'Sorting works',
                                ]),
                            ],
                        ]),
                    ],
                ]),
                'customfield_10503'             => null,
                'customfield_10504'             => null,
                'customfield_12408'             => stdClass::__set_state([
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'Create some Layer-3 Nets with IP-Range  ',
                                ]),
                            ],
                        ]),
                        1 => stdClass::__set_state([
                            'type'    => 'mediaSingle',
                            'attrs'   => stdClass::__set_state(['layout' => 'center',]),
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type'  => 'media',
                                    'attrs' => stdClass::__set_state([
                                        'id'         => '8184a53e-cba4-4d78-85fe-843e5b7cec40',
                                        'type'       => 'file',
                                        'collection' => 'jira-46361-customfield-73898',
                                        'width'      => 200,
                                        'height'     => 183,
                                    ]),
                                ]),
                            ],
                        ]),
                        2 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => ' ',
                                ]),
                                1 => stdClass::__set_state(['type' => 'hardBreak',]),
                                2 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'Edit the Object-List like  ',
                                ]),
                            ],
                        ]),
                        3 => stdClass::__set_state([
                            'type'    => 'mediaSingle',
                            'attrs'   => stdClass::__set_state(['layout' => 'center',]),
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type'  => 'media',
                                    'attrs' => stdClass::__set_state([
                                        'id'         => 'ce8a2786-5259-4ca8-b2b5-0df2a70dc326',
                                        'type'       => 'file',
                                        'collection' => 'jira-46361-customfield-73898',
                                        'width'      => 200,
                                        'height'     => 183,
                                    ]),
                                ]),
                            ],
                        ]),
                        4 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => ' and save',
                                ]),
                                1 => stdClass::__set_state(['type' => 'hardBreak',]),
                                2 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'Now sort "net with suffix"',
                                ]),
                            ],
                        ]),
                    ],
                ]),
                'customfield_10505'             => null,
                'customfield_12407'             => stdClass::__set_state([
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'Database error : Query error: \'SELECT obj_main.#obj_',
                                ]),
                                1 => stdClass::__set_state([
                                    'type'  => 'text',
                                    'text'  => 'id AS \'id\', (SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE #objid = obj_main.#objid AND #objstatus = 2 ) \'#cmdb_dao_category_s_net_ip_addresses',
                                    'marks' => [0 => stdClass::__set_state(['type' => 'em',]),],
                                ]),
                                2 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '_ip_address_link\' , (SELECT REPLACE(CONCAT(\'',
                                ]),
                            ],
                        ]),
                        1 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '·         \', GROUP_CONCAT((CASE WHEN IS_IPV6(#cats_net_list_',
                                ]),
                                1 => stdClass::__set_state([
                                    'type'  => 'text',
                                    'text'  => 'address) THEN CONCAT(INET6_NTOA(INET6_ATON(#cats_net_listaddress)), \' / \', #cats_net_listcidr_suffix) WHEN IS_IPV4(#cats_net_listaddress) THEN CONCAT(INET_NTOA(INET_ATON(#cats_net_listaddress)), \' / \', #cats_net_list',
                                    'marks' => [0 => stdClass::__set_state(['type' => 'em',]),],
                                ]),
                                2 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '_cidr_suffix) ELSE \'-\' END) SEPARATOR \'',
                                ]),
                            ],
                        ]),
                        2 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '·         \'), \'',
                                ]),
                            ],
                        ]),
                        3 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '\'), \'',
                                ]),
                            ],
                        ]),
                        4 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '·          ',
                                ]),
                            ],
                        ]),
                        5 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '\', \'\') FROM #cats_net_list WHERE #cats_net_list_',
                                ]),
                                1 => stdClass::__set_state([
                                    'type'  => 'text',
                                    'text'  => '#objid = obj_main.#objid AND #cats_net_liststatus = 2 GROUP BY #cats_net_list#objid ) \'#cmdb_dao_category_s_netaddress_with_suffix\' , (SELECT CONCAT_WS(\' > \', (SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub5.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub4.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub3.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub2.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub1.#catg_location_list#objid = #objid)) AS title FROM #catg_location_list AS main LEFT JOIN #catg_location_list AS sub1 ON sub1.#catg_location_list#objid = main.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub2 ON sub2.#catg_location_list#objid = sub1.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub3 ON sub3.#catg_location_list#objid = sub2.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub4 ON sub4.#catg_location_list#objid = sub3.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub5 ON sub5.#catg_location_list#objid = sub4.#catg_location_listparentid WHERE main.#catg_location_list#objid = obj_main.#objid AND main.#catg_location_liststatus = 2 ) \'#cmdb_dao_category_g_locationlocation_path\' , (CONCAT(DATE_FORMAT(obj_main.#objcreated, \'%d.%m.%Y %H:%i:%s\'), \' (\' , obj_main.#objcreated_by, \')\') ) \'#cmdb_dao_category_g_globalcreated\' , (CONCAT(DATE_FORMAT(obj_main.#objupdated, \'%d.%m.%Y %H:%i:%s\'), \' (\' , obj_main.#objupdated_by, \')\') ) \'#cmdb_dao_category_g_globalchanged\' , (SELECT CONCAT("{#", #cmdb_statuscolor, "} ", #cmdb_statustitle) FROM #cmdb_status WHERE obj_main.#obj#cmdb_statusid = #cmdb_statusid AND #cmdb_statusstatus = 2 ) \'#cmdb_dao_category_g_globalcmdb_status\' FROM #obj AS obj_main WHERE TRUE AND obj_main.#obj#obj_typeid = 31 AND obj_main.#objstatus = 2 GROUP BY obj_main.#objid ORDER BY `#cats_net_listaddress_range_from_long` DESC LIMIT 0, 150\': Unknown column \'#cats_net_list',
                                    'marks' => [0 => stdClass::__set_state(['type' => 'em',]),],
                                ]),
                                2 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '_address_range_from_long\' in \'order clause\'',
                                ]),
                            ],
                        ]),
                    ],
                ]),
                'resolutiondate'                => null,
                'workratio'                     => -1,
                'watches'                       => stdClass::__set_state([
                    'self'       => 'https://#.atlassian.net/rest/api/3/issue/#-6898/watchers',
                    'watchCount' => 1,
                    'isWatching' => false,
                ]),
                'lastViewed'                    => null,
                'created'                       => '2019-05-17T06:07:02.120-0500',
                'customfield_12000'             => null,
                'customfield_12200'             => null,
                'customfield_10022'             => '',
                'priority'                      => stdClass::__set_state([
                    'self'    => 'https://#.atlassian.net/rest/api/3/priority/2',
                    'iconUrl' => 'https://#.atlassian.net/images/icons/priorities/critical.svg',
                    'name'    => 'Sehr wichtig',
                    'id'      => '2',
                ]),
                'customfield_10100'             => '0|zzylwp:',
                'customfield_10024'             => null,
                'customfield_12402'             => null,
                'labels'                        => [0 => 'jira_escalated',],
                'customfield_10026'             => null,
                'customfield_12401'             => null,
                'customfield_11900'             => '{}',
                'aggregatetimeoriginalestimate' => null,
                'timeestimate'                  => null,
                'versions'                      => [
                    0 => stdClass::__set_state([
                        'self'        => 'https://#.atlassian.net/rest/api/3/version/16182',
                        'id'          => '16182',
                        'description' => 'Minor',
                        'name'        => '1.12.3',
                        'archived'    => false,
                        'released'    => true,
                        'releaseDate' => '2019-05-06',
                    ]),
                ],
                'issuelinks'                    => [],
                'assignee'                      => null,
                'updated'                       => '2019-05-17T06:07:17.640-0500',
                'status'                        => stdClass::__set_state([
                    'self'           => 'https://#.atlassian.net/rest/api/3/status/1',
                    'description'    => 'Das Ticket ist bei uns eingegangen',
                    'iconUrl'        => 'https://#.atlassian.net/images/icons/statuses/open.png',
                    'name'           => 'Offen',
                    'id'             => '1',
                    'statusCategory' => stdClass::__set_state([
                        'self'      => 'https://#.atlassian.net/rest/api/3/statuscategory/2',
                        'id'        => 2,
                        'key'       => 'new',
                        'colorName' => 'blue-gray',
                        'name'      => 'Aufgaben',
                    ]),
                ]),
                'timeoriginalestimate'          => null,
                'description'                   => stdClass::__set_state([
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'As soon as we click on the column header "Net with suffix" [1] in the Layer 3 net, there is an error [2].',
                                ]),
                                1 => stdClass::__set_state(['type' => 'hardBreak',]),
                                2 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'The list can then no longer be displayed - there is always an error [2].',
                                ]),
                                3 => stdClass::__set_state(['type' => 'hardBreak',]),
                                4 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'A saving in the object lists configuration of "Layer-3-Netz" helps - the list is visible again.',
                                ]),
                                5 => stdClass::__set_state(['type' => 'hardBreak',]),
                                6 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => 'Sorting again by "Net with Suffix" brings back the same situation.',
                                ]),
                            ],
                        ]),
                    ],
                ]),
                'customfield_11300'             => 'SQL error when the category "Layer-3 net" is sorted by "Net with suffix".',
                'customfield_10401'             => null,
                'customfield_10600'             => null,
                'customfield_10007'             => null,
                'customfield_10601'             => null,
                'customfield_10008'             => '#-2090',
                'aggregatetimeestimate'         => null,
                'summary'                       => 'SQL Fehler wenn die Kategorie "Layer-3-Netz" nach "Netz mit Suffix" sortiert wird',
                'creator'                       => stdClass::__set_state([
                    'self'         => 'https://#.atlassian.net/rest/api/3/user?accountId=abc',
                    'name'         => 'mbb',
                    'key'          => 'mbb',
                    'accountId'    => 'abc',
                    'emailAddress' => 'mbb@#.com',
                    'avatarUrls'   => stdClass::__set_state([
                        '48x48' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=48&s=48',
                        '24x24' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=24&s=24',
                        '16x16' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=16&s=16',
                        '32x32' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=32&s=32',
                    ]),
                    'displayName'  => 'aa bb',
                    'active'       => true,
                    'timeZone'     => 'Europe/Berlin',
                    'accountType'  => 'atlassian',
                ]),
                'subtasks'                      => [],
                'reporter'                      => stdClass::__set_state([
                    'self'         => 'https://#.atlassian.net/rest/api/3/user?accountId=abc',
                    'name'         => 'mbb',
                    'key'          => 'mbb',
                    'accountId'    => 'abc',
                    'emailAddress' => 'mbb@#.com',
                    'avatarUrls'   => stdClass::__set_state([
                        '48x48' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=48&s=48',
                        '24x24' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=24&s=24',
                        '16x16' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=16&s=16',
                        '32x32' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=32&s=32',
                    ]),
                    'displayName'  => 'aa bb',
                    'active'       => true,
                    'timeZone'     => 'Europe/Berlin',
                    'accountType'  => 'atlassian',
                ]),
                'aggregateprogress'             => stdClass::__set_state(['progress' => 0, 'total' => 0,]),
                'customfield_12100'             => null,
                'customfield_10000'             => null,
                'customfield_10001'             => null,
                'customfield_12301'             => 1.0,
                'customfield_12300'             => stdClass::__set_state([
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => stdClass::__set_state([
                            'type'    => 'paragraph',
                            'content' => [
                                0 => stdClass::__set_state([
                                    'type' => 'text',
                                    'text' => '7535',
                                ]),
                            ],
                        ]),
                    ],
                ]),
                'customfield_10002'             => null,
                'customfield_10201'             => [
                    0 => stdClass::__set_state([
                        'self'  => 'https://#.atlassian.net/rest/api/3/customFieldOption/10700',
                        'value' => 'in Changelog aufnehmen',
                        'id'    => '10700',
                    ]),
                ],
                'customfield_10400'             => null,
                'customfield_11600'             => null,
                'environment'                   => null,
                'customfield_11800'             => stdClass::__set_state([
                    'hasEpicLinkFieldDependency' => false,
                    'showField'                  => false,
                    'nonEditableReason'          => stdClass::__set_state([
                        'reason'  => 'PLUGIN_LICENSE_ERROR',
                        'message' => 'Portfolio for Jira must be licensed for the Parent Link to be available.',
                    ]),
                ]),
                'duedate'                       => null,
                'progress'                      => stdClass::__set_state(['progress' => 0, 'total' => 0,]),
            ]),
        ]),
    ],
]);

A array

$responseArray = [
    'expand'     => 'names,schema',
    'startAt'    => 3,
    'maxResults' => 1,
    'total'      => 101,
    'issues'     => [
        0 => [
            'expand' => 'operations,versionedRepresentations,editmeta,changelog,renderedFields',
            'id'     => '46361',
            'self'   => 'https://#.atlassian.net/rest/api/3/issue/46361',
            'key'    => '#-6898',
            'fields' => [
                'statuscategorychangedate'      => '2019-05-17T06:07:02.837-0500',
                'issuetype'                     => [
                    'self'        => 'https://#.atlassian.net/rest/api/3/issuetype/1',
                    'id'          => '1',
                    'description' => '',
                    'iconUrl'     => 'https://#.atlassian.net/secure/viewavatar?size=xsmall&avatarId=10303&avatarType=issuetype',
                    'name'        => 'Bug',
                    'subtask'     => false,
                    'avatarId'    => 10303,
                ],
                'timespent'                     => null,
                'project'                       => [
                    'self'            => 'https://#.atlassian.net/rest/api/3/project/10000',
                    'id'              => '10000',
                    'key'             => '#',
                    'name'            => '#',
                    'projectTypeKey'  => 'software',
                    'simplified'      => false,
                    'avatarUrls'      => [
                        '48x48' => 'https://#.atlassian.net/secure/projectavatar?pid=10000&avatarId=10010',
                        '24x24' => 'https://#.atlassian.net/secure/projectavatar?size=small&s=small&pid=10000&avatarId=10010',
                        '16x16' => 'https://#.atlassian.net/secure/projectavatar?size=xsmall&s=xsmall&pid=10000&avatarId=10010',
                        '32x32' => 'https://#.atlassian.net/secure/projectavatar?size=medium&s=medium&pid=10000&avatarId=10010',
                    ],
                    'projectCategory' => [
                        'self'        => 'https://#.atlassian.net/rest/api/3/projectCategory/10001',
                        'id'          => '10001',
                        'description' => '',
                        'name'        => 'Internal',
                    ],
                ],
                'customfield_11000'             => null,
                'fixVersions'                   => [
                    0 => [
                        'self'        => 'https://#.atlassian.net/rest/api/3/version/16156',
                        'id'          => '16156',
                        'description' => 'Major',
                        'name'        => '1.13',
                        'archived'    => false,
                        'released'    => false,
                        'releaseDate' => '2019-06-24',
                    ],
                    1 => [
                        'self'        => 'https://#.atlassian.net/rest/api/3/version/16172',
                        'id'          => '16172',
                        'description' => 'Minor',
                        'name'        => '1.13.1',
                        'archived'    => false,
                        'released'    => false,
                        'releaseDate' => '2019-08-26',
                    ],
                ],
                'customfield_11200'             => null,
                'customfield_12411'             => null,
                'aggregatetimespent'            => null,
                'customfield_12410'             => null,
                'resolution'                    => null,
                'customfield_11201'             => null,
                'customfield_11401'             => null,
                'customfield_11400'             => null,
                'customfield_10500'             => null,
                'customfield_10027'             => [
                    'self'  => 'https://#.atlassian.net/rest/api/3/customFieldOption/10009',
                    'value' => '2 Basic',
                    'id'    => '10009',
                ],
                'customfield_10501'             => [],
                'customfield_10502'             => null,
                'customfield_10700'             => null,
                'customfield_12406'             => [
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => 'net with suffix is sorted ASC or DESC',
                                ],
                            ],
                        ],
                    ],
                ],
                'customfield_12405'             => [
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => 'Sorting works',
                                ],
                            ],
                        ],
                    ],
                ],
                'customfield_10503'             => null,
                'customfield_10504'             => null,
                'customfield_12408'             => [
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => 'Create some Layer-3 Nets with IP-Range  ',
                                ],
                            ],
                        ],
                        1 => [
                            'type'    => 'mediaSingle',
                            'attrs'   => ['layout' => 'center',],
                            'content' => [
                                0 => [
                                    'type'  => 'media',
                                    'attrs' => [
                                        'id'         => '8184a53e-cba4-4d78-85fe-843e5b7cec40',
                                        'type'       => 'file',
                                        'collection' => 'jira-46361-customfield-73898',
                                        'width'      => 200,
                                        'height'     => 183,
                                    ],
                                ],
                            ],
                        ],
                        2 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => ['type' => 'text', 'text' => ' ',],
                                1 => ['type' => 'hardBreak',],
                                2 => ['type' => 'text', 'text' => 'Edit the Object-List like  ',],
                            ],
                        ],
                        3 => [
                            'type'    => 'mediaSingle',
                            'attrs'   => ['layout' => 'center',],
                            'content' => [
                                0 => [
                                    'type'  => 'media',
                                    'attrs' => [
                                        'id'         => 'ce8a2786-5259-4ca8-b2b5-0df2a70dc326',
                                        'type'       => 'file',
                                        'collection' => 'jira-46361-customfield-73898',
                                        'width'      => 200,
                                        'height'     => 183,
                                    ],
                                ],
                            ],
                        ],
                        4 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => ['type' => 'text', 'text' => ' and save',],
                                1 => ['type' => 'hardBreak',],
                                2 => ['type' => 'text', 'text' => 'Now sort "net with suffix"',],
                            ],
                        ],
                    ],
                ],
                'customfield_10505'             => null,
                'customfield_12407'             => [
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => 'Database error : Query error: \'SELECT obj_main.#obj_',
                                ],
                                1 => [
                                    'type'  => 'text',
                                    'text'  => 'id AS \'id\', (SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE #objid = obj_main.#objid AND #objstatus = 2 ) \'#cmdb_dao_category_s_net_ip_addresses',
                                    'marks' => [0 => ['type' => 'em',],],
                                ],
                                2 => [
                                    'type' => 'text',
                                    'text' => '_ip_address_link\' , (SELECT REPLACE(CONCAT(\'',
                                ],
                            ],
                        ],
                        1 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => '·         \', GROUP_CONCAT((CASE WHEN IS_IPV6(#cats_net_list_',
                                ],
                                1 => [
                                    'type'  => 'text',
                                    'text'  => 'address) THEN CONCAT(INET6_NTOA(INET6_ATON(#cats_net_listaddress)), \' / \', #cats_net_listcidr_suffix) WHEN IS_IPV4(#cats_net_listaddress) THEN CONCAT(INET_NTOA(INET_ATON(#cats_net_listaddress)), \' / \', #cats_net_list',
                                    'marks' => [0 => ['type' => 'em',],],
                                ],
                                2 => [
                                    'type' => 'text',
                                    'text' => '_cidr_suffix) ELSE \'-\' END) SEPARATOR \'',
                                ],
                            ],
                        ],
                        2 => [
                            'type'    => 'paragraph',
                            'content' => [0 => ['type' => 'text', 'text' => '·         \'), \'',],],
                        ],
                        3 => ['type' => 'paragraph', 'content' => [0 => ['type' => 'text', 'text' => '\'), \'',],],],
                        4 => [
                            'type'    => 'paragraph',
                            'content' => [0 => ['type' => 'text', 'text' => '·          ',],],
                        ],
                        5 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => '\', \'\') FROM #cats_net_list WHERE #cats_net_list_',
                                ],
                                1 => [
                                    'type'  => 'text',
                                    'text'  => '#objid = obj_main.#objid AND #cats_net_liststatus = 2 GROUP BY #cats_net_list#objid ) \'#cmdb_dao_category_s_netaddress_with_suffix\' , (SELECT CONCAT_WS(\' > \', (SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub5.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub4.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub3.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub2.#catg_location_list#objid = #objid),(SELECT CONCAT(#objtitle, \' {\', #objid, \'}\') FROM #obj WHERE sub1.#catg_location_list#objid = #objid)) AS title FROM #catg_location_list AS main LEFT JOIN #catg_location_list AS sub1 ON sub1.#catg_location_list#objid = main.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub2 ON sub2.#catg_location_list#objid = sub1.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub3 ON sub3.#catg_location_list#objid = sub2.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub4 ON sub4.#catg_location_list#objid = sub3.#catg_location_listparentid LEFT JOIN #catg_location_list AS sub5 ON sub5.#catg_location_list#objid = sub4.#catg_location_listparentid WHERE main.#catg_location_list#objid = obj_main.#objid AND main.#catg_location_liststatus = 2 ) \'#cmdb_dao_category_g_locationlocation_path\' , (CONCAT(DATE_FORMAT(obj_main.#objcreated, \'%d.%m.%Y %H:%i:%s\'), \' (\' , obj_main.#objcreated_by, \')\') ) \'#cmdb_dao_category_g_globalcreated\' , (CONCAT(DATE_FORMAT(obj_main.#objupdated, \'%d.%m.%Y %H:%i:%s\'), \' (\' , obj_main.#objupdated_by, \')\') ) \'#cmdb_dao_category_g_globalchanged\' , (SELECT CONCAT("{#", #cmdb_statuscolor, "} ", #cmdb_statustitle) FROM #cmdb_status WHERE obj_main.#obj#cmdb_statusid = #cmdb_statusid AND #cmdb_statusstatus = 2 ) \'#cmdb_dao_category_g_globalcmdb_status\' FROM #obj AS obj_main WHERE TRUE AND obj_main.#obj#obj_typeid = 31 AND obj_main.#objstatus = 2 GROUP BY obj_main.#objid ORDER BY `#cats_net_listaddress_range_from_long` DESC LIMIT 0, 150\': Unknown column \'#cats_net_list',
                                    'marks' => [0 => ['type' => 'em',],],
                                ],
                                2 => ['type' => 'text', 'text' => '_address_range_from_long\' in \'order clause\'',],
                            ],
                        ],
                    ],
                ],
                'resolutiondate'                => null,
                'workratio'                     => -1,
                'watches'                       => [
                    'self'       => 'https://#.atlassian.net/rest/api/3/issue/#-6898/watchers',
                    'watchCount' => 1,
                    'isWatching' => false,
                ],
                'lastViewed'                    => null,
                'created'                       => '2019-05-17T06:07:02.120-0500',
                'customfield_12000'             => null,
                'customfield_12200'             => null,
                'customfield_10022'             => '',
                'priority'                      => [
                    'self'    => 'https://#.atlassian.net/rest/api/3/priority/2',
                    'iconUrl' => 'https://#.atlassian.net/images/icons/priorities/critical.svg',
                    'name'    => 'Sehr wichtig',
                    'id'      => '2',
                ],
                'customfield_10100'             => '0|zzylwp:',
                'customfield_10024'             => null,
                'customfield_12402'             => null,
                'labels'                        => [0 => 'jira_escalated',],
                'customfield_10026'             => null,
                'customfield_12401'             => null,
                'customfield_11900'             => '{}',
                'aggregatetimeoriginalestimate' => null,
                'timeestimate'                  => null,
                'versions'                      => [
                    0 => [
                        'self'        => 'https://#.atlassian.net/rest/api/3/version/16182',
                        'id'          => '16182',
                        'description' => 'Minor',
                        'name'        => '1.12.3',
                        'archived'    => false,
                        'released'    => true,
                        'releaseDate' => '2019-05-06',
                    ],
                ],
                'issuelinks'                    => [],
                'assignee'                      => null,
                'updated'                       => '2019-05-17T06:07:17.640-0500',
                'status'                        => [
                    'self'           => 'https://#.atlassian.net/rest/api/3/status/1',
                    'description'    => 'Das Ticket ist bei uns eingegangen',
                    'iconUrl'        => 'https://#.atlassian.net/images/icons/statuses/open.png',
                    'name'           => 'Offen',
                    'id'             => '1',
                    'statusCategory' => [
                        'self'      => 'https://#.atlassian.net/rest/api/3/statuscategory/2',
                        'id'        => 2,
                        'key'       => 'new',
                        'colorName' => 'blue-gray',
                        'name'      => 'Aufgaben',
                    ],
                ],
                'timeoriginalestimate'          => null,
                'description'                   => [
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => 'As soon as we click on the column header "Net with suffix" [1] in the Layer 3 net, there is an error [2].',
                                ],
                                1 => ['type' => 'hardBreak',],
                                2 => [
                                    'type' => 'text',
                                    'text' => 'The list can then no longer be displayed - there is always an error [2].',
                                ],
                                3 => ['type' => 'hardBreak',],
                                4 => [
                                    'type' => 'text',
                                    'text' => 'A saving in the object lists configuration of "Layer-3-Netz" helps - the list is visible again.',
                                ],
                                5 => ['type' => 'hardBreak',],
                                6 => [
                                    'type' => 'text',
                                    'text' => 'Sorting again by "Net with Suffix" brings back the same situation.',
                                ],
                            ],
                        ],
                    ],
                ],
                'customfield_11300'             => 'SQL error when the category "Layer-3 net" is sorted by "Net with suffix".',
                'customfield_10401'             => null,
                'customfield_10600'             => null,
                'customfield_10007'             => null,
                'customfield_10601'             => null,
                'customfield_10008'             => '#-2090',
                'aggregatetimeestimate'         => null,
                'summary'                       => 'SQL Fehler wenn die Kategorie "Layer-3-Netz" nach "Netz mit Suffix" sortiert wird',
                'creator'                       => [
                    'self'         => 'https://#.atlassian.net/rest/api/3/user?accountId=abc',
                    'name'         => 'mbb',
                    'key'          => 'mbb',
                    'accountId'    => 'abc',
                    'emailAddress' => 'mbb@#.com',
                    'avatarUrls'   => [
                        '48x48' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=48&s=48',
                        '24x24' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=24&s=24',
                        '16x16' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=16&s=16',
                        '32x32' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=32&s=32',
                    ],
                    'displayName'  => 'aa bb',
                    'active'       => true,
                    'timeZone'     => 'Europe/Berlin',
                    'accountType'  => 'atlassian',
                ],
                'subtasks'                      => [],
                'reporter'                      => [
                    'self'         => 'https://#.atlassian.net/rest/api/3/user?accountId=abc',
                    'name'         => 'mbb',
                    'key'          => 'mbb',
                    'accountId'    => 'abc',
                    'emailAddress' => 'mbb@#.com',
                    'avatarUrls'   => [
                        '48x48' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=48&s=48',
                        '24x24' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=24&s=24',
                        '16x16' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=16&s=16',
                        '32x32' => 'https://avatar-cdn.atlassian.com/abc?by=id&sg=b5d5BQmaatNuV%2F2SuDmDWlO3tFA%3D&d=https%3A%2F%2Favatar-management--avatars.us-west-2.prod.public.atl-paas.net%2Finitials%2FMH-5.png&size=32&s=32',
                    ],
                    'displayName'  => 'aa bb',
                    'active'       => true,
                    'timeZone'     => 'Europe/Berlin',
                    'accountType'  => 'atlassian',
                ],
                'aggregateprogress'             => ['progress' => 0, 'total' => 0,],
                'customfield_12100'             => null,
                'customfield_10000'             => null,
                'customfield_10001'             => null,
                'customfield_12301'             => 1.0,
                'customfield_12300'             => [
                    'version' => 1,
                    'type'    => 'doc',
                    'content' => [
                        0 => [
                            'type'    => 'paragraph',
                            'content' => [
                                0 => [
                                    'type' => 'text',
                                    'text' => '7535',
                                ],
                            ],
                        ],
                    ],
                ],
                'customfield_10002'             => null,
                'customfield_10201'             => [
                    0 => [
                        'self'  => 'https://#.atlassian.net/rest/api/3/customFieldOption/10700',
                        'value' => 'in Changelog aufnehmen',
                        'id'    => '10700',
                    ],
                ],
                'customfield_10400'             => null,
                'customfield_11600'             => null,
                'environment'                   => null,
                'customfield_11800'             => [
                    'hasEpicLinkFieldDependency' => false,
                    'showField'                  => false,
                    'nonEditableReason'          => [
                        'reason'  => 'PLUGIN_LICENSE_ERROR',
                        'message' => 'Portfolio for Jira must be licensed for the Parent Link to be available.',
                    ],
                ],
                'duedate'                       => null,
                'progress'                      => ['progress' => 0, 'total' => 0,],
            ],
        ],
    ],
];

I do hope you can reproduce / fix the error with this data :(

[lesstif]

hi @leonardfischer

are you use JIRA major version is greater than 8.0?

According to the atlassian doc's, JIRA 8.0 to supply Version 3 REST API and comment field type changed to complicated structure.

so i think that the json decoding error occurs comment type mapping operation.

[leonardfischer]

Hi @lesstif

sorry, that was the one important information I forgot to mention: we use Jira Cloud :) I already switched the API Client to use the V3 Rest API. But still I'm wondering: everything seems to work when I use the previous version (1.37).
I didn't really compare what changed in these versions - but could it possibly have an impact here?

[lesstif]

hi @leonardfischer

i'm pushed issue search function for V3 API into develop branch, could you pull it and test please?

composer.json

"require": {
   "lesstif/php-jira-rest-client" : "dev-develop"
   ....
}

.env

JIRA_REST_API_V3=true

P.S sorry, i'm not use JIRA cloud and just use JIRA stanalone 7, so i can't confirm this feature working correctly.

[leonardfischer]

Hi @lesstif

thanks a lot for the fast bugfix - it seems to work just fine now :) I got no errors or anything, the search worked as expected!

Great work!

[lesstif]

hi @leonardfischer

thanks! i will release new version now.