magento2-38264: CustomerOrders query has order_date and comment created_at in +0 timezone
Community fix magento2-38264 merged into magento/magento2 on 2025-01-07, released in 2.4.8; applies cleanly to 11 releases from 2.4.7 to 2.4.7-p10.
customerOrders query has order_date and comment created_at in +0 timezone edited
- Pull request title
- customer Orders query shipment comments created_at is returned in +0 timezone not in store configured timezone
- Pull request
- magento/magento2#38264
- Issues
- #36947 human
- Author
- @Bartlomiejsz
- Merged
- 2025-01-07
- Fixed in
- 2.4.8
- Reported on
- —
- Categories
- —
- Components
- magento/module-sales-graph-ql
Labels
- Area
- Admin UI
- Component
- —
- Priority
- P2
- Severity
- —
- Reported on (labels)
- 2.4.x
Issue
Title and steps come from the upstream issue and pull request.
Description
Steps to reproduce
2. Create a Shipment with a comment
3. Verify the comment created_at in the normal view phtml in the website
4. Call customer Orders query and check created_at field from shipment comment
Expected result
Actual result
Taken from the upstream issue.
Code match per tag
Each tag was checked with git apply --check against that tag's files. A clean match means the change applies; it is not a test result. Tags that already contain the fix are marked.
| Line | Code match per tag | Tests |
|---|---|---|
| 2.4.6 | 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.6: no test data 2.4.6-p1: no test data 2.4.6-p2: no test data 2.4.6-p3: no test data 2.4.6-p4: no test data 2.4.6-p5: no test data 2.4.6-p6: no test data 2.4.6-p7: no test data 2.4.6-p8: no test data 2.4.6-p9: no test data 2.4.6-p10: no test data 2.4.6-p11: no test data 2.4.6-p12: no test data 2.4.6-p13: no test data 2.4.6-p14: no test data 2.4.6-p15: no test data |
| 2.4.7 | 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.7: no test data 2.4.7-p1: no test data 2.4.7-p2: no test data 2.4.7-p3: no test data 2.4.7-p4: no test data 2.4.7-p5: no test data 2.4.7-p6: no test data 2.4.7-p7: no test data 2.4.7-p8: no test data 2.4.7-p9: no test data 2.4.7-p10: test files do not apply to this releaseapi-functional: could not run before, could not run after |
| 2.4.8 | 2.4.8 conflictcontains the fix 2.4.8-p1 conflictcontains the fix 2.4.8-p2 conflictcontains the fix 2.4.8-p3 conflictcontains the fix 2.4.8-p4 conflictcontains the fix 2.4.8-p5 conflictcontains the fix | 2.4.8: no test data 2.4.8-p1: no test data 2.4.8-p2: no test data 2.4.8-p3: no test data 2.4.8-p4: no test data 2.4.8-p5: no test data |
| 2.4.9 | 2.4.9 conflictcontains the fix | 2.4.9: no test data |
Triage
Model @cf/cloudflare/clef. Probability this is a bug fix: 97.6%. Probability it is security relevant: 0.6%.
Show the model's answers and probabilities
| Question | Answer | Probabilities | Confidence |
|---|---|---|---|
| Change kind | bugfix | bugfix 97.2%, refactor 1.0%, tests_only 0.7%, feature 0.4%, dependency 0.3%, docs_only 0.3% | 93.4% |
| Area | graphql_api | graphql_api 92.0%, customer 2.6%, checkout 2.3% | 82.7% |
| Reported version | unspecified | unspecified 48.1%, 2.4.6 1.7%, 2.4.8 1.4% | 22.6% |
| Scope | 1.14 of 2 | 1 50.2%, 2 31.7%, 0 18.1% | 7.8% |
| Risk | 0.44 of 2 | 0 62.1%, 1 31.9%, 2 6.0% | 23.6% |
| Worth backporting | 1.49 of 2 | 2 61.6%, 1 25.4%, 0 13.0% | 19.1% |
Download
For cweagans/composer-patches, choose a version below and download the bundle. Copy its magento2-38264/ folder into patches/composer/, merge composer.patches.json into composer.json, then run composer install. Test files are always removed; paths are relative to each package root, using the default -p1 level.
Bundle README (what the ZIP ships)
# magento2-38264 Community fix merged upstream into magento/magento2, adapted by magento.watch. This is not a patch published by Adobe. Pull request: https://github.com/magento/magento2/pull/38264 Issue: https://github.com/magento/magento2/issues/36947 Author: @Bartlomiejsz Source commit: 6f63a4e3c4f6d48e988fb02a1575b53ba7e661b0 Modifications: test files and documentation removed, paths rewritten relative to each Composer package. Licence: OSL-3.0 / AFL-3.0, as the original Magento Open Source code. Maintainer: Łukasz Bajsarowicz (@lbajsarowicz)
Licence: Magento Open Source code under OSL-3.0 and AFL-3.0. The bundle carries the original author, source commit and the list of modifications.
