Skip to main content
Solved

External Link from File Maintenance


Hi,

I want to create a Generic Inquiry (GI) to retrieve the "External Link" associated with a file from the File Maintenance screen. I tried the "UploadFileWithIDSelector" DAC, it doesn't display the external link for the file.

Ultimately, i would like to have an Active Link on my GI, allowing users to click on the External Link to view the attached file.

Many Thanks

 

 

 

Best answer by Eric Ratté

The link to files is always the same, i.e. the URL of the site + /(W(2))/Frames/GetFile.ashx?fileID= followed by the FileID.

  1. I used the UploadFile table.
  2. I created 2 navigation targets, one to display the file on a side panel and the other one to obtain a hyperlink on the result grid. 
    1. Link of both targets where the same, i.e. https://dev.localhost.com/(d.W(2))/Frames/GetFile.ashx?((FileID)).
    2. The Window Mode for the first link was Side Panel and the other one, New Tab
    3. For both links, the navigation parameters were the same: Field: ((FileID)) and Parameter: UploadFile.FileID.
  3. Finally, the Result Grid
    1. FileName: Name of the file
    2. Name: allows you to access the File Maintenance screen
    3. External Link
      1. The DataField is an expression for which
      2. I set the caption to External Link
      3. Here is the expression ='https://dev.localhost.com/(W(2))/Frames/GetFile.ashx?fileID='+CStr([UploadFile.FileID])                                              You have to change the ID to string to concatenate it with the remaining of the expression.
      4. Finally, to be able to click on the path written by the expression, you need to clear the option Default Navigation and select the link set at the Navigation tab of the GI via the field Navigate To.

The GI is in attachment, you can import it if need be.

 

View original
Did this topic help you find an answer to your question?

4 replies

Eric Ratté
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • 25 replies
  • Answer
  • January 26, 2024

The link to files is always the same, i.e. the URL of the site + /(W(2))/Frames/GetFile.ashx?fileID= followed by the FileID.

  1. I used the UploadFile table.
  2. I created 2 navigation targets, one to display the file on a side panel and the other one to obtain a hyperlink on the result grid. 
    1. Link of both targets where the same, i.e. https://dev.localhost.com/(d.W(2))/Frames/GetFile.ashx?((FileID)).
    2. The Window Mode for the first link was Side Panel and the other one, New Tab
    3. For both links, the navigation parameters were the same: Field: ((FileID)) and Parameter: UploadFile.FileID.
  3. Finally, the Result Grid
    1. FileName: Name of the file
    2. Name: allows you to access the File Maintenance screen
    3. External Link
      1. The DataField is an expression for which
      2. I set the caption to External Link
      3. Here is the expression ='https://dev.localhost.com/(W(2))/Frames/GetFile.ashx?fileID='+CStr([UploadFile.FileID])                                              You have to change the ID to string to concatenate it with the remaining of the expression.
      4. Finally, to be able to click on the path written by the expression, you need to clear the option Default Navigation and select the link set at the Navigation tab of the GI via the field Navigate To.

The GI is in attachment, you can import it if need be.

 


  • Freshman I
  • 5 replies
  • August 3, 2024

Hi Eric,

I’m attempting something similar in my GI where I’m mapping attached files to the expense receipts. I have EPExpenseClaimDetails and UploadFile in my GI but cannot join them through noteID or fileID. How should I connect them?

Thanks,

Eric


Eric Ratté
Jr Varsity I
Forum|alt.badge.img+1
  • Jr Varsity I
  • 25 replies
  • August 3, 2024

Hi,

 

I made it work by adding a relation between:

1- UploadFile and UploadFileWithData based on FileID=FileID and then,

2- another relation between UploadFileWithData and EPExpenseClaimDetails based on NoteID=NoteID.

 

A file can be linked to multiple documents, and one document can hav multple documents attached. Therefore, a middle DAC is needed to map which files are attached to which documents.

 

Thanks, 


  • Freshman I
  • 5 replies
  • August 6, 2024

Thank you, Eric.

I made a similar connection using NoteDoc as my middle DAC. 

Eric


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings