Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
8 replies
Subscribers
7 subscribers
Views
2282 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
General
Hi, I have created a CDT AirlineDetail and AirlineBooking. In the AirlineDe
sudhirp804
over 9 years ago
Hi,
I have created a CDT AirlineDetail and AirlineBooking. In the AirlineDetail I have added a fields AirlineID and AirlineName. I have created a form design for AirlineBooking and add a combobox to pick the AirlineID from AirlineDetail but it is not showing any list though the record exist in Airlinedetail table. In the form I have mapped the value and default value as =pv!airlinedetail.AirlineId.
Also, once I picked the AirlineID from the combobox the AirlineName should automatically displayed the value as per the table/CDT AirlineDetail.
e.g. AirlineID - 123, then Airlinename in the form textbox should shows "ABC Airlines". Please suggest how it can be done.
Thanks in advance for any suggestion you have provided for the below issue....
OriginalPostID-115477
OriginalPostID-115477
Discussion posts and replies are publicly visible
0
abhinavg
over 9 years ago
Use a query rule to fetch all Airline Details or Query Database service and stores the same in pv!airlinedetail and then use the same pv to pull the ids using pv!airlinedetail.AirlineId..
In combo box set the default values to pv!airlinedetail.AirlineId
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sudhirp804
over 9 years ago
I have created a query rule as rule input airlineid as integer and query condition AirlineID = AirlineID. Also, mapped this query rule in the field AirlineID. But I am getting this error.
ERROR:An error occurred while evaluating expression: =rule!SPGAirlineID() (Expression evaluation error in rule 'spgairlineid': Rule 'spgairlineid' has 2 parameters, but instead passed 0 parameters.) (Data Inputs).
Please suggest...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Navajith K
over 9 years ago
Sudhir, your rule SPGAirlineID() is expecting 2 input parameters as mentioned in the error message. please check if you are passing the parameters while calling the rule.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sudhirp804
over 9 years ago
Hi Navajith, I am adding only 1 input parameter as it only required in the queryrule. airlinedetailid as integer and query condition AirlineID = Airlinedetailid.I am not sure why it is expecting 2. Also calling this queryrule on the form fieldname AirlineID Value = =rule!SPGAirlineID() and Default Value = =rule!SPGAirlineID() and save into AirlineBookingDetails.AirlineId. Please suggest and correct me if the syntax error or rule which I have created is wrong.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
deepanc
over 9 years ago
Sidhir, Ensure the number of parameters you have used on the CDT and Check whether you are calling the right ID field on the Combo object.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sudhirp804
over 9 years ago
I have attached the process I have created. Please suggest after checking this and let me correct...
Airline Management.zip
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sudhirp804
over 9 years ago
Does anyone have any update on the below issue. I have checked the CDT AirlineBooking and AirlineDetail. Both have AirlineID field as integer. I need to pick the AirlineID value from the AirlineDetail table in the form AirlineBooking. I have created a query rule as an rule Input "AirlineDetailID" as an Integer value and Entity to Query "AirlineDetailMaster" and Query Condition is AirlineID=AirlineDetailID. I am call this query rule in the form field AirlineID Value "=rule!SPGAirlineID()" and Default Value "=rule!SPGAirlineID()" and save into "AirlineBookingDetails.AirlineId." Does the query rule condition is wrong or calling this query rule in the form field "AirlineID" is wrong.? Any insight will be helpful...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
sudhirp804
over 9 years ago
Can anyone have any chance to look into the below issue.I need to pick the AirlineID value from the AirlineDetail table in the form AirlineBooking. I have created a query rule as an rule Input "AirlineDetailID" as an Integer value and Entity to Query "AirlineDetailMaster" and Query Condition is AirlineID=AirlineDetailID. I am call this query rule in the form field AirlineID Value "=rule!SPGAirlineID()" and Default Value "=rule!SPGAirlineID()" and save into "AirlineBookingDetails.AirlineId." Does the query rule condition is wrong or calling this query rule in the form field "AirlineID" is wrong.? Any insight will be helpful...
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel