I try to make a filter(year(@catalog('WORKSHOP_LAB_JLE')."PUBLIC"."Sales"."invoice_date")=@Prompt(Year)) in te Information Design Tool, but when I validate the query appear the next error
Error:
[Data Federator Driver] [Server] Encountered "," at line 6, column 43.
Was expecting one of:
"and" ...
"or" ...
"in" ...
"between" ...
<COMPARISON_OPERATOR> ...
"like" ...
"not" ...
"is" ...
")" ...
"+" ...
"-" ...
"*" ...
"/" ...
"**" ...
"//" ...
"%" ...
Causa del error
Encountered "," at line 6, column 43.
Was expecting one of:
"and" ...
"or" ...
"in" ...
"between" ...
<COMPARISON_OPERATOR> ...
"like" ...
"not" ...
"is" ...
")" ...
"+" ...
"-" ...
"*" ...
"/" ...
"**" ...
I am newbie and sorry if I post this discussion in the wrong discussion category