2. PHPRunner General questions
  3. [SOLVED]  Filter Setting
This topic is locked
[SOLVED]

 Filter Setting

 		6/4/2015 1:18:39 PM
PHPRunner General questions
C
 cjsaputo author

I have a field named "draft". I have it set as a checkbox. When the checkbox is set the value is 1. I want to set the filter column to show only records whose value is not 1. I have entered <>1 but no records show at all. If i set the filter to =1 the one record shows. What can I enter in the filter to eliminate the records with no 1 in the field?
need2sleepDevClub member 6/5/2015



I have a field named "draft". I have it set as a checkbox. When the checkbox is set the value is 1. I want to set the filter column to show only records whose value is not 1. I have entered <>1 but no records show at all. If i set the filter to =1 the one record shows. What can I enter in the filter to eliminate the records with no 1 in the field?


=0
C
 		cjsaputo author 6/5/2015



=0


Have tried that but the results do not show any records. At one point PHPR actually filled in the filter for me with a value "= True" so I tried "= False". Neither of those gave me what I want. I also tried combinations of "not = True".
C
 		cjsaputo author 6/5/2015



Have tried that but the results do not show any records. At one point PHPR actually filled in the filter for me with a value "= True" so I tried "= False". Neither of those gave me what I want. I also tried combinations of "not = True".


I have resolved this. With some research I found I should have configured the field as tinyint(1). Now the values are 0 and 1 so I can check for =0.