Dear Laserfiche Support Team,

I am currently using Laserfiche as our electronic document management and archiving system, and I have access to the Laserfiche database.

I would like to inquire whether it is possible to retrieve the creation date and last modification date of a transaction directly from the Laserfiche database using the transaction number (Document ID).

Specifically, I would like to know:

• Which database table(s) contain the transaction creation and modification dates?
• Can these dates be retrieved using the transaction number as a reference?
• Is there an official or recommended SQL query for retrieving this information?

I would appreciate your guidance on the correct and supported approach for obtaining this information from the Laserfiche database.

Best regards,
Abdulrahim Salah