Can we add image to the query subject in FM ?

[Raghuvir]

hi all,

an we add an image to the query subject in framework manager ?

Thanks in advance!

[MFGF]

hi all,

an we add an image to the query subject in framework manager ?

Thanks in advance!

The best way to implement this is to have the images in a folder somewhere accessible to your web server. If you have the image names in your table, you can then use this image name item in a calculated item in your query subject which prefixes it with the URL of the folder the images reside in. Then in the properties of the calculated item, set the Display Type property to be Picture.

eg: images reside in a folder called Muppet on your network, and this has been added as a directory to your web server. Item containing image names is called 'Picture_name' in your database, and contains values such as 'paul.jpg', 'lynn.png', 'nimrod.gif' etc. Your calculated item in your query subject contains an expression such as 'http://<your web server>/Muppet/' + [Picture_name]. Set the Display Type property of this item to be Picture.

Cheers!

MF.

[Raghuvir]

Hi MFGF,

Thanks for the guidance.

what i m trying to here is, i want to add an image of birthday card in the email body in event studio, which i am not able to do.

so i m trying to incorporate the image in the query item and then use that query item in the email body.

do u think its the right way of approach ?

Thanks and Regards
Raghuvir

[cognostechie]

eg: images reside in a folder called Muppet on your network, and this has been added as a directory to your web server. Item containing image names is called 'Picture_name' in your database, and contains values such as 'paul.jpg', 'lynn.png', 'nimrod.gif' etc. Your calculated item in your query subject contains an expression such as 'http://<your web server>/Muppet/' + [Picture_name]. Set the Display Type property of this item to be Picture.

Cheers!

MF.

That proves that I don't visit this site as frequently as I used to  :(  and by the way, muppet is a reserved keyword in Cognos so you cannot have a folder with that name, it won't work !

[Lynn]

I think the muppet was only trying to preserve your secret identity ;D

[Raghuvir]

What i have done here is , i have used the GOSALES package in event studio and dragged the query item "Product Image" but when i trigger the event the mail body just displays the path for the image, but not the actual image in the email?

is there any way that the image will be displayed in the email ?