Question

Search Syntax - Searching for documents where the OCR text doesn't contain something

Laserfiche Search and Retrieval Version 10

Updated September 13, 2019

asked on September 12, 2019 • Show version history

I am looking for away to search for OCRed text for a given document that doesn't contain specific phrases.

I can do it when looking for specific text.

({LF:Basic~="'offense/incident Report'", option="LTD"}) & {LF:LOOKIN="Framingham\Police\Records\2019 INCIDENTS"}

Something like Search documentId from documents where OCRtext not like '%xxxxx%'

If the client cannot do this what tables in the database store this information?

0 0

Answer

APPROVED ANSWER

replied on September 13, 2019 • Show version history

Good news: we now have a 10.3 search syntax version of that white paper! (the old whitepaper is still available)

While the - is the correct way to indicate exclusion, there are two things that will prevent the above query from running:

At least one inclusion criteria (in your example, the "Lookin" for within folder search) must come first
Operators such as -, &, and | should not be placed at the beginning of a phrase inside parenthesis

With those changes, you'd have:

({LF:LOOKIN="Framingham\Police\Records\2019 INCIDENTS"})-({LF:Basic~="'offense/incident Report'", option="LTD"})

1 0

Replies

replied on September 13, 2019

I think you can just put - in front of whatever text you want it to exclude. (See Advanced Search Syntax 8.3 white paper - which I can't seem to find a link I can put here. I generally just search for it when I need it)

(-{LF:Basic~="'offense/incident Report'", option="LTD"}) & {LF:LOOKIN="Framingham\Police\Records\2019 INCIDENTS"}

2 0

APPROVED ANSWER

replied on September 13, 2019 • Show version history

Good news: we now have a 10.3 search syntax version of that white paper! (the old whitepaper is still available)

While the - is the correct way to indicate exclusion, there are two things that will prevent the above query from running:

At least one inclusion criteria (in your example, the "Lookin" for within folder search) must come first
Operators such as -, &, and | should not be placed at the beginning of a phrase inside parenthesis

With those changes, you'd have:

({LF:LOOKIN="Framingham\Police\Records\2019 INCIDENTS"})-({LF:Basic~="'offense/incident Report'", option="LTD"})

1 0

You are not allowed to follow up in this post.

Question

Question

Search Syntax - Searching for documents where the OCR text doesn't contain something

Answer

Replies

Sign in to reply to this post.