Products

Solutions

Resources

Partners

Community

Blog

About

QA

Ideas Test

New Community Website

Ordinarily, you'd be at the right spot, but we've recently launched a brand new community website... For the community, by the community.

Yay... Take Me to the Community!

Welcome to the DNN Community Forums, your preferred source of online community support for all things related to DNN.
In order to participate you must be a registered DNNizen

HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListSearching on the True/False fieldsSearching on the True/False fields
Previous
 
Next
New Post
11/29/2007 1:21 PM
 

IMHO it does not make sense to search in a column that always contains either "true" or "false"


Cheers from Germany,
Sebastian Leupold

dnnWerk - The DotNetNuke Experts   German Spoken DotNetNuke User Group

Speed up your DNN Websites with TurboDNN
 
New Post
11/30/2007 3:31 PM
 

Searching for a True or False value doesn't make sense to you? I'm sorry, but that doesn't answer my question.

This module was created so that every data type is searchable EXCEPT the True/False type. To leave this data type out of the search capability, especially when it should be one of the easiest queries to craft, doesn't make sense to me. There are several uses that my website could make of this, and I would be willing to place a bet that others have wanted it as well but not been in enough of a "need it" situation that they asked the question of why it isn't possible. To not have this available sells the module short IMO.

I'll take it from your extremely vague response that the capability isn't there and that you have no interest in adding it for whatever reason. Thanks for the time and the responses. I guess I'll just have to hire a developer to craft the kind of module I need.

 
New Post
11/30/2007 4:50 PM
 

Michael, we are asking for your requirements. I need to second Sebastian that I also see can't recognize the sense for searching a boolean value, espically if you want to search for "true" or "false" as string. Best way would be a further enhanced search with new "is true/is false" operators.

Boolean values are not searchable, though you can filter for them.

However you can solve your requirements without hiring a developer.

Add a new column and use the data type "calculated column". Inside expression use the  name of your boolean column + "_udt_original". This transforms the boolean value into its string representation. This column is searchable.

 
New Post
12/4/2007 3:05 PM
 

Since neither of you can can imagine why anybody would need to search a true/false value, I'll show you a working example.

http://www.csea.org/search/findanea.asp

This search works by looking for whether or not the associated column in the database (a standard bit) is a 1 or a 0. Simple bit logic. True or False. In laymans terms: Find me a list of people that are in the zip code I provide and that are proficient in these things I have checked. Were it not possible to search for the boolean values, this entire operation would suffer a performance loss.  Even if I were to have designed this to use a varchar as the data type in the column and stored the values as either 1/0 or true/false, the functionality would still have been the same. We search based upon what is in the checkboxes. Those checkboxes could very easily be replaced by a dropdown list, and it would still work the same way. Find me a list of people that are in the zip code that I provide and are proficient in this thing. I have another, similar search in the members area of the website.

You, as the developers, have severely hampered your product by leaving the ability to search the True/False fields out of the module. You are the ones that control how the data is stored, so any complexity that is present is added by you and you alone, and there is no need for this to be a complex thing. You are the ones that control what options are in the dropdowns and how they work.

I'll try your fix, Stefan. It's only a bandage on the real problem, though.

 
New Post
12/4/2007 6:11 PM
 

Michael Bielski wrote

 

This search works by looking for whether or not the associated column in the database (a standard bit) is a 1 or a 0. Simple bit logic. True or False.

...
You, as the developers, have severely hampered your product by leaving the ability to search the True/False fields out of the module. You are the ones that control how the data is stored, so any complexity that is present is added by you and you alone, and there is no need for this to be a complex thing. You are the ones that control what options are in the dropdowns and how they work.

UDT uses a generic data model, there is no simple mapping between a UDT column and a database column. It is not simple bit logic anymore. No 0 or 1!  UDT is running a lot of tasks behind the scenes to let the users forget that they are not working against a simple data table.

Searching for Boolean is really a special task for UDT different to all other data types. We did not provide searching for Boolean out of two reasons:

  1. We could not imagine why it is needed.
  2. As it is different from the other types, we did not write a special search operator for this.

Please notice that I am using the past tense. We developers usually listen to our users, sometimes we are also able to learn.

PS: Your search link is not working.

 
Previous
 
Next
HomeHomeDNN Open Source...DNN Open Source...Module ForumsModule ForumsForm and ListForm and ListSearching on the True/False fieldsSearching on the True/False fields


These Forums are dedicated to discussion of DNN Platform and Evoq Solutions.

For the benefit of the community and to protect the integrity of the ecosystem, please observe the following posting guidelines:

  1. No Advertising. This includes promotion of commercial and non-commercial products or services which are not directly related to DNN.
  2. No vendor trolling / poaching. If someone posts about a vendor issue, allow the vendor or other customers to respond. Any post that looks like trolling / poaching will be removed.
  3. Discussion or promotion of DNN Platform product releases under a different brand name are strictly prohibited.
  4. No Flaming or Trolling.
  5. No Profanity, Racism, or Prejudice.
  6. Site Moderators have the final word on approving / removing a thread or post or comment.
  7. English language posting only, please.
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out
What is Liquid Content?
Find Out