Question on querying database

marcoc918

A Score Level 1

over 8 years ago

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...

Discussion posts and replies are publicly visible

Parents

0 ashish.deshmukh
A Score Level 1
over 8 years ago

There are couple of approaches I can suggest here,
1. Best approach would be to add one more column into DB to have full name. That will be the best approach to handle this situation with less overhead at Appian end.
2. Another approach as below,
You can handle this at Appian end also as per the attached code. Here, you need to make a call to use which approach as this may affect performance if the number of users are large.
Still let me know if this works.
Main Rule - Dropdown.txt
TEST_formUserData.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Reply

0 ashish.deshmukh
A Score Level 1
over 8 years ago

There are couple of approaches I can suggest here,
1. Best approach would be to add one more column into DB to have full name. That will be the best approach to handle this situation with less overhead at Appian end.
2. Another approach as below,
You can handle this at Appian end also as per the attached code. Here, you need to make a call to use which approach as this may affect performance if the number of users are large.
Still let me know if this works.
Main Rule - Dropdown.txt
TEST_formUserData.txt
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel

Children

No Data