Openbravo Issue Tracking System - Retail Modules
View Issue Details
0050713Retail ModulesDiscounts and Promotionspublic2022-11-03 07:442022-11-03 12:43
marvintm 
Retail 
normalminorhave not tried
closedfixed 
5
 
RR23Q1 
marvintm
No
0050713: API Change: New constraints added as part of the merge of the bytotal module
As part of the merge of the bytotal module into the main retail.discounts module, several new constraints have been added:

 <check name="EM_DISCT_TOTALAMOUNTCHK"><![CDATA[M_OFFER_TYPE_ID = '4183C8EB7CDA472D9E64521DC2504B15' AND (EM_DISCT_TOTALAMOUNTDISC IS NOT NULL OR EM_DISCT_ISSCALEDBYTOTAL = 'Y') OR NOT M_OFFER_TYPE_ID = '4183C8EB7CDA472D9E64521DC2504B15']]></check>
      <check name="EM_DISCT_TOTALPERCCHK"><![CDATA[M_OFFER_TYPE_ID = '9707DE71F91549DB80CCB2F094E951EA' AND (EM_DISCT_TOTALPERCDISC IS NOT NULL OR EM_DISCT_ISSCALEDBYTOTAL = 'Y') OR NOT M_OFFER_TYPE_ID = '9707DE71F91549DB80CCB2F094E951EA']]></check>
      <check name="EM_DISCT_TOTALRECEIPTCHK"><![CDATA[(M_OFFER_TYPE_ID = '4183C8EB7CDA472D9E64521DC2504B15' OR M_OFFER_TYPE_ID = '9707DE71F91549DB80CCB2F094E951EA' OR M_OFFER_TYPE_ID = '4755A35B4DA34F6CB08F15462BA123CF') AND EM_DISCT_TOTALRECEIPT IS NOT NULL OR NOT (M_OFFER_TYPE_ID = '4183C8EB7CDA472D9E64521DC2504B15' OR M_OFFER_TYPE_ID = '9707DE71F91549DB80CCB2F094E951EA' OR M_OFFER_TYPE_ID = '4755A35B4DA34F6CB08F15462BA123CF') OR EM_DISCT_ISSCALEDBYTOTAL = 'Y' AND (M_OFFER_TYPE_ID = '4183C8EB7CDA472D9E64521DC2504B15' OR M_OFFER_TYPE_ID = '9707DE71F91549DB80CCB2F094E951EA')]]></check>

These constraints did not exist previously in the retail.discounts module, so technically they are an API change. However, they did exist before in the bytotal module, and they essentially apply only when using a bytotal-related discount, so in practice they should be a non-issue for current users.
.
No tags attached.
related to design defect 0049908 closed ranjith_qualiantech_com POS2 Remove incorrect implicit dependency on bytotal module 
Issue History
2022-11-03 07:44marvintmNew Issue
2022-11-03 07:44marvintmAssigned To => Retail
2022-11-03 07:44marvintmTriggers an Emergency Pack => No
2022-11-03 07:44marvintmRelationship addedrelated to 0049908
2022-11-03 07:45marvintmSummaryNew constraints added as part of the merge of the bytotal module => API Change: New constraints added as part of the merge of the bytotal module
2022-11-03 08:14hgbotResolutionopen => fixed
2022-11-03 08:14hgbotStatusnew => resolved
2022-11-03 08:14hgbotNote Added: 0142850
2022-11-03 08:15marvintmReview Assigned To => marvintm
2022-11-03 08:15marvintmStatusresolved => closed
2022-11-03 08:15marvintmFixed in Version => RR23Q1
2022-11-03 12:43hgbotNote Added: 0142879

Notes
(0142850)
hgbot   
2022-11-03 08:14   
Repository: https://gitlab.com/openbravo/ci/mobile-api [^]
Changeset: 02da1d8cf456108f4888954f38ef4a38929c8510
Author: Antonio Moreno <antonio.moreno@openbravo.com>
Date: 03-11-2022 08:14:52
URL: https://gitlab.com/openbravo/ci/mobile-api/-/commit/02da1d8cf456108f4888954f38ef4a38929c8510 [^]

Fixed ISSUE-50713: API change, added constraints coming from bytotal module merge

---
M model/modules/org.openbravo.retail.discounts/src-db/database/model/modifiedTables/M_OFFER.xml
---
(0142879)
hgbot   
2022-11-03 12:43   
Repository: https://gitlab.com/openbravo/ci/mobile-api [^]
Changeset: b4c04ac13470b285c72a751a5db70fb4a999bfde
Author: Antonio Moreno <antonio.moreno@openbravo.com>
Date: 03-11-2022 12:43:36
URL: https://gitlab.com/openbravo/ci/mobile-api/-/commit/b4c04ac13470b285c72a751a5db70fb4a999bfde [^]

Related to ISSUE-50713: Added missing dbprefix

---
M model/modules/org.openbravo.retail.discounts/src-db/database/sourcedata/AD_MODULE_DBPREFIX.xml
---