Query tool???: query failed to execute. Unable to complete operation,

[JamalNUMAN]

Query tool???: query failed to execute. Unable to complete operation,

I tried to use the ???Query tool??? recently available to search values based on multiple fields/operations. Unfortunately, I got the message below (despite the fact that the value I???m searching is there!):

[ATTACH=CONFIG]24874[/ATTACH], [ATTACH=CONFIG]24875[/ATTACH]

What might be the issue here?

Sample data is attached


Thank you

Best

Jamal

[BrianLeroux · Accepted solution]

The single quote in your selected value looks supsect to me. I would imagine that the query string looks something like Where CommunityNameForParcel_English = ''Atria'. That would cause and error because the first 2 quotes closed eachother out and the rest of the line is invalid. Id would be very easy to use Fiddler to check the query being sent to see if this is the case.

[Anonymous User]

Original User: Jamal432@gmail.com

The single quote in your selected value looks supsect to me. I would imagine that the query string looks something like Where CommunityNameForParcel_English = ''Atria'. That would cause and error because the first 2 quotes closed eachother out and the rest of the line is invalid. Id would be very easy to use Fiddler to check the query being sent to see if this is the case.

Thank you Brian for the answer.

Perfect. I tried to choose other values which don�??t contain quote and it works fine.

[ATTACH=CONFIG]25081[/ATTACH]

By the way, in the ADF, it works despite having quotes within the values

Best

Jamal