• State Not Answered
  • Replies 4 replies
  • Subscribers 8 subscribers
  • Views 1849 views
  • Users 0 members are here
Related Discussions
Home » Discussions » User Interface

Question on querying database

marcoc918
A Score Level 1

Hi to everyone,

suppose to have a database table called APAC_REQUEST_MANAGER made in this way:

USERNAME REQUESTOR_NAME REQUESTOR_SURNAME COUNTRY
Clerian001 Andrea Clerici Cn
casalal001 Andrea Casalucci Cn
cattagi001 Giuseppe Cattaneo Cn
cattagi001 Giuseppe Cattaneo Jp
cuvama Marco Cuva Jp

I've created a sail form with two different dropdown field:
.Country, with value determinated by a query rule on this table
.Requestor, where i want to use a query rule that, depending on the country selected on the previous form, will make a query on the database and will have as choice Label the REQUESTOR_NAME + REQUESTOR_SURNAME ordered in an alphabetical way an...

OriginalPostID-200799

OriginalPostID-200799

  Discussion posts and replies are publicly visible

Parents
  • 0
    A Score Level 1
    ...d as choice Values the corresponding USERNAME.

    Before Sail i will use a query database node with this query SELECT DISTINCT USERNAME, REQUESTOR_NAME || ' ' || REQUESTOR SURNAME FROM APAC_REQUEST_MANAGER WHERE COUNTRY=ac!country ORDER BY REQUESTPR_NAME || ' ' || REQUESTOR_SURNAME, i will save the result on the multiple text pv!username and pv!requestorNameSurname.

    My question is if there is a way to use one ore more query rule that replicate this result so that i can use it on the form and the value of the second dropdown will be dinamical?
Reply
  • 0
    A Score Level 1
    ...d as choice Values the corresponding USERNAME.

    Before Sail i will use a query database node with this query SELECT DISTINCT USERNAME, REQUESTOR_NAME || ' ' || REQUESTOR SURNAME FROM APAC_REQUEST_MANAGER WHERE COUNTRY=ac!country ORDER BY REQUESTPR_NAME || ' ' || REQUESTOR_SURNAME, i will save the result on the multiple text pv!username and pv!requestorNameSurname.

    My question is if there is a way to use one ore more query rule that replicate this result so that i can use it on the form and the value of the second dropdown will be dinamical?
Children
No Data
© 2024 Appian. All rights reserved.
We want to hear from you! Submit a review on Gartner or G2.