Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0049914Retail ModulesWeb POSpublic2022-07-29 14:282022-08-01 08:43
Reporterjorge-garcia 
Assigned Tojorge-garcia 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR22Q4 
Merge Request Statusapproved
Review Assigned To
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0049914: InvoicesHeader query is not working in oracle
DescriptionDue to last changes, InvoicesHeader query is not working in oracle.
Steps To ReproduceIn a Oracle instance of retail with modules

1) Login in VBS-1 as vallblanca
2) Create a ticket with products and pay it
3) Complete the cashup
4) Login again in VBS-1 as vallblanca
5) Go to the menu and load the previous ticket
6) Once loaded, go to the menu again and click on Print Ticket
7) Verify an error is raised and invoice(s) are not loaded
Proposed SolutionOracle query should contain group by all elements from select clause
Additional Information
TagsNo tags attached.
Relationships
caused by feature request 0049782 closed jorge-garcia POS2 Jira 1854 - Reprint/Resend invoices: Being able to reprint and resend invoices in ReactPOS 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-07-29 14:28jorge-garciaNew Issue
2022-07-29 14:28jorge-garciaAssigned To => Retail
2022-07-29 14:28jorge-garciaOBNetwork customer => No
2022-07-29 14:28jorge-garciaTriggers an Emergency Pack => No
2022-07-29 14:29jorge-garciaAssigned ToRetail => jorge-garcia
2022-07-29 14:29jorge-garciaStatusnew => scheduled
2022-07-29 14:29jorge-garciaRelationship addedcaused by 0049782
2022-07-29 14:32hgbotMerge Request Status => open
2022-07-29 14:32hgbotNote Added: 0139729
2022-07-29 14:40jorge-garciaSteps to Reproduce Updatedbug_revision_view_page.php?rev_id=24570#r24570
2022-07-29 14:40jorge-garciaProposed Solution updated
2022-07-29 14:43hgbotMerge Request Statusopen => approved
2022-08-01 08:43hgbotResolutionopen => fixed
2022-08-01 08:43hgbotStatusscheduled => closed
2022-08-01 08:43hgbotFixed in Version => RR22Q4
2022-08-01 08:43hgbotNote Added: 0139756
2022-08-01 08:43hgbotNote Added: 0139757

Notes
(0139729)
hgbot   
2022-07-29 14:32   
Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/884 [^]
(0139756)
hgbot   
2022-08-01 08:43   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal [^]
Changeset: 4bf26b014cfda74425f08e959ec6bd22f9938e21
Author: Jorge Garcia <jorge.garcia@openbravo.com>
Date: 01-08-2022 08:42:00
URL: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/commit/4bf26b014cfda74425f08e959ec6bd22f9938e21 [^]

Fixes ISSUE-49914: Include in group by same case that in select statement

---
M src/org/openbravo/retail/posterminal/InvoicesHeader.java
---
(0139757)
hgbot   
2022-08-01 08:43   
Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/884 [^]