Appian Community and Appian Academy are being upgraded. From July 24–August 3, the Appian Community will be in read-only mode. During this time, the site will be read-only and user registration will be disabled. We apologize for any inconvenience this may cause, but a more secure, stable, and performant Community experience is coming soon!

The new Appian Community launches August 3, followed by Appian Academy on August 7. During the migration, Appian Community Edition, Appian Academy, Documentation, Certifications, Instructor-led Customer Training, Partner Sales Training & Accreditation, and Forum (for Appian Partners and Customers only) will remain available.
  • State Not Answered
  • Replies 10 replies
  • Subscribers 23 subscribers
  • Views 4009 views
  • Users 0 members are here
Related Discussions
Home » Discussions » New to Appian

Parameter Query in Cloud Database SQL Window

williamm0010

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

Parents
  • 0

    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

Reply
  • 0

    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

Children
© 2026 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.