Book a Demo

Author Topic: Conditionally exclude audit items from doc  (Read 4316 times)

mjm

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Conditionally exclude audit items from doc
« on: October 23, 2015, 01:35:43 am »
Hello,

I am working with auditing and document generation, and am trying to develop reports identifying elements that have been added to, or changed in, a package or any of that package's subpackages.

I have successfully enabled auditing on elements in a subpackage, but am having a couple problems in trying to generate the desired report. The problems I'm having are:

1. The report produced doesn't contain any elements unless I select a package, via generate documentation dialog, that itself contains elements that have audit trail info... In other words, if I select a package that has descendant packages that contain elements with audit details, the report produced does not contain any entries for the audit details pertaining to the elements in the subpackage. I need the report produced to contain audit details on elements in any package under the root package identified.

2. When the report produced does include audit details, the entries provided that indicate an element was added provide an "AuditItem.From" and "AuditItem.To" despite the fact that the "AuditItem.From" value is null for each field. Including entries for these fields makes the report produced very noisy. I would like the report produced to omit all fields having an "AuditItem.From" value of null... the only thing we are interested in for these audit entries is simply to know that the element was created, who created it, and the time it was created.

I haven't found documentation explaining how these goals can be achieved. I have looked through document generation options and document template options as well, and haven't come across anything in either of those dialogs that seems to address these scenarios.

Are the things I'm looking to do possible through document generation in Sparx? If so, can anyone point me in the right direction? I would sincerely appreciate any help you can provide!

Thanks in advance.

Geert Bellekens

  • EA Guru
  • *****
  • Posts: 13523
  • Karma: +574/-33
  • Make EA work for YOU!
    • View Profile
    • Enterprise Architect Consultant and Value Added Reseller
Re: Conditionally exclude audit items from doc
« Reply #1 on: October 23, 2015, 02:18:12 am »
I think you better have a look at SQL fragments.
That would solve both issues.

Geert

mjm

  • EA Novice
  • *
  • Posts: 6
  • Karma: +0/-0
    • View Profile
Re: Conditionally exclude audit items from doc
« Reply #2 on: November 06, 2015, 02:27:07 am »
Sorry for the late reply - thank you for yours.