Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0049914 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] Web POS | major | have not tried | 2022-07-29 14:28 | 2022-08-01 08:43 | |||
| Reporter | jorge-garcia | View Status | public | |||||
| Assigned To | jorge-garcia | |||||||
| Priority | urgent | Resolution | fixed | Fixed in Version | RR22Q4 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0049914: InvoicesHeader query is not working in oracle | |||||||
| Description | Due to last changes, InvoicesHeader query is not working in oracle. | |||||||
| Steps To Reproduce | In 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 Solution | Oracle query should contain group by all elements from select clause | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||
|
|||||||||
 Relationships |
|
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 [^] |
|
Notes |
|
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 | 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 | 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-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 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |