Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0006713Openbravo ERPA. Platformpublic2008-12-22 13:042009-08-10 22:55
Reportershuehner 
Assigned Toshuehner 
PrioritylowSeveritytrivialReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP4 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0006713: 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.
Additional Information
TagsUUID project
Relationships
has duplicate defect 0009775 closed shuehner Function ad_display_list 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-12-22 13:04shuehnerNew Issue
2008-12-22 13:04shuehnerAssigned To => rafaroda
2008-12-22 13:04shuehnersf_bug_id0 => 2458386
2008-12-22 13:04shuehnerOBNetwork customer => No
2008-12-22 13:04shuehnerRegression testing => No
2008-12-22 13:05shuehnerTag Attached: UUID project
2008-12-22 16:45shuehnerAssigned Torafaroda => shuehner
2008-12-22 16:45shuehnerPrioritynormal => low
2008-12-22 16:45shuehnerSeveritymajor => trivial
2008-12-22 16:45shuehnerStatusnew => acknowledged
2008-12-22 16:45shuehnerRelationship addedblocks 0006698
2008-12-22 16:59shuehnerTypedefect => feature request
2009-01-29 15:58shuehnerRelationship addedrelated to 0007236
2009-07-21 11:37shuehnerNote Added: 0018472
2009-07-21 11:38shuehnerRelationship addedrelated to 0009775
2009-07-22 10:35shuehnerRelationship deletedblocks 0006698
2009-07-22 10:35shuehnerRelationship deletedrelated to 0007236
2009-07-22 10:36shuehnerRelationship replacedhas duplicate 0009775
2009-07-22 10:37hgbotCheckin
2009-07-22 10:37hgbotNote Added: 0018532
2009-07-22 10:37hgbotStatusacknowledged => resolved
2009-07-22 10:37hgbotResolutionopen => fixed
2009-07-22 10:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cd71162f5f9f64ba4e66942160b84c53f379b724 [^]
2009-07-22 10:38shuehnerNote Added: 0018533
2009-08-10 22:55pjuvaraStatusresolved => closed
2009-08-10 22:55pjuvaraFixed in Version => 2.50MP4

Notes
(0018472)
shuehner   
2009-07-21 11:37   
Only feature request as the function is not used anywhere by core.
(0018532)
hgbot   
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   
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'.