Messages

1

General Board / Re: In database, identify updates that move an object from one package to another?

« on: January 12, 2016, 04:47:25 am »

Thank you both for your input!

2

General Board / In database, identify updates that move an object from one package to another?

« on: January 12, 2016, 02:50:53 am »

Hello -

I am trying to figure out what column values are updated when an object is moved from one package to another. I can see that the t_object.package_id value is updated, and that the t_package.modifieddate value is updated. I am trying to write a query that identifies objects that have been moved in to a specific package hierarchy within a given date range while (hopefully) excluding objects that have had updates other than package location (for example, if the object name or stereotype was changed, but the object has not been moved, that element should be excluded). Is there any way to isolate these types of updates given the data available?

Thanks in advance!

3

Automation Interface, Add-Ins and Tools / Re: Using custom SQL fragment in custom template

« on: November 19, 2015, 01:14:31 am »

Thank you for your help!

4

Automation Interface, Add-Ins and Tools / Using custom SQL fragment in custom template

« on: November 12, 2015, 07:19:14 am »

I have been trying to create documentation that produces a report using a custom query.

I created a template fragment, and added the following query to that fragment by right-clicking in the fragment's body > File > Document Options > Custom Query > Custom SQL:

with relevant_packages as (
      select      package_id,
                  name,
                  parent_id,
                  convert(varchar(max), '') as parent_name
      from      t_package
      where      package_id = 16241
      union all
      select      p.package_id,
                  p.name,
                  p.parent_id,
                  convert(varchar(max), r.name) as parent_name
      from      t_package p
      join      relevant_packages r
      on            r.package_id = p.parent_id
)
select      r.package_id,
            r.name as package_name,
            r.parent_id as parent_package_id,
            r.parent_name as parent_package_name,
            o.object_id as element_id,
            o.name as element_name,
            o.stereotype,
            o.note,
            o.author,
            o.createddate
from      t_object o
join      relevant_packages r
on            o.package_id = r.package_id
and            o.object_type <> 'Package'
where      o.createddate >= convert(datetime, '2015-10-20')
order by o.createddate desc;

I have tested this query in SQL Server Express, and can confirm that it does return records.

I then created another template, added sections, and added the SQL fragment by right-clicking in sections on the template body (I have tried adding the fragment to sections package & element) as described in the linked article:

http://www.sparxsystems.com/enterprise_architect_user_guide/10/reporting/adding_fragments_to_a_template.html

I then save the template, and generate documentation using that template, output to RTF. The document generated is blank each time.

Can anyone tell me what I'm doing wrong?

Thanks in advance!

5

Automation Interface, Add-Ins and Tools / Re: Conditionally exclude audit items from doc

« on: November 06, 2015, 02:27:07 am »

Sorry for the late reply - thank you for yours.

6

Automation Interface, Add-Ins and Tools / 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.