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
So basically I am trying to create something like this in a .sql file to be able to use the import on the cloud database to run the query.
The below I can save to a .sql file and run it in sql server, now need to do something like this that will run in Appian from a .sql file.
DECLARE @state varchar(2) = 'IL',DECLARE @county varchar(50) = 'Jackson',DECLARE @servcode int = 54,DECLARE @area int = 28
SELECT * FROM accounts WHERE state = @state and county = @county and servcode = @servcode and area = @area
Also, I'm assuming there is a reason you can't give them an admin type interface in Appian and query the data dynamically via a!queryEntity()? We have a number of dynamic reports at the admin level to monitor data in the system, through Appian.