Thank you Craig for reply me,
I am using this query in Dynamic Form to insert File Information in to “DynamicForms_CustomTable_624” Table.
“INSERT INTO {databaseOwner}[{objectQualifier}DynamicForms_CustomTable_624]
([UniqueCompletionID],[ResponseDateTime],[UserID],[IPAddress],[filename],[summary])
VALUES ('$(UniqueCompletionID)',GetDate(),$(UserID),'$(IPAddress)','$(filename)','$(summary)')”
In File Attachment Field
Alternative Upload Folder Folder1/Folder2
I used this Query to show File data in SGSV which is uploaded previously.
“Select Users.UserName AS [User Name], dateadd(hour,16, D.ResponseDateTime) as [File Upload Time],D.filename as [File Name],D.summary as Comments, D.IPAddress
FROM DynamicForms_CustomTable_624 as D
join Users on Users.UserID=D.UserID
join UserRoles on D.UserID=UserRoles.UserID
join Roles on UserRoles.RoleID=Roles.RoleID
where
Roles.RoleID=15”
Sir How I created Download link in this Query that show in SGSV.
Files are Saved in Folder1/Folder2.
Sir Please help me, I am stuck with this problem
Thank you.