How can attachments be validated.
Is there a way to check if an attachment field is empty?
Release : 16.1.1
The following query can be used as an example to query attachments that exist on a custom investment.
select name, code, attachments from odf_ca_tester
where attachments is not null
order by last_updated_date desc;
select a.id, a.created_date, a.created_by, a.LAST_UPDATED_DATE,
a.LAST_UPDATED_DATE, b.unique_name, a.name
from CLB_DMS_FILES a,
SRM_RESOURCES b
WHERE b.user_id = a.created_by
--where parent_folder_id = xxxxxxxx
ORDER BY a.created_date desc
NOTE: attachments is the id of custom object attribute of 'Attachment' type.
odf_ca_tester is an example table that is created