Page 1 of 1

search "-cintanotes"

Posted: Mon Mar 19, 2012 1:00 am
by Thomas Lohrum
I have 874 notes. I search for "cintanotes" in "title+text". I get 33 records, regardless of the "search inside words" (siw) option. When i search for "-cintanotes" i get 841 records when siw is off. Fine. However i get 869 records when siw is turned on. I am confused about this search result. Any explanations?

Thomas

Re: search "-cintanotes"

Posted: Mon Mar 19, 2012 10:01 am
by CintaNotes Developer
Yes, this is a bug: the SQL produced is "NOT title LIKE '%cintanotes%' OR NOT text LIKE '%cintanotes%'", instead of "NOT title LIKE '%cintanotes%' AND NOT text LIKE '%cintanotes%'".
Will be fixed in Beta 2, thanks!

Re: search "-cintanotes"

Posted: Mon Mar 19, 2012 12:16 pm
by Thomas Lohrum
CintaNotes Developer wrote:Yes, this is a bug: the SQL produced is "NOT title LIKE '%cintanotes%' OR NOT text LIKE '%cintanotes%'", instead of "NOT title LIKE '%cintanotes%' AND NOT text LIKE '%cintanotes%'".
Will be fixed in Beta 2, thanks!
Thank you!
Thomas