Hi All,

First of all, I love this module. We are using DNN on an intranet, and this tool has a lot of potential to reorganize a lot of things.

ISSUE

I am trying to filter a list via a True/False check. This is to allow me to create a master list of items, and use the Boolean to filter the results onto three different lists on three different pages:

The three fields are:

Supervisor Guide, Employee Guide, and Clerical Guide - Each has a corresponding field named the same.

So what I have done is, in the filtering statement of the module, I use the following (for the Employee Guide list)

[Employee Guide]='true'

There are several items checked true for this field in my list of 20 or so items. I even looked at all the results in XML, and that field:

<Employee_x0020_Guide_UDT_Original>true</Employee_x0020_Guide_UDT_Original>   <Employee_x0020_Guide_UDT_Caption>true</Employee_x0020_Guide_UDT_Caption>

The Result? Nothing. No results. I did this same thing earlier with text data type (with yes/no as text) and made it work.

Any clues to what I may be doing wrong?

Form and List version: 6.2.0

Thanks in advance.

BB

Thanks for the reply. Much appreciated!

To be systematic, I put in double quotes as you stated. That resulted in this error:
>>
Data Binding Failed. This issue might be caused by an unsupported cast of a data type.
Error Description: Cannot interpret token '"' at position 1.
>>

I then proceeded to single quotes of '[Employee Guide]=true' and got a different error:
>>
Data Binding Failed. This issue might be caused by an unsupported cast of a data type.
Error Description: Filter expression ''[Employee Guide]=True'' does not evaluate to a Boolean term.
>>

I double checked the data in the database and these values appear to be correctly listed as True.

I started looking into Boolean operators but I am rusty and nothing failed to return an error or an empty or full list. No filtering value worked yet.

Thanks again for reviewing this. It seems odd that it doesn't work. Could it be something we failed to include in our install?

Brad Brunfelt