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.
The Window Mode for the first link was Side Panel and the other one, New Tab
For both links, the navigation parameters were the same: Field: ((FileID)) and Parameter: UploadFile.FileID.
Finally, the Result Grid
FileName: Name of the file
Name: allows you to access the File Maintenance screen
External Link
The DataField is an expression for which
I set the caption to External Link
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.
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.
The Window Mode for the first link was Side Panel and the other one, New Tab
For both links, the navigation parameters were the same: Field: ((FileID)) and Parameter: UploadFile.FileID.
Finally, the Result Grid
FileName: Name of the file
Name: allows you to access the File Maintenance screen
External Link
The DataField is an expression for which
I set the caption to External Link
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.
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.
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?
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.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.