The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
SLX Query Builder and null boolean fields
Posted: 26 Dec 07 10:01 AM
|
Having an issue with groups with conditions on boolean fields. Field values are T, F, '' or Null and condition is were fieldname <> 'T'. We have a large number of these fields they have been using for years and I really do not want to have to create a calculated field for each one if I can avoid it. I can run a script to convert all nulls to F but nulls will return unless I cleanup all the old forms the admin created for these to force a value for each new account created to populate these custom tables she created.
Any quick and easy suggestions to handle nulls or do I have to bite the bullet and cleanup? |
|
|
| |
|
Re: SLX Query Builder and null boolean fields
Posted: 27 Dec 07 8:00 AM
|
Figures! 
For the time being I have issued a work around to them to allow this to work which is to add dual conditions and group them...
(BoolField1 does not contain data OR BoolField1 <> 'T')
AND
(BoolField2 does not contain data OR BoolField2 <> 'T')
But apparently most users where out sick the day they taught grouping in math!
 As this seems to be over most users heads even though I put PICTURES in the white paper so I had to edit a lot of the groups for them!  |
|
|
|