Quick Search w/ Boolean Field

Yahoo Archive
1
A little more detail on mine. (8.03.407A)



I am using the OPEN boolean field.



In Quick Search:



Criteria column : OrderHed.OpenOrder

Caption: Open

Condition: =

Criteria Type: Value List

Criteria Value: <Empty>

Filter On Null: False



3 Entries on the value list (add these)

#1 - Display Member : Both / Value Member : <blank>

#2 - Display Member : Yes / Value Member : True

#3 - Display Member : No / Value Member : False



That is all I have. It recognizes the boolean flag and works fine.



Ross





-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Monday, April 12, 2010 4:31 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quick Search w/ Boolean Field



Alas, I get this (8.03.405):



The following application error was encountered:



Failed to enable constraints. One or more rows contain values violating
non-null, unique, or foreign-key constraints.



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@... ~ 734-864-5618 ~
www.advancedphotonix.com





-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Ross Hughes

Sent: Monday, April 12, 2010 5:02 PM

To: vantage@yahoogroups.com

Subject: RE: [Vantage] Quick Search w/ Boolean Field



I leave the comparison operator at EQUALS.



Enter three choices in the values list. One of them is labeled All and

leave the Value blank. Also, labeling it ALL puts it first in the list.



Ross



-----Original Message-----

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of

Brian W. Spolarich

Sent: Monday, April 12, 2010 3:54 PM

To: vantage@yahoogroups.com

Subject: [Vantage] Quick Search w/ Boolean Field



I want to do a Quick Search on a boolean field.







If I check the box, I get all of the records for which the field is

True.







If I uncheck the box, I get all of the records for which the field is

False.







How do I get <All> records? I tried using a MATCHES condition and

entered * but that didn't work.







-bws







--



Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /

Picometrix



bspolarich@...

<mailto:bspolarich@...> ~ 734-864-5618 ~

www.advancedphotonix.com <http://www.advancedphotonix.com>











[Non-text portions of this message have been removed]







------------------------------------



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have

already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and

Crystal Reports and other 'goodies', please goto:

http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:

http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:

http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links











------------------------------------



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links











------------------------------------



Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )

(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.

(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages

(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



http://groups.yahoo.com/group/vantage/



Individual Email | Traditional



http://groups.yahoo.com/group/vantage/join

(Yahoo! ID required)



vantage-digest@yahoogroups.com

vantage-fullfeatured@yahoogroups.com



vantage-unsubscribe@yahoogroups.com



http://docs.yahoo.com/info/terms/



[Non-text portions of this message have been removed]
2
I want to do a Quick Search on a boolean field.



If I check the box, I get all of the records for which the field is
True.



If I uncheck the box, I get all of the records for which the field is
False.



How do I get <All> records? I tried using a MATCHES condition and
entered * but that didn't work.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]
3
I leave the comparison operator at EQUALS.

Enter three choices in the values list. One of them is labeled All and
leave the Value blank. Also, labeling it ALL puts it first in the list.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Monday, April 12, 2010 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quick Search w/ Boolean Field

I want to do a Quick Search on a boolean field.



If I check the box, I get all of the records for which the field is
True.



If I uncheck the box, I get all of the records for which the field is
False.



How do I get <All> records? I tried using a MATCHES condition and
entered * but that didn't work.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
4
Oh, yeah...I forgot to mention that I make it a value list that defaults to
ALL.

As a prompt I think you only have the two choices.

Ross


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Monday, April 12, 2010 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quick Search w/ Boolean Field

I want to do a Quick Search on a boolean field.



If I check the box, I get all of the records for which the field is
True.



If I uncheck the box, I get all of the records for which the field is
False.



How do I get <All> records? I tried using a MATCHES condition and
entered * but that didn't work.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links
5
Alas, I get this (8.03.405):

The following application error was encountered:

Failed to enable constraints. One or more rows contain values violating non-null, unique, or foreign-key constraints.

--
Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix / Picometrix
    bspolarich@... ~ 734-864-5618 ~ www.advancedphotonix.com


-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Ross Hughes
Sent: Monday, April 12, 2010 5:02 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Quick Search w/ Boolean Field

I leave the comparison operator at EQUALS.

Enter three choices in the values list. One of them is labeled All and
leave the Value blank. Also, labeling it ALL puts it first in the list.

Ross

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Brian W. Spolarich
Sent: Monday, April 12, 2010 3:54 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Quick Search w/ Boolean Field

I want to do a Quick Search on a boolean field.



If I check the box, I get all of the records for which the field is
True.



If I uncheck the box, I get all of the records for which the field is
False.



How do I get <All> records? I tried using a MATCHES condition and
entered * but that didn't work.



-bws



--

Brian W. Spolarich ~ Manager, Information Services ~ Advanced Photonix /
Picometrix

bspolarich@...
<mailto:bspolarich@...> ~ 734-864-5618 ~
www.advancedphotonix.com <http://www.advancedphotonix.com>





[Non-text portions of this message have been removed]



------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have
already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and
Crystal Reports and other 'goodies', please goto:
http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto:
http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto:
http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links





------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note: You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links