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?
Question
Question
Search for documents with same creation and document date
Replies
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"?
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.
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.
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.
What is the point of this search? Are they looking for documents that haven't changed at all or something like that?