Hi Dear Board masters,
When I search "like" statement, it gives me

The following errors occurred with your search:
Sorry - no matches. Please try some different terms.
The following words are either very common, too long, or too short and were not included in your search : like

I think that search query understand it as SQL like statement. In fact , there are lots of threads about Sql like operator.


G.Luck !

I think "like" is one of those very common words. However, Pat will give you the final answer!

Do you think that search mechanisms works on "very common words" or not ?
In programming logic there is no logic like you said.

Do you think that search mechanisms works on "very common words" or not ?
In programming logic there is no logic like you said.

To avoid excessive results, some trivial words are excluded vom Baanboard Search, e.g. "and" or "the".

"Like" is one of those words (the reason: look at your post above). ;)

It's not a bug, it's a feature!

I think that it's really needs. Could you please find me thread about like operator ? There is no need lack of time for something. This is programming logic. One time I lost 10 minute to find some threads.
I think that you should think twice ! or look at GOOGLE !

I think it was chosen to be from the “very common words” because it can have many meanings like the one in this sentence!

Anyway you can always use Google to help you search Baanboard like this:
http://www.google.com/search?hl=en&rls=com.microsoft%3Aen-us&q=like+site%3Abaanboard.com

- George

George it is really good solution for my case. I hope this is handled by baanboard.
This is thing that what I want !
Thanks George

J_hass is absolutely right. The like word is excluded by default by the forum software. However there is a way to include certain words back in and I have done this now for 'like'. The search index is being rebuild to include the new word and after that a search for 'like' should show results. Potentially alot of results!!

FYI: following words are excluded from search & indexing by default:


&amp, &quot, a, able, about, above, according, accordingly, across, actually, after, afterwards, again, against, aint, all, allow, allows, almost, alone, along, already, also, although, always, am, among, amongst, an, and, another, any, anybody, anyhow, anyone, anything, anyway, anyways, anywhere, apart, appear, appreciate, appropriate, are, arent, around, as, aside, ask, asking, associated, at, available, away, awfully, b, be, became, because, become, becomes, becoming, been, before, beforehand, behind, being, believe, below, beside, besides, best, better, between, beyond, both, brief, but, by, c, came, can, cannot, cant, cause, causes, certain, certainly, changes, clearly, cmon, co, com, come, comes, concerning, consequently, consider, considering, contain, containing, contains, corresponding, could, couldnt, course, cs, currently, d, definitely, described, despite, did, didnt, different, do, does, doesnt, doing, done, dont, down, downwards, during, e, each, edu, eg, eight, either, else, elsewhere, enough, entirely, especially, et, etc, even, ever, every, everybody, everyone, everything, everywhere, ex, exactly, example, except, f, far, few, fifth, first, five, followed, following, follows, for, former, formerly, forth, four, from, further, furthermore, g, get, gets, getting, given, gives, go, goes, going, gone, got, gotten, greetings, h, had, hadnt, happens, hardly, has, hasnt, have, havent, having, he, hello, help, hence, her, here, heres, hereafter, hereby, herein, hereupon, hers, herself, hes, hi, him, himself, his, hither, hopefully, how, howbeit, however, i, id, ie, if, ignored, ill, im, immediate, in, inasmuch, inc, indeed, indicate, indicated, indicates, inner, insofar, instead, into, inward, is, isnt, ist, it, itd, itll, its, itself, ive, j, just, k, keep, keeps, kept, know, knows, known, l, last, lately, later, latter, latterly, least, less, lest, let, lets, like, liked, likely, little, look, looking, looks, ltd, m, mainly, many, may, maybe, me, mean, meanwhile, merely, might, more, moreover, most, mostly, much, must, my, myself, n, name, namely, nd, near, nearly, necessary, need, needs, neither, never, nevertheless, new, next, nine, no, nobody, non, none, noone, nor, normally, not, nothing, novel, now, nowhere, o, obviously, of, off, often, oh, ok, okay, old, on, once, one, ones, only, onto, or, originally, other, others, otherwise, ought, our, ours, ourselves, out, outside, over, overall, own, p, particular, particularly, per, perhaps, placed, please, plus, possible, posted, presumably, probably, provides, q, que, quite, quote, qv, r, rather, rd, re, really, reasonably, regarding, regardless, regards, relatively, respectively, right, s, said, same, saw, say, saying, says, second, secondly, see, seeing, seem, seemed, seeming, seems, seen, self, selves, sensible, sent, seriously, seven, several, shall, she, should, shouldnt, since, six, so, some, somebody, somehow, someone, something, sometime, sometimes, somewhat, somewhere, soon, sorry, specified, specify, specifying, still, sub, such, sup, sure, t, take, taken, tell, tends, th, than, thank, thanks, thanx, that, thats, the, their, theirs, them, themselves, then, thence, there, theres, thereafter, thereby, therefore, therein, theres, thereupon, these, they, theyd, theyll, theyre, theyve, think, third, this, thorough, thoroughly, those, though, three, through, throughout, thru, thus, to, together, too, took, toward, towards, tried, tries, truly, try, trying, ts, twice, two, u, un, under, unfortunately, unless, unlikely, until, unto, up, upon, us, use, used, useful, uses, using, usually, v, value, various, very, via, viz, vs, w, want, wants, was, wasnt, way, we, wed, welcome, well, went, were, weve, werent, what, whats, whatever, when, whence, whenever, where, whereafter, whereas, whereby, wherein, whereupon, wherever, wheres, whether, which, while, whither, who, whoever, whole, whom, whos, whose, why, will, willing, wish, with, within, without, wonder, wont, would, would, wouldnt, x, y, yes, yet, you, youd, youll, your, youre, yours, yourself, yourselves, youve, z, zero

