Problem with search results that includes dash ( - )...

[kettnev]

Hello,

we have identified a problem concerning search results in cases where the search string includes dash ( - ). For example we want to find a record according to a name of a company called Nate - national tech . When we write just Nate , then the result is ok, it returns the whole name of the company and the record. However when when we write Nate - then it returns nothing. The record is however found if we input "Nate - " (with quotes), then it finds the record.

The problem for us is that there are many items including dash in the company name.

I attach screenshots to be more specific...

Is it a bug or a kind of standard behaviour?

Regards,
Vít

[massiws]

kettnev,
In nuBuilder - sign (dash) in search field is used to change AND/OR in WHERE clause.

You can use search field in these ways:

• text in search field "text1 text2" => get all record WHERE {field} LIKE text1 AND {field} LIKE text2;
• text in search field "text1 -text2" => get all record WHERE {field} LIKE text1 AND {field} NOT LIKE text2;
• text in search field "-text1 text2" => get all record WHERE {field} NOT LIKE text1 OR {field} LIKE text2;
• text in search field "-text1 -text2" => get all record WHERE {field} NOT LIKE text1 OR {field} NOT LIKE text2;

If you want to get records where fields contains a dash, you must search " - " including double quotas in search field:

search.png (7.24 KiB) Viewed 4849 times

Hope this helps,
Max