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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0000507
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] Z. Othersminoralways2008-06-02 11:372009-01-27 17:15
ReporteregoitzView Statuspublic 
Assigned ToHennadzi 
PrioritynormalResolutionfixedFixed in Version2.35
StatusclosedFix in branch2.3xFixed in SCM revision10485
ProjectionnoneETAnoneTarget Version
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.2Ant version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0000507: m_get_offers_name function does not work on postgreSQL

DescriptionThe m_get_offers_name function does not work on postgresql
Steps To ReproduceI tried to use this function defined to do a develop.
I defined a new Price adjustemnt and assigned a product to this price adjustment. I execute the next order and it didn't return nothing.
select m_get_offers_name(to_date(now()),anypartner_id,the_id_of_the_productassigned) from dual;
Proposed SolutionThe problem is that the next variable is initialized with NULL and then a String is concatened to this variable, and it is not possible in postgre.

v_Names VARCHAR(10000) := NULL;
...
...
    LOOP
      IF v_Names IS NOT NULL THEN
        v_Names := v_Names||'
';
      END IF;
      v_Names := v_Names||Cur_Offer.name;
    END LOOP;

To solve it you have to use an empty string instead of NULL and the compare the v_Names with an empty string instead of compare with NULL.
Posible solution:

v_Names VARCHAR(10000) := '';
...
...
 IF v_Names <> '' THEN
        v_Names := v_Names||'<b r/>& nbsp;';
      END IF;
      v_Names := v_Names||Cur_Offer.name;
    END LOOP;
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks defect 0000490pi closedHennadzi m_get_offers_name function does not work on postgreSQL 

-  Notes
(0010582)
svnbot (reporter)
2008-11-24 17:47

Repository: openbravo
Revision: 10485
Author: hennadzi
Date: 2008-11-24 17:46:40 +0100 (Mon, 24 Nov 2008)

bug fixed 0000507: m_get_offers_name function does not work on postgreSQL

---
U branches/r2.3x/database/model/functions/M_GET_OFFERS_NAME.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10485&sc=1 [^]
(0012694)
rafaroda (developer)
2009-01-27 17:12
edited on: 2009-01-27 17:15

To test the fix within Openbravo ERP using PostgreSQL:

1) Create a price adjustment in 'Master Data Management || Pricing || Price Adjustments || Adjustments' with values:
* Starting date = 01-01-2000
* Discount % = 50
* Min Quantity = 499
* Business Partner = All Selected
* Product = All Selected
2) Move to Business Partner tab and select one business partner
3) Move to Product tab and select one product
4) Create a new Sales or Purchase Order for the business partner of the price adjustment
5) Create one line for the product of the price adjustment
6) Save this line
7) Change quantity to 500. Unit Price should have half amount
8) Go to the header of the order and complete it
9) Create a new order for the same business partner
10) Click on Copy Lines and select the product of the previous order

Notice that in Copy Lines pop up the name of the offer appears in Offer column.


- Issue History
Date Modified Username Field Change
2008-06-02 11:37 cromero New Issue
2008-06-02 11:37 cromero Assigned To => cromero
2008-06-02 11:37 cromero Status new => scheduled
2008-06-03 10:50 cromero Assigned To cromero => egoitz
2008-06-03 10:50 cromero Steps to Reproduce Updated
2008-11-13 22:47 rafaroda Assigned To egoitz => Hennadzi
2008-11-24 17:47 svnbot Checkin
2008-11-24 17:47 svnbot Note Added: 0010582
2008-11-24 17:47 svnbot Status scheduled => resolved
2008-11-24 17:47 svnbot Resolution open => fixed
2008-11-24 17:47 svnbot svn_revision => 10485
2009-01-27 17:12 rafaroda Note Added: 0012694
2009-01-27 17:15 rafaroda Note Edited: 0012694
2009-01-27 17:15 psarobe Regression testing => No
2009-01-27 17:15 psarobe Status resolved => closed
2009-01-27 17:15 psarobe Fixed in Version 2.35MP10 => 2.35


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker