RTF generator: Skip empty rows from custom query?

[Sorno]

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!

[Eve]

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.)

[Sorno]

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.

[Sorno]

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!

[Eve]

Looks like it was fixed in 11.

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

[Sorno]

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.