I have a very long list of schools +30000.
Could this effectively handle such a thing or do you think it would be a big hit on performance?
Thanks,
Nathan
Hi Nathan!
We've used it with a few hundred records and it's very helpful there... I hadn't used anything above 500 records previously so I setup a new test for you.
I've updated the demo on our Modules site so that you can see an example with 200 choices and another with 2,000 choices. It's pretty fast in both cases!
http://modules.moorecreative.com/ForXModPro/CustomControlEnhancedListBox.aspx
Hi, would this control work in a situation where it would list DNN users?
Thanks!
Yes, it would, you can list anything that you have, whether a hard-coded list of options or a record set from a database query in the Control DataSrouce.
Within XMod Pro, you control what data is present within a control like this (whether a checkbox/radio list, drop down list or multi-select list) by either having hard coded options, or by connecting that control to a Control DataSource. Within the Control Datasource, you can pull any list of data that you need and can manipulate, rename, etc (anything possible with SQL) to the list.
In the end, the list has both a Text display value and a Data saved value. Both can be the same content from the data set, or it can be a text value such as "Red" which is displayed in the dropdown and a data value such as ID# 1138 which is saved to the form submission.
Often, we'll do a combination where we show the ID value in the text to the user in case they know that number and that helps it become searchable/filterable when typing...
So for example, we'd make the SQL query concatenate a text value of "Red (1138)" as the display text and "1138" as the data value to save.
Coming back around to the original question, yes, you could have a list of users with a simple "Select Username, UserID From Users" or it could be Users of a specific role, or users with some UserProfile property, etc by making the right SQL query.
If you get down to that and need a hand, let us know, we can write that query for you.
Thanks!
Moore Creative