You are viewing limited content. For full access, please sign in.

Question

Question

Laserfiche document date property compare

asked on December 13, 2020

I'm trying to create a simple search via Search Syntax or the Advanced Search option in the thick client that will identify documents that have been truly changed vs. documents that have not. I understand you can use the date option in a customized search to see when a document was created or modified...if the dates and time are the same, it was never modified as the modified time also reflects the creation time of the document. I'm trying to locate the documents where the modified and creation dates and times do not match. I have tried the various combinations of the search operators to no avail.  Maybe I'm going loony while working from home and not having contact with adults over the age of 30 but can someone please assist me.

0 0

Replies

replied on December 21, 2020

(Adult over 30  here wink)

The Laserfiche search syntax does not support comparing values from one field to another. You can get it from SQL:

select top 100 tocid, name from toc
where created < modified

 

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.