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

Question

Question

Search for documents with same creation and document date

asked on August 21, 2014

I have a requirement to search for documents having the same creation date as document date, with document date being a template field. The advanced search syntax doesn't seem to handle this - is there another way via LFQL, Workflow or SQL?

0 0

Replies

replied on August 21, 2014 Show version history

The advanced search syntax should work unless I am missing something.  Here is the advanced search syntax for a field search called Date and the Date search for created on a certain day.

 

{[]:[Date]=""} & {LF:Created>=""}

 

Between the quotes of both you can put in the date.  Are you doing a specific date?  Or could it be at "where any time the dates match"?

0 0
replied on August 21, 2014

Hi Chris - yes we tried that already and although it works it isn't too practical to run it per date. Ideally we want it to run repository wide rather than a series of individual date searches. I imagine it would be an expensive query to run though but at least the individual option gives them a potential solution.

0 0
replied on August 21, 2014

Then something like this should work.  

 

 

 

 

Note that you have to be on Workflow 9.1 for the Creation Date tokens to be of use.  Basically you run a search for all documents that have the specific field you are looking for.  Then for each result found, retrieve that information and compare it to the current entries %creation date.  If they match, do something (not sure what you want that to be).  Could be move them, create shortcuts somewhere, etc.  Otherwise if they do not match, do nothing.  Of course run a test on a few docs to make sure this works.

1 0
replied on August 21, 2014

Thanks Chris. I mentioned to the client that a workflow would do what they want but like you say it's unclear what to do with the documents that match. I suggested adding a tag or creating shortcuts in a folder.

0 0
replied on August 21, 2014

What is the point of this search? Are they looking for documents that haven't changed at all or something like that?

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

Sign in to reply to this post.