Community
Showing results for 
Search instead for 
Do you mean 
Reply

Limited keyword search to 1000 records

Copper Contributor
Posts: 24
Country: United States

Limited keyword search to 1000 records

Can anyone shed light on why "key word" searches are limited to only returning the first 1000 matches?

 

SQL 2005 is more powerful than that!

Bronze Elite Contributor
Posts: 2,548
Country: New_Zealand

Re: Limited keyword search to 1000 records

Interesting. I didn't know there was a limit. However I can understand that it could help to stop unecessary lookups that might unecessarily load up resources. You could do a pre lookup of groups of records of 1000 and then run the Keyword Search on that reduced data set 

Graeme Leo
Xact Software - consultants and developers
Follow us on Twitter and check out our Blog


Copper Contributor
Posts: 9
Country: Australia

Re: Limited keyword search to 1000 records

Yes, typically we have overcome this by narrowing your list down (by doing a lookup) before doing your keyword search, then selecting "Current Lookup" when you do the keyword search. Hope that helps.
Cedric Amoyal
ACT! Certified Consultant
The Contact Group
www.thecontactgroup.com.au
Copper Contributor
Posts: 24
Country: United States

Re: Limited keyword search to 1000 records

Neither really gives one the ability to search across ALL records. Regarding resources, that is a user issue and should not be limited by Sage - with SQL being powerful and compute power becoming limitless - there is no earthly reason for this type of limitation.
Copper Contributor
Posts: 9
Country: Australia

Re: Limited keyword search to 1000 records

I'm sure the folks at Sage have their reasons for limiting this - just not sure what they are.
In every instance we have ever been posed with this question before, the client has quickly and easily found a workable solution using the "lookup before keyword search" approach mentioned before. Do you not have a logical lookup that you could do to narrow the pre-keyword-search to less than 1000...?

 

Cedric Amoyal
ACT! Certified Consultant
The Contact Group
www.thecontactgroup.com.au
Platinum Elite Contributor
Posts: 14,384
Country: Australia

Re: Limited keyword search to 1000 records

Just a little extra ... not sure if there are any issues with very large numbers, but with Universal Search in ACT! 2012 you can set the limit. On the other hand, you can't create a Lookup on the results