Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformminorhave not tried2016-08-03 14:412016-12-16 18:39
ReporterNaroaIriarteView Statuspublic 
Assigned Toalostale 
PrioritynormalResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revisione2a5fb3292e8
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned ToNaroaIriarte
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0033617: The checkbox "Fully Audited" should not be visible in tables whose data origin are not "Table"

DescriptionThe "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 ReproduceIt 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 SolutionIt 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
hgbot (developer)
2016-12-15 08:53

Repository: erp/devel/pi
Changeset: e2a5fb3292e8cde44268f677c0665a94c924ece7
Author: Asier Lostalé <asier.lostale <at>>
Date: Thu Dec 15 08:53:09 2016 +0100
URL: [^]

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

  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
NaroaIriarte (developer)
2016-12-16 13:10

Code reviewed + tested with Postgres9.3 and Oracle12.1.
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: [^]
Maturity status: Test

- 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 => [^]
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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker