Indicate an error line in Advanced Query

Aggregates & Queries

When we try to run an Advanced Query, in the test button, to see if the query is having the expected behavior, it happens that sometimes we have errors and the error message is never clear (eg: after ')'). 

From what I suggest in continuation to my previous idea, of putting the numbering of the lines in the Adcanced Query, also indicate in this error message the line where we are failing. What do you think of this idea? It could help a lot.

Nuno Miguel Verdasca

Created on 15 Oct 2018
Comments (3)

Changed the category to Aggregates & Queries

Thank you very much.

The main problem with this is that the Platform doesn't send the query to the database the way you have laid it out. More specifically, the entire query is sent in just a couple of lines, there's a lot of wrapping going on.