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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0009228
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2009-05-28 18:322009-05-30 00:00
ReporternetworkbView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionsuspendedFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40MP3SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0009228: The wherecluase of the tab does not allow to use expressions as @#Ad_Role_ID@ <> 100012

DescriptionThe wherecluase of the tab does not allow to use expressions as @#Ad_Role_ID@ <> 100012. If you use the expression with other order, it works. example:
   100012 <> @#Ad_Role_ID@
Steps To Reproduce-Loggin as system administrator
-Go to windows tabs and fields window.
-Edit a tab of a window
-Add in the where clause field the following:
  @#Ad_Role_ID@ <> 100012
-Save and compile the window
-You get the following error
       [java] 71923 [main] INFO org.openbravo.wad.Wad - Processing Window: Business Partner - Tab: Vendor/Creditor - id: 224
     [java] java.lang.StringIndexOutOfBoundsException: String index out of range: -1
     [java] at java.lang.String.substring(String.java:1932)
     [java] at java.lang.String.substring(String.java:1905)
     [java] 72085 [main] ERROR org.openbravo.wad.Wad - Problem at close of the file: 224
     [java] at org.openbravo.wad.WadUtility.getSQLWadContext(Unknown Source)
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0009178 closeddbaz Tab keys are not properly set for fields unit price & List price in Sales Order || Lines page after the product is selected. 

-  Notes
(0016745)
rafaroda (developer)
2009-05-29 08:52

Asier,

Could you please comment on this issue and schedule it for 2.40 if required?

Thanks.
(0016769)
alostale (manager)
2009-05-29 16:06

I wouldn't fix this issue because:

1. It has a very simple workarround, just change the order of the parameter in the clause.
2. It is a very unusual case. Generally session variables are not compared with constant arguments but with columns in the tab.
3. It might add instability. This fix requires some modifications in a piece deep in WAD, which might add new instability.

If after reading the reasons to reject this issue you still think it should be fixed, please reopen it.

- Issue History
Date Modified Username Field Change
2009-05-28 18:32 networkb New Issue
2009-05-28 18:32 networkb Assigned To => rafaroda
2009-05-29 08:52 rafaroda Note Added: 0016745
2009-05-29 08:52 rafaroda Assigned To rafaroda => alostale
2009-05-29 16:06 alostale Status new => closed
2009-05-29 16:06 alostale Note Added: 0016769
2009-05-29 16:06 alostale Resolution open => suspended
2009-05-30 00:00 anonymous sf_bug_id 0 => 2798626
2009-06-02 22:10 dbaz Relationship added related to 0009178


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker