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
Welcome to the nuBuilder forums!
Please register and login to view forums and other content only available to registered users.
Please register and login to view forums and other content only available to registered users.
Problem with search results that includes dash ( - )...
-
- Posts: 9
- Joined: Tue Feb 26, 2013 9:46 am
- Location: Czech Republic - Prague
- Contact:
Problem with search results that includes dash ( - )...
- Attachments
-
- screenshot - search - results.PNG (306.22 KiB) Viewed 4874 times
-
- Posts: 503
- Joined: Thu May 24, 2012 2:08 am
- Location: Milan, Italy
- Contact:
Re: Problem with search results that includes dash ( - )...
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:
Max
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;
Max