Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0049914
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Retail Modules] Web POSmajorhave not tried2022-07-29 14:282022-08-01 08:43
Reporterjorge-garciaView Statuspublic 
Assigned Tojorge-garcia 
PriorityurgentResolutionfixedFixed in VersionRR22Q4
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
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
Summary

0049914: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
caused by feature request 0049782 closedjorge-garcia POS2 Jira 1854 - Reprint/Resend invoices: Being able to reprint and resend invoices in ReactPOS 

-  Notes
(0139729)
hgbot (developer)
2022-07-29 14:32

 Merge Request created: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/884 [^]
(0139756)
hgbot (developer)
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 (developer)
2022-08-01 08:43

 Merge request merged: https://gitlab.com/openbravo/product/pmods/org.openbravo.retail.posterminal/-/merge_requests/884 [^]

- Issue History
Date Modified Username Field Change
2022-07-29 14:28 jorge-garcia New Issue
2022-07-29 14:28 jorge-garcia Assigned To => Retail
2022-07-29 14:28 jorge-garcia OBNetwork customer => No
2022-07-29 14:28 jorge-garcia Triggers an Emergency Pack => No
2022-07-29 14:29 jorge-garcia Assigned To Retail => jorge-garcia
2022-07-29 14:29 jorge-garcia Status new => scheduled
2022-07-29 14:29 jorge-garcia Relationship added caused by 0049782
2022-07-29 14:32 hgbot Merge Request Status => open
2022-07-29 14:32 hgbot Note Added: 0139729
2022-07-29 14:40 jorge-garcia Steps to Reproduce Updated View Revisions
2022-07-29 14:40 jorge-garcia Proposed Solution updated
2022-07-29 14:43 hgbot Merge Request Status open => approved
2022-08-01 08:43 hgbot Resolution open => fixed
2022-08-01 08:43 hgbot Status scheduled => closed
2022-08-01 08:43 hgbot Fixed in Version => RR22Q4
2022-08-01 08:43 hgbot Note Added: 0139756
2022-08-01 08:43 hgbot Note Added: 0139757

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker