Anonymous | Login

Project:

News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ]

[ Issue History ] [ Print ]

ID

0028791

Type

Category

Severity

Reproducibility

Date Submitted

Last Update

design defect

[Openbravo ERP] A. Platform

minor

always

2015-01-27 19:16

2022-02-01 08:08

Reporter

daniOpenbravo

View Status

public

Assigned To

Triage Platform Base

Priority

normal

Resolution

open

Fixed in Version

Status

acknowledged

Fix in branch

Fixed in SCM revision

Projection

none

ETA

none

Target Version

OS

Linux 64 bit

Database

PostgreSQL

Java version

1.6.0_18

OS Version

Professional Appliance

Database version

8.3.9

Ant version

1.7.1

Product Version

pi

SCM revision

Merge Request Status

Review Assigned To

OBNetwork customer

OBPS

Web browser

Google Chrome

Modules

Core

Support ticket

Regression level

Regression date

Regression introduced in release

Regression introduced by commit

Triggers an Emergency Pack

No

Summary

0028791: Impossible filtering computed columns that have "table" reference.

Description

The system does not allow filtering computed columns (grid view) if they are defined on application dictionary with "table" reference.

Steps To Reproduce

- As System Administrator, create a new computed column (http://wiki.openbravo.com/wiki/How_to_create_a_Computed_Column [^]) adding sqllogic field. Reference for that column has to be "Table" [1].
- Create the field related to that column and show it in grid view.
- Go to the window where is located the field created on previous step and try to filter that column in grid view: "No data in grid" is shown and it is not possible filtering.

[1] Attached diff file with an example of computed column for "c_project" table.

Tags

No tags attached.

bugComputedCols.diff [^] (6,153 bytes) 2015-01-27 19:16 [Show Content] [Hide Content]

diff --git a/src-db/database/sourcedata/AD_COLUMN.xml b/src-db/database/sourcedata/AD_COLUMN.xml
--- a/src-db/database/sourcedata/AD_COLUMN.xml
+++ b/src-db/database/sourcedata/AD_COLUMN.xml
@@ -333845,6 +333845,39 @@
 <!--EB3D1953573F4E07B5EAAF7FE8AF4F8A-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
 <!--EB3D1953573F4E07B5EAAF7FE8AF4F8A--></AD_COLUMN>
 
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B--><AD_COLUMN>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_COLUMN_ID><![CDATA[EB43CD2ABA0943D29A0E2AD17CB4842B]]></AD_COLUMN_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <NAME><![CDATA[computed]]></NAME>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <COLUMNNAME><![CDATA[computed]]></COLUMNNAME>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_TABLE_ID><![CDATA[203]]></AD_TABLE_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_REFERENCE_ID><![CDATA[18]]></AD_REFERENCE_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_REFERENCE_VALUE_ID><![CDATA[141]]></AD_REFERENCE_VALUE_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <FIELDLENGTH><![CDATA[0]]></FIELDLENGTH>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISKEY><![CDATA[N]]></ISKEY>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISPARENT><![CDATA[N]]></ISPARENT>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISMANDATORY><![CDATA[N]]></ISMANDATORY>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISUPDATEABLE><![CDATA[Y]]></ISUPDATEABLE>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISIDENTIFIER><![CDATA[N]]></ISIDENTIFIER>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <SEQNO><![CDATA[301]]></SEQNO>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISTRANSLATED><![CDATA[N]]></ISTRANSLATED>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISSELECTIONCOLUMN><![CDATA[N]]></ISSELECTIONCOLUMN>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISSESSIONATTR><![CDATA[N]]></ISSESSIONATTR>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISSECONDARYKEY><![CDATA[N]]></ISSECONDARYKEY>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISDESENCRYPTABLE><![CDATA[N]]></ISDESENCRYPTABLE>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <DEVELOPMENTSTATUS><![CDATA[RE]]></DEVELOPMENTSTATUS>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISTRANSIENT><![CDATA[N]]></ISTRANSIENT>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISAUTOSAVE><![CDATA[Y]]></ISAUTOSAVE>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <VALIDATEONNEW><![CDATA[Y]]></VALIDATEONNEW>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <IMAGESIZEVALUESACTION><![CDATA[N]]></IMAGESIZEVALUESACTION>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <ISUSEDSEQUENCE><![CDATA[N]]></ISUSEDSEQUENCE>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B-->  <SQLLOGIC><![CDATA[(select max(p.c_project_id) from c_project as p where p.created< created)]]></SQLLOGIC>
+<!--EB43CD2ABA0943D29A0E2AD17CB4842B--></AD_COLUMN>
+
 <!--EB632BC625E04DE59D92493A7E4FD9CB--><AD_COLUMN>
 <!--EB632BC625E04DE59D92493A7E4FD9CB-->  <AD_COLUMN_ID><![CDATA[EB632BC625E04DE59D92493A7E4FD9CB]]></AD_COLUMN_ID>
 <!--EB632BC625E04DE59D92493A7E4FD9CB-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
diff --git a/src-db/database/sourcedata/AD_FIELD.xml b/src-db/database/sourcedata/AD_FIELD.xml
--- a/src-db/database/sourcedata/AD_FIELD.xml
+++ b/src-db/database/sourcedata/AD_FIELD.xml
@@ -287643,6 +287643,32 @@
 <!--E4B7092CA36E473ABEB7F10F417B2ED2-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
 <!--E4B7092CA36E473ABEB7F10F417B2ED2--></AD_FIELD>
 
+<!--E4D06433F46446B0BE1D7F3B62918CA2--><AD_FIELD>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <AD_FIELD_ID><![CDATA[E4D06433F46446B0BE1D7F3B62918CA2]]></AD_FIELD_ID>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <AD_ORG_ID><![CDATA[0]]></AD_ORG_ID>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISACTIVE><![CDATA[Y]]></ISACTIVE>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <NAME><![CDATA[computed]]></NAME>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISCENTRALLYMAINTAINED><![CDATA[Y]]></ISCENTRALLYMAINTAINED>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <AD_TAB_ID><![CDATA[157]]></AD_TAB_ID>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <AD_COLUMN_ID><![CDATA[EB43CD2ABA0943D29A0E2AD17CB4842B]]></AD_COLUMN_ID>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <IGNOREINWAD><![CDATA[Y]]></IGNOREINWAD>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISDISPLAYED><![CDATA[Y]]></ISDISPLAYED>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <DISPLAYLENGTH><![CDATA[0]]></DISPLAYLENGTH>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISREADONLY><![CDATA[N]]></ISREADONLY>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <SEQNO><![CDATA[380]]></SEQNO>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISSAMELINE><![CDATA[N]]></ISSAMELINE>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISFIELDONLY><![CDATA[N]]></ISFIELDONLY>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISENCRYPTED><![CDATA[N]]></ISENCRYPTED>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <SHOWINRELATION><![CDATA[Y]]></SHOWINRELATION>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISFIRSTFOCUSEDFIELD><![CDATA[N]]></ISFIRSTFOCUSEDFIELD>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <AD_MODULE_ID><![CDATA[0]]></AD_MODULE_ID>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <STARTINODDCOLUMN><![CDATA[N]]></STARTINODDCOLUMN>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <STARTNEWLINE><![CDATA[N]]></STARTNEWLINE>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <ISSHOWNINSTATUSBAR><![CDATA[N]]></ISSHOWNINSTATUSBAR>
+<!--E4D06433F46446B0BE1D7F3B62918CA2-->  <EM_OBUIAPP_SHOWSUMMARY><![CDATA[N]]></EM_OBUIAPP_SHOWSUMMARY>
+<!--E4D06433F46446B0BE1D7F3B62918CA2--></AD_FIELD>
+
 <!--E4E2E2ED0513472FA0A5C4E8B6A0AAD2--><AD_FIELD>
 <!--E4E2E2ED0513472FA0A5C4E8B6A0AAD2-->  <AD_FIELD_ID><![CDATA[E4E2E2ED0513472FA0A5C4E8B6A0AAD2]]></AD_FIELD_ID>
 <!--E4E2E2ED0513472FA0A5C4E8B6A0AAD2-->  <AD_CLIENT_ID><![CDATA[0]]></AD_CLIENT_ID>

Relationships [ Relation Graph ] [ Dependency Graph ]

Notes
There are no notes attached to this issue.

Issue History
Date Modified	Username	Field	Change
2015-01-27 19:16	daniOpenbravo	New Issue
2015-01-27 19:16	daniOpenbravo	Assigned To	=> AugustoMauch
2015-01-27 19:16	daniOpenbravo	File Added: bugComputedCols.diff
2015-01-27 19:16	daniOpenbravo	OBNetwork customer	=> Yes
2015-01-27 19:16	daniOpenbravo	Web browser	=> Google Chrome
2015-01-27 19:16	daniOpenbravo	Modules	=> Core
2015-01-27 19:16	daniOpenbravo	Triggers an Emergency Pack	=> No
2015-02-02 13:35	jonalegriaesarte	Web browser	Google Chrome => Google Chrome
2015-02-02 13:35	jonalegriaesarte	Resolution time	=> 1429048800
2015-02-02 13:35	jonalegriaesarte	Target Version	=> 3.0PR15Q2
2015-02-23 08:48	alostale	Status	new => acknowledged
2015-02-23 13:30	jonalegriaesarte	Target Version	3.0PR15Q2 => 3.0PR15Q3
2015-03-09 17:33	jonalegriaesarte	Web browser	Google Chrome => Google Chrome
2015-03-09 17:33	jonalegriaesarte	Resolution time	1429048800 =>
2015-03-11 09:58	alostale	Web browser	Google Chrome => Google Chrome
2015-03-11 09:58	alostale	Priority	normal => high
2015-03-17 14:37	alostale	Assigned To	AugustoMauch => platform
2015-06-15 10:01	alostale	Web browser	Google Chrome => Google Chrome
2015-06-15 10:01	alostale	Target Version	3.0PR15Q3 =>
2015-11-11 11:37	alostale	Priority	high => normal
2017-10-19 17:02	egoitz	Issue Monitored: egoitz
2017-11-29 08:13	alostale	Web browser	Google Chrome => Google Chrome
2017-11-29 08:13	alostale	Type	defect => design defect
2022-02-01 08:08	alostale	Assigned To	platform => Triage Platform Base

Copyright © 2000 - 2009 MantisBT Group