Baanboard.com

Go Back   Baanboard.com > Forum > General Topics > About Baanboard.com

User login

Frontpage Sponsor

Main

Poll
For ERP LN feature pack upgrade, what method of install are you using?
Installation Wizard into existing VRC
37%
Installation Wizard into new VRC
39%
Manual into existing VRC
3%
Manual into new VRC
21%
Total votes: 38

Baanboard at LinkedIn


Reference Content

Reply
 
Thread Tools Display Modes
  #1  
Old 4th May 2007, 10:34
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
Is there a bug on baanboard search tool

Hi Dear Board masters,
When I search "like" statement, it gives me
Quote:
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 !
Reply With Quote
  #2  
Old 4th May 2007, 11:00
george7a's Avatar
george7a george7a is offline
Guru
 
Join Date: May 2004
Location: Nazareth
Posts: 1,490
george7a is on a distinguished road
Baan: IVc, 5.0 b, 5.0 c, LN 6.1 - DB: MS SQL, Oracle - OS: Windows 2000, 2003 & UNIX
I think "like" is one of those very common words. However, Pat will give you the final answer!
__________________
_
George Abdo
NAZDAQ - Your Documents, Your Way.
Reply With Quote
  #3  
Old 4th May 2007, 11:13
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
Do you think that search mechanisms works on "very common words" or not ?
In programming logic there is no logic like you said.
Reply With Quote
  #4  
Old 4th May 2007, 14:29
j_hass's Avatar
j_hass j_hass is offline
Junior Member
 
Join Date: Oct 2003
Location: Germany
Posts: 11
j_hass is on a distinguished road
Baan: BaanERP LN 6.1 PPM - DB: Oracle - OS: IBM AIX / M$
Quote:
Originally Posted by mr_suleyman View Post
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!
Reply With Quote
  #5  
Old 4th May 2007, 14:41
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
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 !
Reply With Quote
  #6  
Old 4th May 2007, 14:46
george7a's Avatar
george7a george7a is offline
Guru
 
Join Date: May 2004
Location: Nazareth
Posts: 1,490
george7a is on a distinguished road
Baan: IVc, 5.0 b, 5.0 c, LN 6.1 - DB: MS SQL, Oracle - OS: Windows 2000, 2003 & UNIX
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&r...Abaanboard.com

- George
__________________
_
George Abdo
NAZDAQ - Your Documents, Your Way.
Reply With Quote
  #7  
Old 4th May 2007, 15:00
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
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
Reply With Quote
  #8  
Old 4th May 2007, 19:44
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
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:

Code:
&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
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #9  
Old 5th May 2007, 00:17
mr_suleyman's Avatar
mr_suleyman mr_suleyman is offline
Guru
 
Join Date: Aug 2004
Posts: 639
mr_suleyman is an unknown quantity at this point
Baan: Baan IV - DB: Oracle - OS: HP UX, IBM AIX
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.
Reply With Quote
  #10  
Old 7th May 2007, 16:23
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
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
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #11  
Old 3rd June 2007, 11:33
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
Question

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".
Reply With Quote
  #12  
Old 5th June 2007, 10:51
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
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?
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
  #13  
Old 5th June 2007, 10:57
george7a's Avatar
george7a george7a is offline
Guru
 
Join Date: May 2004
Location: Nazareth
Posts: 1,490
george7a is on a distinguished road
Baan: IVc, 5.0 b, 5.0 c, LN 6.1 - DB: MS SQL, Oracle - OS: Windows 2000, 2003 & UNIX
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
__________________
_
George Abdo
NAZDAQ - Your Documents, Your Way.
Reply With Quote
Sponsored Links
  #14  
Old 5th June 2007, 13:29
sukesh75's Avatar
sukesh75 sukesh75 is offline
Guru
 
Join Date: Dec 2002
Posts: 1,031
sukesh75 is on a distinguished road
Baan: Baan 4c - DB: SQL Server 2000 - OS: Windows 2003
Working!!

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
Reply With Quote
  #15  
Old 7th June 2007, 17:51
patvdv's Avatar
patvdv patvdv is offline
Board Master
 
Join Date: Aug 2001
Location: Belgium
Posts: 2,167
patvdv is on a distinguished road
Baan: n/a - DB: n/a - OS: AIX, HP-UX, Linux
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.
__________________
Regards,

Patrick Van der Veken - Admin & Founder - (c) 2001-2017 baanboard.com/baanforums.com
Reply With Quote
Reply


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
ERPJewels Hitesh Shah Third Party Products 10 6th November 2006 06:38
Baanboard.com Newsletter 2005 Nr. 4 patvdv About Baanboard.com 2 9th December 2005 14:10
new free Oracle security audit scoring tool petefinnigan Operating Systems & Databases 0 7th June 2004 20:14
Search for items: change the field to search on Pivo4c Manufacturing & Supply Chain 9 23rd January 2004 17:28
Baanboard Search Option baanprog About Baanboard.com 5 18th November 2002 22:18


All times are GMT +2. The time now is 01:39.


©2001-2017 - Baanboard.com - Baanforums.com