Retrieve Image from db_image record

HrithikN · 16 hours ago

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 · 14 hours ago

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">');
    }

Mark it helpful if this helps you to understand. Accept solution if this give you the answer you're looking for
Kind Regards,
Rohila V
2022-25 ServiceNow Community MVP

View solution in original post

HrithikN · 11 hours ago

Hi @Ankur Bawiskar ,

Yes I am trying it for email script.

Regards,

Hrithik.