[Vtigercrm-developers] Logical operators in List View searches?

[Alan Lord]

I had occasion the other day, when with a customer who uses vtiger 
Cloud, to try and filter a List View using the search boxes above the 
columns where I wanted to say NOT a text string.

This feature wasn't obviously available in the Cloud or in the Open 
Source versions and it struck me that it might actually be a good idea...

Could we come up with some basic rules to allow people to enter things 
like (for example):

!my_string (NOT my_string)

 >my_number, <my_number (greater/less than my_number)

Perhaps even somehow also being able to remove the implicit asterisks (% 
in SQL) in "my_search_value" so we can search more specifically for the 
start or end of a character string?


Obviously we would need some way to differentiate between a logic test 
such as "!" being part of the actual string value, and it being a 
logical test for the search... Perhaps escaping these tests with some 
other pre-defined char, e.g.

\!, or \<

Thoughts, comments?

Cheers & HNY

Al