This sample uses SUBQUERY and select drop downs to create a dynamic dependent drop down based on the selection made in the first drop down. It works with the DNN users and roles information in your system. The lxFetch onchange event in the first select is what triggers a refresh in the module to display the filtered list in the second select.

Note: the queries in the subquery tag use aliases for the field names so that a potential conflict in field name duplication with the main listx query is avoided. You can also accomplish this with escaping, which I hate!

To use, copy, paste and load the text in the XML file attached into the XML section of your ListX View Options and LOAD.

Pauldes,

I've got another example here for dependent dropdowns. I'm hoping you can take a peek at it. I render the second subquery in an action variable based upon the selection in the first subquery. It seems like it is going to work for me, but for some reason the lxComboSelect does not seem to work for the subquery that gets rendered in the action variable. When the page is refreshed, I'd like to retain the values that have been selected in the dropdowns so I've assigned their respective values into session variables and use the session variable values for the lxComboSelect function.

Any help you can offer is appreciated.

Thanks, Chris

I don't use lxComboSelect, but if you want to retain values and have them as defaults for combo boxes in selected items, use COALESCE...
selecteditems="[COALESCE,MySVar,Session,MyFVar,Form,[myfieldvalue],,MyText,Text]"
This will display the first of the items in the statement that has a value.

Thanks man,

I have not played with coalesce yet, but it looks like I am going to! Very much appreciate the pointer.

Regards, Chris

Please let us know if this solves the problem.
Thanks,

This works great. In my case my initial table has multiples (the table is the state the customer resides in). The dropdown shows all of the multiples, how can I filter that?

are you saying you want the drop down list to only display certain values or that you want the drop down list to have a default value based on the user. What exactly does each drop down list show?

Sorry I was not clear.
The first dropdown box is the state, I have multiple rows for many states and all of the rows are showing in the dropdown list.
I want to filter so each state only shows once.
thank you!

For example;
AK
AK
AK
AL
AL
AL
AL ....ETC

Hi,

Try doing a SELECT DISTINCT in your SUBQUERY. This will return all the distinct values.

Thanks,
Sindura
R2integrated

Thanks that did it!