Referencing current ELEMENT in a SQL Fragment

[OpenIT Solutions]

Hi,

I can see its possible to create a fragment that's source is an SQL query. If i add the fragment within an Element section within an RTF template is it possible to access the associated Element ID within the SQL query ? Is there some sort of tag like #Branch# that can be used to access the element id, ie somthing like #ELEMENT_ID# that i can add to my sql where clause ?

Regards,

Jon.

[Helmut Ortmann]

Hi,

I also missed the functionality of having the objectid at hand.

You can write a fragment script to collect the needed information. In the example.eap file you find an example to start from.

The drawback with fragment scripts is that on some PCs they work and on other they produce errors. I reported it to SPARX but still have no answer.

Helmut

[OpenIT Solutions]

Hi,

Thanks for the pointer. I've now got an SQL Fragment that pulls back the raw data in need by using the #OBJECTID# tag in my where clause.

However i also need to display a diagram associated with the OBJECTID as a custom tag within my fragment. Is this possible ? Any pointers on this one anyone ?

Appreciate any help,

Regards,

Jon.