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
Solved! Go to Solution.
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.
Thank you so much, Philip! It worked :)