Submitted by thorsten on 2010/09/22 04:08
Hi there,
 
how do I apply the grid filter syntax for the grid button filter drop down box if I want to filter for all items that do NOT match the criteria?
 
example:

I want to apply grid column filter to filter out all items that contain "test"
 
I tried:
is not "test"
not like "test"
not "test"
not test
not like test
is not test
etc.....
 
 
Thank you!
 
Best regards, Thorsten

Comments

 
I'm not clear from your post do you want to do this in the filterbox or in the column filter
- I dont think you can do this in the column filter
 
Also not clear do you mean (1) items with 'test' in a particular field, or (2) with 'test' anywhere in the item's fields
I cant help you with the latter but here is for (1) -
 
in the filter box (sourcebar) it would be:
MyTextFieldNameHere NOT like "*test*"
 
e.g.
Item NOT like "*test*"
would exclude items with 'test' in the Item field
 
 
It seems to me that the 'like' and the asterisks * are saying the same thing (twice) but you need both according to the manual page:
 
 

thorsten

2010/09/22 10:50

Permalink

Thank you Tom!
 
Actually, I know how to do it in the filterbox. But as I am in a grid where the defined filter is already pretty complex, I do not want to mess around in the filterbox any further. So I would like to apply the filtering in the column filter.

The filter should not show any items which contain a certain string. I only manage to do the opposite, showing all items which match the criteria...
 
So anyone has an idea how to do this?

thorsten

2010/09/23 05:14

Permalink

Thank you for your answer, Pierre.
 
It would be great if you could request that from the grid developer for future versions, that would be really helpful...
 
Regards, Thorsten

Pierre_Admin

2010/09/23 11:08

Permalink

A request was made. Lets all collectively cross fingers
 
[quote]
It would be great if exG2antt column filters for text columns could support the NOT operator (either using NOT or some symbol [Google uses the minus sign : "-"]). Users have requested this for some time now.

On this issue, it would be great if items listed in column filters could have checkmarks (left side) and users could select multiple ones (and automatically be OR'ed). Excel does this and it is a nice UI way of doing
[/quote]

Armando

2010/09/23 13:33

Permalink

Thanks... I'm crossing mine !