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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0028438
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminoralways2014-12-17 16:152015-02-23 05:11
ReporterngarciaView Statuspublic 
Assigned Toalostale 
PriorityhighResolutionfixedFixed in Version3.0PR15Q2
StatusclosedFix in branchFixed in SCM revision0fb59d223c5d
ProjectionnoneETAnoneTarget Version3.0PR15Q2
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket33051
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0028438: Property fields cannot be included in validations

DescriptionProperty fields cannot be included in validations
Steps To ReproduceAs system admin role:

 * In Windows Tabs and Field open Currency > Currency Conversion tab definition
 * Add a new field:
    -name: Currency Code
    -property: currency.iSOCode
 * Create a new Validation Setup:
    -name: currency conversion
    -code: c_currency.iso_code != '@_propertyField_currencycode_ISO_Code@'
 * Edit C_Conversion_Rate.C_Currency_ID_To column adding the created validation


 * Open Currency Window
 * Select any record
 * Create new Conversion Rate
    -> check To Currency combo has no values: it should show all defined currencies but the one selected in the header
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0025701 closedAugustoMauch FIC response causes an error when open in edit view payment details tab 
related to defect 0025630 closedAugustoMauch Reference list not retrieved correctly if there exists a property field in the window with a particular name 
related to defect 0028977 closedcaristu NPE if property field can not reach the complete path 
related to defect 0036163 closedalostale val rule referring non-existent col fails if there's a property field with same name 

-  Notes
(0073935)
alostale (viewer)
2015-01-30 11:05

 Steps to reproduce has nothing to do with description: @DocumentNo@ is not a property field in Financial Account > Transaction tab not even an existent field.

Please provide better description/steps to reproduce.
(0074518)
ngarcia (viewer)
2015-02-16 16:44

 Although Payment No. was a property field in Financial Account - Transactions tab, new steps to reproduce are provided as DocumentNo columns are managed in a different way:

As system admin role:
Create a new field in the Sales Invoice - Header tab
Add the following value in the Property field:
   businessPartner.priceList.name
Check the column assigned is Name
Edit the Price List isSOTrx validation code (assigned to M_PriceList_ID column). Add the following clause
   and M_PriceList.name = @Name@

As group admin role:
   Create a new record in the Sales Invoice window
   Check the following error message is shown in the log
      Error. The columns M_PriceList_ID have validations which form a cycle.
(0074597)
alostale (viewer)
2015-02-18 13:58

 New syntax to refer them in validation rules has been defined: http://wiki.openbravo.com/wiki/How_to_use_property_fields#Using_in_validation_rules [^]
(0074599)
hgbot (developer)
2015-02-18 14:01

 Repository: erp/devel/pi
Changeset: 0fb59d223c5d0b27974f065fb8da0e79e657c4d1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Feb 18 14:00:33 2015 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/0fb59d223c5d0b27974f065fb8da0e79e657c4d1 [^]

fixed bug 28438: Property fields cannot be included in validations

  A new syntax has been defined to use property fields within validation rules.

  More information on how to use it:
   http://wiki.openbravo.com/wiki/How_to_use_property_fields#Using_in_validation_rules [^]

---
M src/org/openbravo/erpCommon/utility/Utility.java
---
(0074614)
AugustoMauch (administrator)
2015-02-18 17:24

 Code reviewed and verified in pi@b5ce661abc2d
(0074783)
hudsonbot (viewer)
2015-02-23 05:11

 A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/6856352d7235 [^]
Maturity status: Test

- Issue History
Date Modified Username Field Change
2014-12-17 16:15 ngarcia New Issue
2014-12-17 16:15 ngarcia Assigned To => AugustoMauch
2014-12-17 16:15 ngarcia OBNetwork customer => Yes
2014-12-17 16:15 ngarcia Modules => Core
2014-12-17 16:15 ngarcia Support ticket => 33051
2014-12-17 16:15 ngarcia Resolution time => 1393369200
2014-12-17 16:15 ngarcia Triggers an Emergency Pack => No
2014-12-17 16:16 ngarcia Issue Monitored: networkb
2014-12-17 18:23 alostale Relationship added related to 0025630
2014-12-18 11:13 alostale Resolution time 1393369200 => 1424905200
2015-01-13 18:56 ngarcia Target Version => 3.0PR15Q2
2015-01-30 10:02 alostale Relationship added related to 0025701
2015-01-30 11:05 alostale Note Added: 0073935
2015-01-30 11:05 alostale Assigned To AugustoMauch => jonalegriaesarte
2015-01-30 11:05 alostale Status new => feedback
2015-02-02 13:31 jonalegriaesarte Assigned To jonalegriaesarte => ngarcia
2015-02-16 16:44 ngarcia Note Added: 0074518
2015-02-16 16:44 ngarcia Assigned To ngarcia => alostale
2015-02-16 16:44 ngarcia Status feedback => new
2015-02-16 17:49 alostale Status new => scheduled
2015-02-16 17:49 alostale fix_in_branch => pi
2015-02-18 10:43 alostale Relationship added related to 0028977
2015-02-18 13:50 alostale fix_in_branch pi =>
2015-02-18 13:50 alostale Steps to Reproduce Updated View Revisions
2015-02-18 13:58 alostale Note Added: 0074597
2015-02-18 14:01 alostale Review Assigned To => AugustoMauch
2015-02-18 14:01 hgbot Checkin
2015-02-18 14:01 hgbot Note Added: 0074599
2015-02-18 14:01 hgbot Status scheduled => resolved
2015-02-18 14:01 hgbot Resolution open => fixed
2015-02-18 14:01 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/0fb59d223c5d0b27974f065fb8da0e79e657c4d1 [^]
2015-02-18 17:24 AugustoMauch Note Added: 0074614
2015-02-18 17:24 AugustoMauch Status resolved => closed
2015-02-18 17:24 AugustoMauch Fixed in Version => 3.0PR15Q2
2015-02-23 05:11 hudsonbot Checkin
2015-02-23 05:11 hudsonbot Note Added: 0074783
2017-06-01 13:29 alostale Relationship added related to 0036163

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker