Retrieve Image from db_image record

[HrithikN]

Hi Everyone,

I have a use case to retrieve the Image content of db_image table record.

We usually have a image field in db_image record where our uploaded image is stored.

Using the below script I tried retrieving the same image but the response is empty:

var grImage=new GlideRecord('db_image');

if(grImage.get('687fa131eb1301003eadeb29a206fe05'))

{

gs.info(grImage.image);

}

Could someone please help me in getting the uploaded image? I have to add it to an outgoing email text as signature.

Regards,

Hrithik.

[Voona Rohila · Accepted solution]

Hi @HrithikN 

There are 2 ways to do it

First way - 

Open that particular image and you will see a html code with path that's available.

Follow below steps 

Copy below highlighted part

In your notification, click on 'source code' icon and paste the content - The image will be attached.

Second Way : 

Click on the Image icon in your notification and give the Name of the db_image record( see screenshot below)

Third Way : 

If you want to achieve this with email script then use below logic

var grDbImage = new GlideRecord('db_image');
    if (grDbImage.get('687fa131eb1301003eadeb29a206fe05')) {
        //  gs.info('image: ' + grDbImage.getValue('name'));

        template.print('<img src="' + grDbImage.getValue('name') + '" width="300" height="450">');
    }

[HrithikN]

Thank you @Voona Rohila ,

The solution worked. 

Regards,

Hrithik.

[HrithikN]

Hi @Voona Rohila ,

Thank you so much. The solution worked for me.

Regards,

Hrithik.

[Ankur Bawiskar]

@HrithikN 

are you using this in email script?

If my response helped please mark it correct and close the thread so that it benefits future readers.