This is good new but I think that there is a wrong in search tool. Because when I search like operator firstly it should search thread's subject . Otherwise it gives me all "like" statement in every threads. In my opinion , Firt priority should be thread subject and second priority should be thread contents. When I search "like", it gives me almost all of thread there is no sequence. This feature should be done for baanboard. May be searching mechanisim is true but main point is subject, after that content. In google it gives me that what I want. (george's suggestion) .

Thanks for your attention.

Well that is the way the search option works and I cannot change much about that. There is a possibility to use MySQL full-text searching instead of a custom built index. However, switching to MySQL full-text search exacts a much higher load on server resources and that is not something I wish to try right now. Once we get the new server up and running we will have a good bit more power though and then we can give it a whirl.

PS: the new box has been ordered last week :)

Hi,
I was searching for a particular topic which like generated 515 hits. It was showing in excess of 17 pages. But when i tried to scroll to the 6th from the 5th page, it just showed up a message
"Sorry - no matches. Please try some different terms."..

I was just going to the 6th page...Is this a bug or a feature that i didnt know off...Its understandable if one were to be browsing like the 50th or 100th page...But here it wouldnt even go beyond 5...There were like 25 results per page..
If there werent any more results after 5th, then why would it show in excess of 17 pages?

sk

P.S: The keyword i was searching was "backup".

Hi Sukesh,

I tried the same as you both as administrator and as a regular user and each time I am able to page through all the results (>450 results). Can someone else try it as well?

I tried now it and it working well, however, I have encountered this problem once. It happened when I waited in the 5'th page (for example) for some time (15 minutes or more) and then clicked on next.

- George

Hi Pat,
Strange to say, its working now. I thought there was some restriction over the keyword "Backup" but then saw that it wasnt in your list..Things look ok now.

12pm - 1230pm was the time when i did the search...maybe the logs could help?

sk

Hi Sukesh,

Good to hear it works now. I think there are a number of factors that are working here:

default session timeout of 900 seconds (15 mins)
caching of search results

I have not verified this myself but I suspect that leaving a session idle for a long time in the middle of a search result could lead to unexpected results.