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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0000490
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Othersminoralways2008-05-30 11:372009-04-21 11:04
ReporteregoitzView Statuspublic 
Assigned ToHennadzi 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision10482
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase version8.3Ant 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

0000490: 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 ]
depends on backport 0000507 closedHennadzi m_get_offers_name function does not work on postgreSQL 
depends on backport 00048042.40 closedHennadzi m_get_offers_name function does not work on postgreSQL 

-  Notes
(0010580)
svnbot (reporter)
2008-11-24 17:42

 Repository: openbravo
Revision: 10482
Author: hennadzi
Date: 2008-11-24 17:41:48 +0100 (Mon, 24 Nov 2008)

bug fixed 0000490: m_get_offers_name function does not work on postgreSQL

---
U trunk/src-db/database/model/functions/M_GET_OFFERS_NAME.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=10482&sc=1 [^]
(0012695)
rafaroda (developer)
2009-01-27 17:13
edited on: 2009-01-27 17:14

 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-05-30 11:37 egoitz New Issue
2008-05-30 11:37 egoitz Assigned To => cromero
2008-05-30 11:40 cromero Steps to Reproduce Updated
2008-05-30 11:41 cromero Steps to Reproduce Updated
2008-05-30 11:42 cromero Steps to Reproduce Updated
2008-05-30 11:43 cromero Steps to Reproduce Updated
2008-05-30 11:44 cromero Steps to Reproduce Updated
2008-06-02 11:37 cromero Status new => scheduled
2008-06-03 10:50 cromero Assigned To cromero => egoitz
2008-06-13 19:59 cromero Target Version => 2.40
2008-09-03 18:24 cromero Status scheduled => feedback
2008-09-03 18:24 cromero Status feedback => scheduled
2008-09-03 18:24 cromero fix_in_branch => trunk
2008-11-13 22:47 rafaroda Assigned To egoitz => Hennadzi
2008-11-19 13:19 PavelPonomarev Target Version 2.40 => trunk
2008-11-19 13:19 PavelPonomarev fix_in_branch trunk =>
2008-11-24 17:42 svnbot Checkin
2008-11-24 17:42 svnbot Note Added: 0010580
2008-11-24 17:42 svnbot Status scheduled => resolved
2008-11-24 17:42 svnbot Resolution open => fixed
2008-11-24 17:42 svnbot svn_revision => 10482
2008-12-02 13:01 jaimetorre sf_bug_id 0 => 2377041
2009-01-27 17:13 rafaroda Note Added: 0012695
2009-01-27 17:14 rafaroda Note Edited: 0012695
2009-04-21 11:04 psarobe Status resolved => closed

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker