I am newer to Appian and in the cloud database in the SQL window trying figure out how to do a Parameter Query. I need to have the parameters in the query so it can be ran by other people as well on the fly.
I have this:
SELECT * FROM `accounts` WHERE `state` = :state and `county` = :county and `servcode` = :servcode and `area` = :area
How do I add these before the SELECT statement and give them the values?
so basically I want to be able to do something like this
@state = "IL",
@county = "Jackson",
@servcode = 2568
etc....
Then the query use those to run
Thank you Bill
Discussion posts and replies are publicly visible
Thank you for the responses, we are going to go another route on this. Thank you