Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0050389Retail ModulesDiscounts and Promotionspublic2022-10-03 14:132022-10-03 19:25
Reporterjlopez 
Assigned Tojlopez 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version 
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
Summary0050389: API Change: Add dates check constraint on table: M_OFFER_ORGANIZATION
DescriptionA check restriction is added to the M_OFFER_ORGANIZATION table so that the start date is always prior to or equal to the end date, if entered.

API change risk: None

- Both columns are new by new development so there are no problems with entering existing data.
- STARDATE and ENDDATE columns are null by default and so there is no problem with existing clients.
Steps To Reproduce*
Proposed SolutionConstraint: M_OFFER_ORG_DATE_CHK defined as: STARTDATE IS NULL OR ENDDATE IS NULL OR ENDDATE >= STARTDATE
Additional Information
TagsApproved
Relationships
blocks feature request 0050275 closed jlopez [PROMO] Start/End Date in the tab 'Discount and Promotions || Organization' 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2022-10-03 14:13jlopezNew Issue
2022-10-03 14:13jlopezAssigned To => jlopez
2022-10-03 14:13jlopezOBNetwork customer => No
2022-10-03 14:13jlopezTriggers an Emergency Pack => No
2022-10-03 14:14jlopezRelationship addedrelated to 0050275
2022-10-03 14:15jlopezAssigned Tojlopez => aferraz
2022-10-03 14:23jlopezDescription Updatedbug_revision_view_page.php?rev_id=24816#r24816
2022-10-03 14:26aferrazRelationship replacedblocks 0050275
2022-10-03 14:28aferrazTag Attached: Approved
2022-10-03 14:28aferrazAssigned Toaferraz => jlopez
2022-10-03 19:22hgbotMerge Request Status => open
2022-10-03 19:22hgbotNote Added: 0141592
2022-10-03 19:24hgbotMerge Request Statusopen => approved
2022-10-03 19:25hgbotResolutionopen => fixed
2022-10-03 19:25hgbotStatusnew => closed
2022-10-03 19:25hgbotNote Added: 0141593
2022-10-03 19:25hgbotNote Added: 0141594

Notes
(0141592)
hgbot   
2022-10-03 19:22   
Merge Request created: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/35 [^]
(0141593)
hgbot   
2022-10-03 19:25   
Directly closing issue as related merge request is already approved.

Repository: https://gitlab.com/openbravo/ci/backoffice-api [^]
Changeset: 58fe9f822dfa41b197f180b7eab30dde03fc1526
Author: Javier López <javier.lopez@precognis.com>
Date: 03-10-2022 15:02:49
URL: https://gitlab.com/openbravo/ci/backoffice-api/-/commit/58fe9f822dfa41b197f180b7eab30dde03fc1526 [^]

Fixes ISSUE-50389: Add dates check to M_OFFER_ORGANIZATION

---
M model/src-db/database/model/tables/M_OFFER_ORGANIZATION.xml
---
(0141594)
hgbot   
2022-10-03 19:25   
Merge request merged: https://gitlab.com/openbravo/ci/backoffice-api/-/merge_requests/35 [^]