Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0033617 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] A. Platform | minor | have not tried | 2016-08-03 14:41 | 2016-12-16 18:39 | |||
| Reporter | NaroaIriarte | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | e2a5fb3292e8 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Review Assigned To | NaroaIriarte | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0033617: The checkbox "Fully Audited" should not be visible in tables whose data origin are not "Table" | |||||||
| Description | The "Fully Audited" checkbox should not be visible in tables whose data origin is not Table. For example in tables whose data origin is "HQL Query" it makes no sense. Now it is possible to check that checkbox in HQL tables, but when executing the "Update Audit Trail Infraestructure" process, an error is shown. | |||||||
| Steps To Reproduce | It is needed to have the instance activated: 1- Log in the ERP as System Admin. 2- Go to "Tables and Columns" window. 3- Filter the "Data Origin" column and select "HQL Query". 4- Select, for example the "Aprm_Credit_To_Use" record and open it in form mode. 5- Check the "Fully Audited" checkbox and save the record. 6- Execute the "Update Audit Trail Infraestructure" process and realize that an error is get. | |||||||
| Proposed Solution | It would be interesting not showing the "Fully Audited" field in every table, only in those whose data origin is "Table". This could be done with a display logic. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0092395) hgbot (developer) 2016-12-15 08:53 |
Repository: erp/devel/pi Changeset: e2a5fb3292e8cde44268f677c0665a94c924ece7 Author: Asier Lostalé <asier.lostale <at> openbravo.com> Date: Thu Dec 15 08:53:09 2016 +0100 URL: http://code.openbravo.com/erp/devel/pi/rev/e2a5fb3292e8cde44268f677c0665a94c924ece7 [^] fixed bug 33617: don't show "is fully audited" field for non db tables Fully audited field makes only sense for AD tables backed out by a physical DB table, though it was visible for all of them. Now it is hidden for those tables with origin type different to Table and for views. Additionally, if any non table origin is marked as audited, its audit trigger will not be generated, so that error is not thrown. --- M src-db/database/model/postscript-Oracle.sql M src-db/database/model/postscript-PostgreSql.sql M src-db/database/sourcedata/AD_FIELD.xml --- |
|
(0092488) NaroaIriarte (developer) 2016-12-16 13:10 |
Code reviewed + tested with Postgres9.3 and Oracle12.1. |
|
(0092715) hudsonbot (developer) 2016-12-16 18:39 |
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/dc8bf00badd0 [^] Maturity status: Test |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2016-08-03 14:41 | NaroaIriarte | New Issue | |
| 2016-08-03 14:41 | NaroaIriarte | Assigned To | => platform |
| 2016-08-03 14:41 | NaroaIriarte | Modules | => Core |
| 2016-08-03 14:41 | NaroaIriarte | Triggers an Emergency Pack | => No |
| 2016-08-03 14:46 | NaroaIriarte | Summary | The checkbox "Fully Audited" should not be visible in tables which data origin are not "Table" => The checkbox "Fully Audited" should not be visible in tables whose data origin are not "Table" |
| 2016-08-03 14:46 | NaroaIriarte | Description Updated | View Revisions |
| 2016-12-01 12:39 | alostale | Status | new => acknowledged |
| 2016-12-15 08:50 | alostale | Review Assigned To | => inigosanchez |
| 2016-12-15 08:50 | alostale | Assigned To | platform => alostale |
| 2016-12-15 08:53 | hgbot | Checkin | |
| 2016-12-15 08:53 | hgbot | Note Added: 0092395 | |
| 2016-12-15 08:53 | hgbot | Status | acknowledged => resolved |
| 2016-12-15 08:53 | hgbot | Resolution | open => fixed |
| 2016-12-15 08:53 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/e2a5fb3292e8cde44268f677c0665a94c924ece7 [^] |
| 2016-12-15 09:42 | alostale | Review Assigned To | inigosanchez => NaroaIriarte |
| 2016-12-16 13:10 | NaroaIriarte | Note Added: 0092488 | |
| 2016-12-16 13:10 | NaroaIriarte | Status | resolved => closed |
| 2016-12-16 18:39 | hudsonbot | Checkin | |
| 2016-12-16 18:39 | hudsonbot | Note Added: 0092715 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |