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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0006713
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformtrivialhave not tried2008-12-22 13:042009-08-10 22:55
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PrioritylowResolutionfixedFixed in Version2.50MP4
StatusclosedFix in branchFixed in SCM revisioncd71162f5f9f
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision11455 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0006713: The function AD_DISPLAY_LIST does not with uuids

DescriptionThe function has the parameter p_referencevalue_id defined with the type NUMERIC but it contains an uuid value and is used to filter an _id field.

Steps To ReproduceCall the function with an uuid for the parameter
OR
find a user for the function so that it is called this way.
Proposed SolutionChange the parameter type and validate with a user which runs the function is an non-numeric value (uuid) for that parameter.
TagsUUID project
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
has duplicate defect 0009775 closedshuehner Function ad_display_list 

-  Notes
(0018472)
shuehner (administrator)
2009-07-21 11:37

Only feature request as the function is not used anywhere by core.
(0018532)
hgbot (developer)
2009-07-22 10:37

Repository: erp/devel/pi
Changeset: cd71162f5f9f64ba4e66942160b84c53f379b724
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Wed Jul 22 10:37:13 2009 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/cd71162f5f9f64ba4e66942160b84c53f379b724 [^]

Fixed 6713: Fix dataptype of reference_id parameter of ad_display_list function

---
M src-db/database/model/functions/AD_DISPLAY_LIST.xml
---
(0018533)
shuehner (administrator)
2009-07-22 10:38

@qa: the function is not used in core. Manual testing can be done as follows:

Can be tested on postgres 8.3 (not sure if the exact testcase works on oracle):

SELECT * from ad_display_list ('101','S','en_US');

This will display 'Not found!' without this fix. After applying the fix the output is 'SQL'.

- Issue History
Date Modified Username Field Change
2008-12-22 13:04 shuehner New Issue
2008-12-22 13:04 shuehner Assigned To => rafaroda
2008-12-22 13:04 shuehner sf_bug_id 0 => 2458386
2008-12-22 13:04 shuehner Regression testing => No
2008-12-22 13:05 shuehner Tag Attached: UUID project
2008-12-22 16:45 shuehner Assigned To rafaroda => shuehner
2008-12-22 16:45 shuehner Priority normal => low
2008-12-22 16:45 shuehner Severity major => trivial
2008-12-22 16:45 shuehner Status new => acknowledged
2008-12-22 16:45 shuehner Relationship added blocks 0006698
2008-12-22 16:59 shuehner Type defect => feature request
2009-01-29 15:58 shuehner Relationship added related to 0007236
2009-07-21 11:37 shuehner Note Added: 0018472
2009-07-21 11:38 shuehner Relationship added related to 0009775
2009-07-22 10:35 shuehner Relationship deleted blocks 0006698
2009-07-22 10:35 shuehner Relationship deleted related to 0007236
2009-07-22 10:36 shuehner Relationship replaced has duplicate 0009775
2009-07-22 10:37 hgbot Checkin
2009-07-22 10:37 hgbot Note Added: 0018532
2009-07-22 10:37 hgbot Status acknowledged => resolved
2009-07-22 10:37 hgbot Resolution open => fixed
2009-07-22 10:37 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cd71162f5f9f64ba4e66942160b84c53f379b724 [^]
2009-07-22 10:38 shuehner Note Added: 0018533
2009-08-10 22:55 pjuvara Status resolved => closed
2009-08-10 22:55 pjuvara Fixed in Version => 2.50MP4


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker