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 the query has to be saved into a .sql file, the other users need to be able to go to the cloud database and import the .sql file for it to run. So some how I need to see if there is a way to write the parameterized sql statement with the parameters defined and assigned values with the select statement.
I do not know whether this is supported by phpMyAdmin.
What is the purpose of this? Why do others need to query data directly in the database?
There are other admins as well, and they are wanting .sql files written for queries they can run on the fly to check data, but they do not want to supply the parameters, they are wanting them set. Not seeing anything that shows how to do this so you may not be able to....
OK, but what is the purpose of doing this? System health? Data integrity? If this needs to be done frequently, why not create a stored procedure and run this in an interval. Store the results in a table and show that on a screen in Appian.