Submitted by Tom on 2010/01/26 03:53
Armando thought this a bug so I post here
 
  • Take any Numeric Field - e.g. Wxyz
  • Give some items a value of '0' (zero) in that field
  • Make that field the source ( i.e. Wxyz )
  • Items with entry of '0' dont show in the grid
This means I often have to create an extra (yes/no) field - because I cant trust a numeric field as grid source
 
Can add to Mantis

Comments

For numeric fields, the shortcut: "Wxyz" is not sufficient. You need to use the correct long form: "Wxyz is not null"
 
I'll see if I can do this transformation transparently.

Tom

2010/01/26 10:59

Permalink

[quote=Pierre_Admin]
For numeric fields, the shortcut: "Wxyz" is not sufficient. You need to use the correct long form: "Wxyz is not null"
 
I'll see if I can do this transformation transparently.
[/quote]
thanks Pierre, I suspect many other would get caught out with this as well so transparent would be good for the future !