How to assign Image in db_Image table to an Image field type?

eduzol · ‎08-23-2017

Hi team,

I just imported images using a zip file attachment into db_image table.

We also have a Images table in our scoped application with an image field and some additional metadata.

Now that I imported the images, how can I assign an imported image to a Image field in my application?

I looked into the Image field documentation : Add an image field , but found no instructions to do that.

Maybe I can use GlideRecord api?

Please help.

Kind regards.

-

Eduardo

eduzol · ‎08-29-2017

Hi Team,

After doing some additional research I found the solution which I will share for the benefit of the community:

Basically we can use GlideSysAttachment to link an image imported in db_image table to an existing IMage field in any scoped application table.

var ga = new GlideSysAttachment();

var attachments = ga.copy('db_image', yourImageAttachment.sys_id, 'ZZ_YYx_your_table',row.sys_id);

Thanks

Kunal Jha · ‎08-23-2017

Hi Eduardo,

Kindly explain the significance as to why you want to go anti clockwise instead clockwise.

If you want some image to be link to your image field just make image field as reference field and it should reference to db_image table.

else directly upload the image on to image field as field type as image instead uploading it to db_image and then trying it to bring it on form.

eduzol · ‎08-29-2017