TMA attachments from file name

Hello,

We may need to check in 3 different database tables in order to identify which notice this is attached to. As an example for one of the attachment's, please try the following queries:

1. select ta_attachment_id, ta_url from tma_attachments
where ta_url like '%811.pdf%';

Once you have the ta_attachment_id, run the following query:

2. select tnoa_notice_id, tnoa_attachment_id
from tma_notice_attachments
where tnoa_attachment_id=<ID FROM QUERY 1>;

3. select tnot_works_ref
from tma_notices
where tnot_notice_id=<TNOA_NOTICE_ID FROM QUERY 2>;

Hope this helps.

Kind Regards

Fezan Khan

Thank you Fezan

I was hoping there was a way for the end users to do this in forms. Following you process I have now set this up in discoverer for the end users to query if required.

 

Regards,

Paul

Thank you Fezan

I was hoping there was a way for the end users to do this in forms. Following you process I have now set this up in discoverer for the end users to query if required.

 

Regards,

Paul