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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0038199
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] A. Platformminorhave not tried2018-03-22 15:412022-02-01 08:08
ReportershuehnerView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0038199: SqlC generated code should be able to use bind-variables for list of values (i.e. ad_client_id, ad_org_id) filters

DescriptionQueries using SqlC for their filters of ad_client + ad_org to which a user has access to typically use the parameter of 'Type' replace which essentially embeds the values directly in the SQL test.

The code-generator should be enhanced to allow passing list of values as a param instead (i.e. pass String[]) to be able to change those queries to use bind-parameters
Steps To Reproduce-
Example DefaultValuesData.select called from LoginUtils.fillSessionArguments generates SQL text which looks like:
SELECT GL_Category_ID AS COLUMNNAME FROM GL_Category WHERE isActive = 'Y' AND isDefault = 'Y' AND AD_Client_ID IN ('0','B6F3127B8CE64BB1A8AA601C8F937E9F') AND AD_Org_ID IN ('D2175200A5594844BC9D18960F58205E','7E7DA721AA12459B998F799B0150F40A','0','9A284CA3870D46998D56F08439146733') ORDER BY AD_Client_ID

which has the values of ad_client_id + ad_org_id directly embedded in the SQL string.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
blocks design defect 0038136 acknowledgedTriage Platform Base Tracking issue: Find & Fix queries not using bind-params but embedding values into query string 
blocks defect 0038200 newTriage Omni OMS DefaultValuesData.select (NOT xsql-generated) is not using bind-params for ad_client_id + ad_org_id filters 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2018-03-22 15:41 shuehner New Issue
2018-03-22 15:41 shuehner Assigned To => platform
2018-03-22 15:41 shuehner Modules => Core
2018-03-22 15:41 shuehner Triggers an Emergency Pack => No
2018-03-22 15:41 shuehner Relationship added blocks 0038136
2018-03-22 15:44 shuehner Relationship added blocks 0038200
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker