Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Robert Sheridan on November 05, 2015, 11:01:38 pm

Title: Extracting Security Data as a Report
Post by: Robert Sheridan on November 05, 2015, 11:01:38 pm

Hi all,
I have written some SQL to extract user security information using Project Search.  I would like to reuse it in a report to provide it in a standard format.
I created a template fragment, added the SQL to it and added the custom fields in to the custom section.  I then created a report template and added the template in to the package section as there was no option to add it in to the custome section.  
When I ran the report there was not output.  Have I missed something or is this not supported (because the SQL does not refer to a package or element).

Title: Re: Extracting Security Data as a Report
Post by: Screwtape on November 06, 2015, 01:12:50 am

I've always linked my fragments within an element, but I'm not sure that is necessary.

Presumably, you are running the report against a single object (either a package or element) - if it's an element, then nothing in the package space will get printed unless it's within the element space (I think).

Title: Re: Extracting Security Data as a Report
Post by: Robert Sheridan on November 06, 2015, 02:46:39 am

It does work within the package section, I had inadvertently put the SQL in the section on the first tab rather than custom queries.  Aaaaargh