Document Generation - Images in notes aren't displayed properly after SQL filter

[EAPowerUser]

Hi all,

When I'm adding images to a text field e.g. input on test objects and export it via Generate Documentation, the image is displayed properly. Once I used a SQL fragment e.g. to filter objects and export input as a column (Select t_tests.input as input; custom> {input} <custom), the image is printed like:
<a href="$imageman://id=0;msg=Wireframing::Save;name=Save;type=Bitmap;"><font color="#0000ff"><u>Wireframing::Save</u></font></a>.

I'm using Image manager to add in the image into text fiel.

Best Regards

[Geert Bellekens]

It shouldn't work either way (notes fields don't support images), but what you are missing from your SQL fragment is to set it to formatted.

In you query you do something like

Code: [Select]

select o.Note as [description-Formatted] from t_object o where o.object_ID = #OBJECTID#
In the template you do

Code: [Select]

custom> {description.Formatted} <custom
This works for SQL server. You might need to change the dash to a dot for .eap files.

Geert

[EAPowerUser]

Hi Geert,

It worked!
You made my day. Thought I would lose SQL functionality on to get images printed correctly.

Thanks a lot!