Question

Advance Search Syntax to Retrieve documents based upon template field info

Laserfiche Search and Retrieval

Updated January 24, 2014

asked on January 24, 2014

So I'm trying to retrieve documents for a certain data range, for a certain template, that DOES NOT contain specific template field info. For example: Modified between Jan 1, 2014-Jan 10, 2014, Template Name= Accounts Payable where Field does not equal Paid, Approved by John, Approved by Inez.

I'm doing the following but continue to receive the following error: An Unrecognized character was encountered. [9086]

{[Accounts Payable]:[Status]=-"Pad","Approved by John","Approved by Inez"} & ({LF:Modified>="1/1/2014 12:00:00 AM", Modified<="1/10/2014 11:59:59 PM"}|{LF:Created>="1/1/2014 12:00:00 AM", Created<="1/10/2014 11:59:59 PM"})

1 0

Answer

APPROVED ANSWER

replied on January 24, 2014

The field search part should be

({[Accounts Payable]:[Status]<>"Pad"} |{[Accounts Payable]:[Status]<>"Approved by John"} |{[Accounts Payable]:[Status]<>"Approved by Inez"})

{[Accounts Payable]:[Status] not in ("Pad","Approved by John","Approved by Inez")}

2 0

Replies

replied on January 24, 2014

I wonder if it has to do with the '-' before "Pad". According to the Help documentation it states the following "(NOT) Valid search results match the search criteria that appear before the dash, but must not satisfy the search criteria that appear after the dash." You have nothing before the "-" so there is nothing to match.

0 0

You are not allowed to follow up in this post.

Question

Question

Advance Search Syntax to Retrieve documents based upon template field info

Answer

Replies

Sign in to reply to this post.