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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018834
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformmajoralways2011-10-21 15:092022-02-01 08:08
ReportergorkaionView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabaseOracleJava version1.5.0_15
OS VersionGentooDatabase version11gAnt version1.7.0
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

0018834: Columns used on validation rules of process parameters are not correctly calculated

DescriptionIt is not possible to use a validation rule that uses more than one column to filter the drop down in a process' parameter.

Consider a process called from a window that has a parameter filtered using a validation rule. If this validation rule uses more than one column to filter only the first one is used.
Steps To Reproduce1. Go to the 'Payment In' window and remove the filter to get one that it is processed. Click on the 'Reactivate' button and check that 'Reactivate' and 'Void' actions are available.

2. Change to System Admin role and go to the ''Process Payment valid actions'' validation setup that it is used to filter the available actions to process a payment.

Change the code from:

((@EM_APRM_Process_Payment@ = 'P' AND AD_Ref_List.value='P') OR (@EM_APRM_Process_Payment@ = 'R' AND AD_Ref_List.value IN ('R', 'V')) OR (@EM_APRM_Process_Payment@ is null))

to:

(@isActive@ = @isActive@ AND (@EM_APRM_Process_Payment@ = 'P' AND AD_Ref_List.value='P') OR (@EM_APRM_Process_Payment@ = 'R' AND AD_Ref_List.value IN ('R', 'V')) OR (@EM_APRM_Process_Payment@ is null))

3. Compile the window using 'ant compile -Dtab="Payment In"'

4. Refresh tomcat and go again to the same payment and click the 'Reactivate' button. Check that the available actions have been changed although the validation should return the same values.

5. Check that the org.openbravo.erpWindows.PaymentIn.Header class is only setting the isActive value and not setting the 'EM_APRM_Process_Payment' field's value.
Proposed SolutionThe issue is on the getComboParaCode() method of WadActionButton class.

The selectComboParams() query is parsing the code of the validation rule and getting the first value it finds between "@".
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0018835 newTriage Platform Base Validation rules on process' parameters can only use real columns 

-  Notes
(0045688)
alostale (manager)
2012-03-02 09:31

Moving to design defect:
-Fixing this bug requires quite a big refactoring in WAD processes generation.
-These kind of processes should be replaced in mid-term by process param windows.
(0052419)
AugustoMauch (manager)
2012-09-24 21:06

Effort: 5
Impact: mid
Plan: mid

- Issue History
Date Modified Username Field Change
2011-10-21 15:09 gorkaion New Issue
2011-10-21 15:09 gorkaion Assigned To => alostale
2011-10-21 15:09 gorkaion Modules => Core
2011-10-21 15:15 gorkaion Relationship added related to 0018835
2012-03-02 09:31 alostale Note Added: 0045688
2012-03-02 09:31 alostale Type defect => design defect
2012-09-24 21:06 AugustoMauch Note Added: 0052419
2012-09-24 21:06 AugustoMauch Status new => scheduled
2017-03-31 14:36 alostale Status scheduled => acknowledged
2017-04-10 14:33 alostale Assigned To alostale => platform
2022-02-01 08:08 alostale Assigned To platform => Triage Platform Base


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker