Symptoms

Issue:
How to filter drop down list controls from one SQL table.

I want to implement a logic:
1. Person selects a date
2. Flight Numbers from this date are populated into "Flight Number" drop down list
3. Once the flight number was populated, From and To values are populated into the dropdowns.

Example:
1. User selects 22/09/2016
2. Flight Number automatically has choices of: 30 and 35
3. User selects Flight Number 35
4. From dropdown automatically has choices: DUB and BOS
5. User selects BOS
6. To dropdown automatically has only one choice: NYC
 

Diagnoses

Diagnosis:
Provided steps the client can follow to help resolve the issue.
 

Resolution

Sending resolution




Resolution:
The steps provided below helped fix the issue:
Steps:
------
1) Create a SmartObject from the SQL table via the SmartObject Tester tool.
2) Generate a item view from the SmartObject Via K2 Designer.
3) Edit the view and then change the relevant controls to drop down controls.
4) bind all three drop down controls to the same smart object and configure them as follows:
a) Screenshot 1
b) Screenshot 2
c) Screenshot 3
5) Now add an addition drop down control and set it to be invisible then bind it to the same smart object as the other three drop downs (Screenshot 4)
6) Now configure the calendar controls as per Screenshot 5
7) When that is done you have to structure your rules as per Screenshot 6 - 20