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

[Rubén A. Estrada Orozco]

I think maybe an additional select input with the options "does not
contain", "exact match", "starts with", "ends with", "greater than", "less
than", would be more user friendly. I wouldn't know how to resolve the OR,
AND, etc.. in a user friendly way.

On Wed, Jan 24, 2024 at 10:40 AM Martin Allen <
martin.allen at exe-squared.co.uk> wrote:

> 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/
>
> _______________________________________________
> http://www.vtiger.com/
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20240124/60dfeb87/attachment.html>