Query Syntax for referencing variables outside of the query

[jscam]

Can anyone help in explaining how to properly use outside variables
from within the Google API query - example:

query.setQuery('SELECT D,sum(E) WHERE Year(A) = 2011 group by D');

instead of using 2011 as a year, i have a variable var reportingYear
declared as a global variable that is manipulated in a method as a
dropdown menu changes its value with user interaction.

I am at a loss how to incorporate this into the query as the variable
changes.

query.setQuery('SELECT D,sum(E) WHERE Year(A) = `reportingYear` group
by D');

Any help appreciated - thanks

[asgallant]

query.setQuery('SELECT D,sum(E) WHERE Year(A) = ' + reportingYear + ' group by D');  

[jscam]

thanks