TMA attachments from file name

I have a number of files that have been uploaded via TMA to send the Statutory undertakers. The undertaker has responded saying they can’t access certain files. After investigating, the files have no size. There must have been an error uploading them.

Is there a way to see from the attachment URL which notice is linked?

I have looked in “Document” (DOC0100) as I would if this was a PEM or Asset attachment. None of the TMA attachments are registered here. I could look at all sent items in Monitor web services but without going into each one I would not know which have attachments.

Parents
  • 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

       
    This is a test

    Answer Verified By: Paul Withington 

Reply
  • 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

       
    This is a test

    Answer Verified By: Paul Withington 

Children