Skip to main content

Cloud

SharePoint Search Gotchas

Here are a few gotchas that I ran into while working with SharePoint search.

BETWEEN doesn’t exist: I made the mistake to assume that I could use the BETWEEN clause in my fulltextsqlqueries when it is not usable! Luckily, one simple work around is to use >= and <= instead. I lost a lot of time with that one just assuming that the BETWEEN clause would work in my queries and that the problem must have come from something else.

Sorting columns: If your columns contain null values and that you are trying to sort on those columns, records containing the null values will completely be dropped off from the results table. Same thing happens if you sort on a column that doesn’t exist. So if you run into those two situations when using the order by clause, your results will be affected when clearly they shouldn’t be. There doesn’t seem to be a work around for this issue (let me know if there is!).

Estimate results count: The results count when it is an estimate can be troubling as they often come back with different values making hard to use the value. If you are planning to use this count in your logic, be careful when you do (see my blog on paging).

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

PointBridge Blogs

More from this Author

Follow Us
TwitterLinkedinFacebookYoutubeInstagram