How can we check if the record has an attachment in list view

divya_dattatray · ‎10-26-2016

How can we check if the record has an attachment in list view. As now we have to open every record to see if the record has an attachment.

so want to know if record has an attachment from list view itself, how we can achieve this.

ChrisBurks · ‎10-26-2016

Another way that is possible is using the hasAttachments() on the sys_ui_style table for the record. For instance if I wanted an icon or color change to indicate that the record has an attachment in the list view I could setup a style like so:

And if the record has an attachment it will display like below (I didn't have a paperclip icon 😞

(Notice the little yellow document icon)

I know, aesthetically it's not all that pretty. But it's an option. Perhaps maybe if the field were just an empty field and then this style placed on that field it may look better.

View solution in original post

Brad Tilton · ‎10-26-2016

Check the 3rd item in this wiki article called: Display Whether Tasks Have Attachments in List View

http://wiki.servicenow.com/index.php?title=Useful_Attachment_Scripts

divya_dattatray · ‎10-26-2016

what should be the type of the field "has attachment".?

Brad Tilton · ‎10-26-2016

True/False or Checkbox

divya_dattatray · ‎10-26-2016

HI Brad,

I have tried this, but the value of "u_has_attachment" field is showing False for every record.