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
search "-cintanotes"
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
- CintaNotes Developer
- Site Admin
- Posts: 5002
- Joined: Fri Dec 12, 2008 4:45 pm
- Contact:
Re: search "-cintanotes"
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!
Will be fixed in Beta 2, thanks!
Alex
-
- Posts: 1324
- Joined: Tue Mar 08, 2011 11:15 am
Re: search "-cintanotes"
Thank you!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!
Thomas