lesstif
commented
5 years ago hi @leonardfischer
i'm sorry, i can't reproduced it. could you show me the server's response json when an exception occurs please?
Closed leonardfischer closed 5 years ago
lesstif
commented
5 years ago 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
commented
5 years ago 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
commented
5 years ago 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
commented
5 years ago 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
commented
5 years ago 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
commented
5 years ago 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
commented
5 years ago 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=trueP.S sorry, i'm not use JIRA cloud and just use JIRA stanalone 7, so i can't confirm this feature working correctly.
leonardfischer
commented
5 years ago 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
commented
5 years ago hi @leonardfischer
thanks! i will release new version now.
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):
Results in
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/jsonmapperbut I saw there hasn't been any release in the last years.