Not able to Open Attachments linked to MA through Query

[former_member207877]

Hi All,

I have written a Query related to attachments in Master Agreement with only two result fields MA ID and Attachment(in MA) name as Clickable.

Attachment name is Clickable but Iam unable to open it.

When i tried to click on attachment the below error error.

Please suggest me what modifications has to be done.

Thanks,

Raj.

[kushagra_agrawal · Accepted solution]

Hi Raj,

Use the below query in the result Field of attachment :

CASE C.DOC_IS_FILE WHEN 1 THEN '</FCI/USERSESSION/APP-PATH>/download/' <%+%> <%URL_ENC(C.DOC_DISPLAY_NAME)%> <%+%> <%CHR%>(63) <%+%> 'id=' <%+%>

<%URL_ENC(C.DOC_DISPLAY_NAME)%> <%+%> '~true~' <%+%> RTRIM(CAST(C.DOC_FA_OBJECT_ID AS CHAR(12))) <%+%>':'<%+%> RTRIM(CAST(C.DOC_FA_CLASS_ID

AS CHAR(12))) <%+%> '~' <%+%> RTRIM(CAST(C.OBJECTID AS CHAR(12))) <%+%> ':2003~' <%+%> RTRIM(CAST(C.DOC_SIZE_IN_KB AS CHAR(12))) <%+%> '~2003~null'

ELSE C.DOC_REFERENCE END AS LATEST_LINK

Hope it would help.

Thanks

Kushagra A

[Former Member · Accepted solution]

Hey Kushagra,

If I have to bring the Contract file to my local desktop, then how can I use: /FCI/USERSESSION/APP-PATH in Custom script

Or Else do I need to use the FTP only as per below link:

My requirement is to extract the Latest version of all the Master Agreement in local Desktop when I execute a Script.

My understanding is to use the Standard query: "My Agreements and Contracts" and get the list of latest version of Contract document out of that...

I want to now FTP the Contract Word file data to local system.

Thanks & Regards

Manish Agrawal

[Former Member]

Hi Raj,

Could you pls elaborate on your issue.

What is the page you are expecting if you click on Attachment name links.

Regards,

Vignesh