Hi, how do I get the last date of the attached signature file? Attached is the rpx.
Solved
Last Date from File Section
Best answer by Naveen Boga
NoteDoc table with UploadFileRevision to retrieve the file upload date. Please refer to the SQL script below and make the necessary changes to your report accordingly.
SELECT
SO.OrderType,
SO.OrderNbr,
UF.FileID,
UF.Name AS FileName
FROM SOOrder SO
INNER JOIN NoteDoc ND
ON ND.NoteID = SO.NoteID
INNER JOIN UploadFile UF
ON UF.FileID = ND.FileID;
+20NoteDoc table with UploadFileRevision to retrieve the file upload date. Please refer to the SQL script below and make the necessary changes to your report accordingly.
SELECT
SO.OrderType,
SO.OrderNbr,
UF.FileID,
UF.Name AS FileName
FROM SOOrder SO
INNER JOIN NoteDoc ND
ON ND.NoteID = SO.NoteID
INNER JOIN UploadFile UF
ON UF.FileID = ND.FileID;
Translate
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.