{"data":{"id":"magento2-38264","source":"github-pr","sourceRef":"magento/magento2#38264","title":"customer Orders query shipment comments created_at is returned in +0 timezone not in store configured timezone","pr":{"number":38264,"url":"https://github.com/magento/magento2/pull/38264","author":"Bartlomiejsz","mergedAt":"2025-01-07T15:54:40Z","mergeCommit":"5c92841bbb4068263d985f8cdd87e35036022962","headCommit":"6f63a4e3c4f6d48e988fb02a1575b53ba7e661b0","baseRef":"2.4-develop","diffSha256":"5baf7201c8bde3ee4f3527ed907c68fae6446e9fdf8366e0bbc3adee3a63b1cf"},"issues":[{"number":36947,"url":"https://github.com/magento/magento2/issues/36947","title":"customer Orders query shipment comments created_at is returned in +0 timezone not in store configured timezone","labels":["Area: Admin UI","Issue: Confirmed","Priority: P2","Progress: done","Project: GraphQL","Reported on 2.4.x","Reproduced on 2.4.x"],"kind":"human"}],"fixedIn":"2.4.8","containingTags":["2.4.8","2.4.8-p1","2.4.8-p2","2.4.8-p3","2.4.8-p4","2.4.8-p5","2.4.9"],"reportedOn":null,"codeMatch":{"2.4.6":"conflict","2.4.6-p1":"conflict","2.4.6-p2":"conflict","2.4.6-p3":"conflict","2.4.6-p4":"conflict","2.4.6-p5":"conflict","2.4.6-p6":"conflict","2.4.6-p7":"conflict","2.4.6-p8":"conflict","2.4.6-p9":"conflict","2.4.6-p10":"conflict","2.4.6-p11":"conflict","2.4.6-p12":"conflict","2.4.6-p13":"conflict","2.4.6-p14":"conflict","2.4.6-p15":"conflict","2.4.7":"clean","2.4.7-p1":"clean","2.4.7-p2":"clean","2.4.7-p3":"clean","2.4.7-p4":"clean","2.4.7-p5":"clean","2.4.7-p6":"clean","2.4.7-p7":"clean","2.4.7-p8":"clean","2.4.7-p9":"clean","2.4.7-p10":"clean","2.4.8":"conflict","2.4.8-p1":"conflict","2.4.8-p2":"conflict","2.4.8-p3":"conflict","2.4.8-p4":"conflict","2.4.8-p5":"conflict","2.4.9":"conflict"},"affectedVersions":["2.4.7","2.4.7-p1","2.4.7-p2","2.4.7-p3","2.4.7-p4","2.4.7-p5","2.4.7-p6","2.4.7-p7","2.4.7-p8","2.4.7-p9","2.4.7-p10"],"components":["magento/module-sales-graph-ql"],"files":[{"path":"app/code/Magento/SalesGraphQl/Model/Formatter/Order.php","change":"modified","package":"magento/module-sales-graph-ql"},{"path":"app/code/Magento/SalesGraphQl/Model/Resolver/CreditMemo/CreditMemoComments.php","change":"modified","package":"magento/module-sales-graph-ql"},{"path":"app/code/Magento/SalesGraphQl/Model/Resolver/Invoices.php","change":"modified","package":"magento/module-sales-graph-ql"},{"path":"app/code/Magento/SalesGraphQl/Model/Resolver/Shipments.php","change":"modified","package":"magento/module-sales-graph-ql"}],"stripped":{"tests":["dev/tests/api-functional/testsuite/Magento/GraphQl/Sales/RetrieveOrdersByOrderNumberTest.php"],"docs":[],"outsideCode":[]},"linesChanged":72,"mergeBatched":false,"excluded":null,"sections":{"description":"The actual result is that the time from view is right in our timezone, and in query it is in +0 timezone","stepsToReproduce":"1. Configure your store with a timezone different from +0\n2. Create a Shipment with a comment\n3. Verify the comment created_at in the normal view phtml in the website\n4. Call customer Orders query and check created_at field from shipment comment","expectedResult":"The expected result is that the time from both view and query be the same and in our configured timezone","actualResult":"The actual result is that the time from view is right in our timezone, and in query it is in +0 timezone","source":"issue"},"signatures":[],"labels":{"area":["Admin UI"],"component":[],"priority":"P2","severity":null,"reportedOn":["2.4.x"]},"categories":[],"triage":{"model":"@cf/cloudflare/clef","requestHash":"372a4f21877006b0ccf40e8c95769e91754c9a8ecd087cbfe308b1fc81b22a60","isBugfix":0.9752,"changeKind":{"choice":"bugfix","probabilities":{"bugfix":0.9683,"feature":0.0042,"refactor":0.0084,"tests_only":0.0069,"docs_only":0.0026,"dependency":0.0026,"cleanup":0.007},"confidence":0.9273},"scope":{"score":1.1462,"probabilities":{"0":0.1831,"1":0.4875,"2":0.3294},"confidence":0.0695},"risk":{"score":0.4668,"probabilities":{"0":0.6023,"1":0.3287,"2":0.069},"confidence":0.2133},"area":{"choice":"graphql_api","probabilities":{"catalog":0.0035,"checkout":0.0247,"customer":0.0282,"admin":0.0095,"graphql_api":0.9148,"framework":0.0072,"frontend":0.0056,"other":0.0065},"confidence":0.8154},"securityRelevant":0.0062,"reportedVersion":{"choice":"unspecified","probabilities":{"2.4.0":0.0078,"2.4.0-p1":0.0044,"2.4.1":0.0035,"2.4.1-p1":0.0031,"2.4.2":0.0049,"2.4.2-p1":0.004,"2.4.2-p2":0.0059,"2.4.3":0.0099,"2.4.3-p1":0.0073,"2.4.3-p2":0.0082,"2.4.3-p3":0.0054,"2.4.4":0.0083,"2.4.4-p1":0.0052,"2.4.4-p10":0.0044,"2.4.4-p11":0.0054,"2.4.4-p12":0.0046,"2.4.4-p13":0.0043,"2.4.4-p14":0.0055,"2.4.4-p15":0.0044,"2.4.4-p16":0.005,"2.4.4-p17":0.004,"2.4.4-p18":0.0041,"2.4.4-p2":0.0028,"2.4.4-p3":0.0034,"2.4.4-p4":0.0032,"2.4.4-p5":0.0032,"2.4.4-p6":0.0038,"2.4.4-p7":0.0042,"2.4.4-p8":0.0036,"2.4.4-p9":0.0031,"2.4.5":0.007,"2.4.5-p1":0.0058,"2.4.5-p10":0.0046,"2.4.5-p11":0.0065,"2.4.5-p12":0.0069,"2.4.5-p13":0.005,"2.4.5-p14":0.0052,"2.4.5-p15":0.0047,"2.4.5-p16":0.005,"2.4.5-p17":0.0054,"2.4.5-p2":0.0032,"2.4.5-p3":0.004,"2.4.5-p4":0.004,"2.4.5-p5":0.004,"2.4.5-p6":0.0041,"2.4.5-p7":0.0041,"2.4.5-p8":0.0038,"2.4.5-p9":0.0027,"2.4.6":0.0134,"2.4.6-p1":0.0091,"2.4.6-p10":0.0077,"2.4.6-p11":0.0079,"2.4.6-p12":0.0064,"2.4.6-p13":0.0067,"2.4.6-p14":0.006,"2.4.6-p15":0.0053,"2.4.6-p2":0.0037,"2.4.6-p3":0.0058,"2.4.6-p4":0.0065,"2.4.6-p5":0.0052,"2.4.6-p6":0.0066,"2.4.6-p7":0.006,"2.4.6-p8":0.0043,"2.4.6-p9":0.0036,"2.4.7":0.0097,"2.4.7-p1":0.0087,"2.4.7-p10":0.0077,"2.4.7-p2":0.0051,"2.4.7-p3":0.0075,"2.4.7-p4":0.0114,"2.4.7-p5":0.0095,"2.4.7-p6":0.0118,"2.4.7-p7":0.008,"2.4.7-p8":0.0072,"2.4.7-p9":0.0053,"2.4.8":0.0136,"2.4.8-p1":0.0099,"2.4.8-p2":0.0113,"2.4.8-p3":0.0106,"2.4.8-p4":0.0112,"2.4.8-p5":0.0092,"2.4.9":0.0098,"unspecified":0.4954},"confidence":0.2399},"backportWorthy":{"score":1.4684,"probabilities":{"0":0.1375,"1":0.2565,"2":0.606},"confidence":0.1778}},"curated":{"title":"customerOrders query has order_date and comment created_at in +0 timezone","description":"The customerOrders GraphQL query had order_date and the created_at of shipment, invoice and CreditMemo comments in +0 timezone, not in the store configured timezone used by the view. The SalesGraphQl Order formatter and the Invoices, Shipments and CreditMemoComments resolver now format them with TimezoneInterface.","categories":[],"author":"claude-code/opus-5.5","date":"2026-10-06","reviewedBy":null},"tests":{"2.4.7-p10":{"before":"not-runnable","after":"error","adapted":false,"runAt":"2026-10-06T10:49:10.788Z","releaseCommit":"72561bf80652f57cc642a03e2c9a51d74a285b14","suites":{"api-functional":{"before":"not-runnable","after":"error","runAt":"2026-10-06T10:49:10.788Z"}}}}},"_documentation":"https://magento.watch/api","_description":"Upstream fix magento2-38264 details"}