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

[Martin Allen]

Google already uses some fairly 'universal' (or at least very widely known ) search parameters like  - (minus sign) for excluding words, and " (double quotes) for indicating an exact phrase of multiple words, and OR as well for some basic logic... would be a good idea to copy similar syntax?

-----Original Message-----
From: vtigercrm-developers-bounces at lists.vtigercrm.com <vtigercrm-developers-bounces at lists.vtigercrm.com> On Behalf Of Alan Lord
Sent: Wednesday, January 24, 2024 10:42 AM
To: vtigercrm-developers at lists.vtigercrm.com
Subject: [Vtigercrm-developers] Logical operators in List View searches?

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

_______________________________________________
http://www.vtiger.com/