Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0038199 | Openbravo ERP | A. Platform | public | 2018-03-22 15:41 | 2022-02-01 08:08 | ||||||||||||||
| Reporter | shuehner | ||||||||||||||||||
| Assigned To | Triage Platform Base | ||||||||||||||||||
| Priority | normal | Severity | minor | Reproducibility | have not tried | ||||||||||||||
| Status | new | Resolution | open | ||||||||||||||||
| Platform | OS | 5 | OS Version | ||||||||||||||||
| Product Version | |||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | No | ||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| 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 | ||||||||||||||||||
| Description | Queries 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. | ||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| 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 | OBNetwork customer | => No | ||||||||||||||||
| 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 | ||||||||||||||||
| There are no notes attached to this issue. |