List box - multiple month selection and update SQL query

Question

Hi,

I have a concern wherein the requirement is to include multiple months selection (LIST BOX Interface tool) and replace the selection within the SQL query (Input data) in the WHERE clause.

What I understood so far is that if a user makes a selection for Jan-22 and Feb-22, then the result of the selection is:

Jan-21=false,Feb-21=false,Mar-21=false,………..Jan-22=True,Feb-22=True,…….Nov-30=False, Dec-30=False)

Need help with updating the SQL script with the users selection. Any help would be appreciated! Thank you in advance :)

Regards,

Rajat

philipmannering · Accepted Answer

Try using the Generate Custom List option. The Start Text and End Text is a single quote. The separator is ',' (a comma surrounded by single quotes)

Then, in the Action Tool the text to replace is,

'NOV-22', 'DEC-22'

This should replace your static values with a custom list of months selected by the user.