Question

How can I search through Template Fields for "anything but"

Laserfiche Version 10 Search and Retrieval

Updated June 15, 2016

asked on June 15, 2016

I've discovered the NOT operator, but I am not having success with the use of it. What am I doing wrong?

I've tried -Administration; - Administration; * - Administration and they all complete the search with "No search hits found".

0 0

Replies

replied on June 15, 2016

for not to work there has to a - b. means it has to be something like this in advanced search.

{[Template for Folders]:[Department]="HR"} - {[Template for Folders]:[Department]="Administration"}

this will look for departments that are hr and not administration.

0 0

replied on June 15, 2016

Thanks, Junaid. I thought of that, but I don't want to have to add all of the other departments in the search parameters to get what I want. That would be tedious. I want this to be as simple as possible. I know I could ask Workflow to just change them all to Administration for me, but I also want to learn how to use the NOT operator in this fashion, as I'm the Laserfiche Specialist for our office so, I just want to know so I can teach others whenever this would be useful.

0 0

replied on June 15, 2016

you don't have to add all. use

{[Template for Folders]:[Department]="*"} - {[Template for Folders]:[Department]="Administration"}

everything but administration.

1 0

replied on June 15, 2016

Thanks, Junaid!

0 0

replied on June 15, 2016

You need to use the advanced search syntax, you can't inject the operators in the search UI. As you have it in the screenshot, it will search for "- Administration" as a string.

0 0

View 1 previous reply

replied on June 15, 2016

Okay, Miruna! Lets see, I've opened that up and tried a few places to add the NOT operator, but it's not accepting it. Where would you place it in this string:

{[Template for Folders]:[Department]="Administration"} & {LF:Name="*", Type="F"}

0 0

replied on June 15, 2016

It would be in between the criteria, sort of mirroring your sentence:

Everything ({LF:Name="*", Type="F"}) except (-) stuff with "administration" in the "department" field ({[Template for Folders]:[Department]="Administration"})

So: {LF:Name="*", Type="F"} - {[Template for Folders]:[Department]="Administration"}

1 0

replied on June 15, 2016

Okay, Miruna, that worked, so thank you very much!

Interesting though: It didn't work at first, but I knew it should, so I removed the Customize Search window for Field Search (Search by Template window) and left in the Name and Search Syntax windows open with the hard coded changes in the Advanced Search Syntax window, and then it worked!

0 0

replied on June 15, 2016

Right, sorry for not mentioning that all the open search blocks are combined. So if you keep the template search section open, that gets added to the advanced search syntax.

1 0

You are not allowed to follow up in this post.

Question

Question

How can I search through Template Fields for "anything but"

Replies

Sign in to reply to this post.