Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0004532Openbravo ERP08. Project and service managementpublic2008-07-28 14:352008-12-14 22:58
rafaroda 
rafaroda 
normalminoralways
closedfixed 
20Ubuntu 7.10
pi 
2.40 
Core
No
0004532: Service Project tab: issue with SQL Where and Filter clauses
In Openbravo ERP, at a Tab level:
* 'SQL Where' clause is used to get in a Tab only data that fulfill the SQL condition.
* 'Filter' clause is used as a default filtering condition.

In Service Project tab, these two concepts are mixed. This causes that multiphase projects can be seen in this tab.
1) Logged as 'System Administrator', go to 'Application Dictionary || Windows, Tabs, and Fields || Window' and select 'Service Project'.
2) Go to 'Tab' tab and select 'Service Project'.

Notice that 'SQL Where' and 'Filter' clauses are mixed.
Put in 'SQL Where' clause the content of 'Filter' clause and leave this one blank.
No tags attached.
Issue History
2008-07-28 14:35rafarodaNew Issue
2008-07-28 14:35rafarodaAssigned To => rafaroda
2008-07-28 14:35rafarodasf_bug_id0 => 2030265
2008-07-28 14:36rafarodaStatusnew => scheduled
2008-07-28 14:36rafarodafix_in_branch => trunk
2008-07-28 16:34svnbotCheckin
2008-07-28 16:34svnbotNote Added: 0008410
2008-07-28 16:34svnbotStatusscheduled => resolved
2008-07-28 16:34svnbotResolutionopen => fixed
2008-07-28 16:34svnbotsvn_revision => 6009
2008-12-14 22:58psarobeRegression testing => No
2008-12-14 22:58psarobeStatusresolved => closed

Notes
(0008410)
svnbot   
2008-07-28 16:34   
Repository: openbravo
Revision: 6009
Author: rafaroda
Date: 2008-07-28 16:34:20 +0200 (Mon, 28 Jul 2008)

Fixes bug 0004532 Added (C_Project.ProjectCategory<>'S' OR C_Project.ProjectCategory IS NULL) SQL Where clause to Service Project tab.

---
U trunk/src-db/database/sourcedata/AD_TAB.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=6009&sc=1 [^]