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



How to search against multiple fields (date or text). The Field would be a destruction date.

asked on September 10, 2014 Show version history

I'd want to search against the fields (we have multiple destruction date fields spread across multiple templates) and show the results that have a date of 01/01/2014 or this possible?


0 0


replied on September 10, 2014 Show version history

Hi Josh,


If the same field is present in multiple templates you can simply search on that field individually. This will bring back any result matching the date range you put in, regardless of template.


However, it sounds like you instead have multiple separate fields that store destruction dates. If this is the case, you can use advanced search syntax to return all entries that have the date range you want in either field A, or field B, or field C, etc. This search, for example, would pull back all documents with a value of today's date or before in either of two fields (Destruction Date or Destruction Date 2). 

                    {[]:[Destruction Date] <="09/10/2014"}|{[]:[Destruction Date 2] <="09/10/2014"}


When working with advanced search syntax, a great place to start is by running a search that's close to what you want with the Advanced Search option displayed as well. This will allow you to see what syntax is being used for the search you ran. From there you can use what was generated as a starting point for your own modifications. You can read more about advanced search syntax in the Laserfiche Advanced Search Syntax whitepaper.

5 0


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

Sign in to reply to this post.