Question

Laserfiche Lounge

Syntax Error when searching with quotes

Administration

Updated June 28, 2019

asked on June 26, 2019

When conducting a quick search at the top of the entire repository, an error is received – conducted a search for “resolution” using the quotes to search specifically for this word. AN error occurred: "A syntax error was encountered while processing the search or query statement. [9084]"

See picture. It works for me on my computer no problem, but this user has an issue.

Picture.jpg (41.71 KB)

| Download

0 0

Answer

SELECTED ANSWER

replied on June 26, 2019 • Show version history

It's most likely the case that your custom syntax has quotes around the search term token, like so:

({[My Favorite Template]:[That One Field] = "%(SearchTerm)"})

Which means it becomes

({[My Favorite Template]:[That One Field] = ""example search term""})

and the "" is what causes your syntax error. I was able to reproduce this.

On version 10.4 of Laserfiche, I was able to remove the quotes around the %(SearchTerm) token and successfully run the search, but it means that the quotes are no longer used in your custom quick search.

If you share the syntax you are using for the custom search and why/when you need the quotes, I may be able to suggest a viable solution.

1 0

Replies

replied on June 26, 2019 • Show version history

Could you get a screenshot that shows what quick search options are selected?

EXample:

Quotes are generally supported in quick search, so if you are seeing a user-specific issue, it could be related to which options they have selected, especially if there is a custom quick search like in my screenshot.

It would also be helpful to see the search syntax, which should be visible if you click "OK" on that error dialog, then expand the search tab on the left to show the syntax:

0 0

replied on June 26, 2019

Thanks I will check tomorrow and report back, but I'm thinking there is a saved search we created months ago that might be selected. Any reason why it quotes wouldn't work if a saved search was selected. I'll report back tomorrow am. Thanks. Denny

0 0

SELECTED ANSWER

replied on June 26, 2019 • Show version history

It's most likely the case that your custom syntax has quotes around the search term token, like so:

({[My Favorite Template]:[That One Field] = "%(SearchTerm)"})

Which means it becomes

({[My Favorite Template]:[That One Field] = ""example search term""})

and the "" is what causes your syntax error. I was able to reproduce this.

If you share the syntax you are using for the custom search and why/when you need the quotes, I may be able to suggest a viable solution.

1 0

replied on June 28, 2019

Yes it was a saved customized search we had tested out last year that was checked off. See pictures. We just deleted it and now the user can search like others. You can mark this post as answered! Thank you!

Question

Question

Syntax Error when searching with quotes

Answer

Replies

Sign in to reply to this post.