Sparx Systems Forum

Enterprise Architect => Automation Interface, Add-Ins and Tools => Topic started by: Sorno on May 15, 2014, 01:27:05 am

Title: RTF generator: Skip empty rows from custom query?
Post by: Sorno on May 15, 2014, 01:27:05 am

Hi,

In EA 10 I'm using the RTF-generator to do a custom SQL query that returns two columns Name and Note of elements. It works alright for all element that both have a name and an non-empty note-field. For the cases where the note-field is empty the RT-generator prints "Note" (the name of the custom field). I presumed it would just skip to write anything if the field was empty.

A ugly-workaround is to set all note-field to atleast contain a empty space, but this also mean that an empty  row is added after each element. Any other way?

Thank you!

Title: Re: RTF generator: Skip empty rows from custom que
Post by: Eve on May 15, 2014, 08:41:30 am

If I remember correctly there was an update to the rtf generator to handle empty fields returned from a sql query. Try downloading the latest version and see if that corrects your problem.

(The other alternative is that there was a change provided by a developer but they hadn't thought through the impact and it was sent back to them.)

Title: Re: RTF generator: Skip empty rows from custom que
Post by: Sorno on May 15, 2014, 04:45:29 pm

Ok, thank you for your reply.

I'm using 10.1010, so I guess that feature was sent back to the drawing board. Bummer, I guess I'm out of luck with v.10 then.

Title: Re: RTF generator: Skip empty rows from custom que
Post by: Sorno on May 15, 2014, 09:18:02 pm

In a fragment is it in any way possible to do a SQL query and work with the results as elements, rather than just Custom Field?

I have tried by letting the query return
Select t_object.ea_guid AS CLASSGUID, t_object.Object_Type AS CLASSTYPE but to no use.

My problem:

I want to list elements (from a custom query) and certain elements that they are connected to, but not all. When I set element filters they only seem to be applied to the inital list of elements, not the elements they are connected to.

Any way to filter them as well?

Cheers!

Title: Re: RTF generator: Skip empty rows from custom que
Post by: Eve on May 16, 2014, 08:44:16 am

Looks like it was fixed in 11.

Quote

SQL query fragments containing empty values will now remove the markers from the generated reports

Title: Re: RTF generator: Skip empty rows from custom que
Post by: Sorno on May 17, 2014, 12:50:53 am

Alright! Too bad we won't be able to upgrade to v.11 for a while...

Thanks for the info and have a nice weekend.