Advance Query error

Advance Query error



I have an advance query that returns values when tested with input parameters, but when I try to run it in  a process it returns the following error: "Error in Advanced Query.....Incorrect syntax near ')'". The query has 17 joins (not sure if there is a limitation on this?)
Any suggestion is appreciated.



You are probably getting one of the arguments in an incorrect format, since you said using test query works.

Try to debug it and stop in the query you mention and check the variables being passed to see if you catch any suspicious value.

Best regards,