Question

Advanced search syntax field not in

Laserfiche Search and Retrieval

Updated April 3, 2019

asked on April 3, 2019 • Show version history

I am trying to find all contracts EXCEPT those with the contract type "ECO PASS". I have tried multiple different searches, all yielding no results.

When I run the search for contracts WITH the type "ECO PASS", I get 290 results. The syntax for this is:

{[FIN Contracts]:[AC Contract Type]="ECO PASS"} & {LF:Name="*", Type="F"} & {LF:LOOKIN="UTA\F.01. Office of Finance\F.04. Supply Chain Department\Contracts"}

Here's the search syntax's I've tried to use which exclude "ECO PASS":

{[FIN Contracts]:[AC Contract Type]<>"ECO PASS"} & {LF:Name="*", Type="F"} & {LF:LOOKIN="UTA\F.01. Office of Finance\F.04. Supply Chain Department\Contracts"}

{LF:Name="*", Type="F"} & {LF:LOOKIN="UTA\F.01. Office of Finance\F.04. Supply Chain Department\Contracts"} - {[FIN Contracts]:[AC Contract Type]="ECO PASS"}

Any other suggestions?

0 0

Answer

SELECTED ANSWER

replied on April 3, 2019 • Show version history

Hi Rex,

EDIT: Forget the first post. Try something like this:

{LF:Name="*", Type="F"} & {LF:LOOKIN="UTA\F.01. Office of Finance\F.04. Supply Chain Department\Contracts"} & {[FIN Contracts]:[AC Contract Type]="*"} - {[FIN Contracts]:[AC Contract Type]="ECO PASS"}

I got vastly different different results when adding/excluding the & {[FIN Contracts]:[AC Contract Type]="*"} term.

YMMV.

Best,

Rob

0 0

Replies

replied on April 3, 2019

That's puzzling, your syntax looks correct to me.

You get 290 results from including ECO PASS but zero results when you exclude it? How many results do you get without specifying any template:field info?

 {LF:Name="*", Type="F"} & {LF:LOOKIN="UTA\F.01. Office of Finance\F.04. Supply Chain Department\Contracts"}

Hopefully 290.

When all else fails try it with parentheses.

({LF:Name="*", Type="F"}
&{LF:LOOKIN="UTA\F.01. Office of Finance\F.04. Supply Chain Department\Contracts"})
-{[FIN Contracts]:[AC Contract Type]="ECO PASS"}

0 0

You are not allowed to follow up in this post.

Question

Question

Advanced search syntax field not in

Answer

Replies

Sign in to reply to this post.