URGENT Logic of filtering values from a declare page is needed.
We have the following requirement needs to be done asap. Please help us.
1.We need to pull some 120 rows of data from sql and load it in a declare page. From that declare page we need to filter on specific value and populate in a ddlb.
We have written an activity to load the data in a declare page that is working fine.In the below screen the declare page contains values.
Here we need to filter out the logic based on Code_ctgy_Code=DTMenus/DTSubmenus/ and populate only the value of Code_desc1_tx corresponding to DTMenu/DTSubmenu in a ddlb. This is very urgent. Please tell us how can we achieve this.
We tried writing when condition by executing in a loop of this pxresults it is not working. Please help
@Sahup....The problem is..depends on the first ddlb value change second value will come depends on second ddlb change third ddlb value will come..each ddlb contains 10 values..so if I hit SQL for every time it will impact the performance.. That's why we pulled into data page from that we can do manipulations
Lets say you have 3 drop downs, Configure the data page to show results in your first DDLB which i feel is drop down list box. Now configure your second ddlb to show results based on the first ddlb value. So the source od your second ddlb will be another data page which takes the first value as a parameter. Similarly the third will be another data page which accepts the first and second as paramters. Remember the second and third data pages need not hit the db again, you can use the source data page and copy the required values from it.