Method to determine if an attachment exists

[Scott Ness]

Hello community.  I'm creating a scheduled script that will copy an attachment from event to alert.  Is there a condition that can be included in "addEncodedQuery" that will determine if the record has an attachment?

At present, I have -

emAttach.addEncodedQuery('source=email^state=Processed^alertISNOTEMPTY^message_keyISEMPTY');

If possible, I would like to add an additional condition to ensure only records that have an attachment are included.

TIA

[AshishKM]

Hi Scott, 

Please check in sys_attachment table for each event record if attachment is there or not.

Apply filter on Table Name ( event table name ) and Table Sys Id ( sys_is of event record )

Thanks,

Ashish

Please mark correct/helpful if it helps you

[Scott Ness · Accepted solution]

Thanks for the reply, but not exactly what I was looking for.  However, I did determine that hasAttachments() will work.

[AshishKM]

Hi Scott, 

Hope that my answer helps you , if so please mark correct/helpful for other community members.

Thanks,

Ashish