tag:blogger.com,1999:blog-3307522273508528368.post7033338883239586216..comments2021-01-13T22:50:00.210+11:00Comments on Fadi Noja - SharePoint 2007/2010: Partial Keyword Search/Wildcard Search WebpartUnknownnoreply@blogger.comBlogger8125tag:blogger.com,1999:blog-3307522273508528368.post-10338153674144295702009-10-21T03:30:17.315+11:002009-10-21T03:30:17.315+11:00Can you please send me the details of your web Par...Can you please send me the details of your web Part.Anonymoushttps://www.blogger.com/profile/04503477611808771926noreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-49186537681162467342009-05-02T20:29:00.000+10:002009-05-02T20:29:00.000+10:00It's finished and working. You can check it out o...It's finished and working. You can check it out on www.fahcsia.gov.au. I can't put up the exact one that I did there, however Im working on a new one and will put it up.Fadi Nojahttps://www.blogger.com/profile/02808259855340521550noreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-22797832962064865362009-05-02T18:22:00.000+10:002009-05-02T18:22:00.000+10:00Hi Fadi.
I've just come across this and it would ...Hi Fadi.<br /><br />I've just come across this and it would suit what I'm doing perfectly.<br /><br />Did you end up completing your work on this and publishing it?<br /><br />Thanks,<br />Nick.Unknownhttps://www.blogger.com/profile/15277469074185477296noreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-60262837855541435402009-04-05T00:17:00.000+11:002009-04-05T00:17:00.000+11:00Hi Fadi.Did you get a chance to post the completed...Hi Fadi.<BR/><BR/>Did you get a chance to post the completed webpart referred to below?<BR/><BR/>I'd be interested to see what you've managed to do and build upon it if possible.<BR/><BR/>Thanks,<BR/>Nick.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-51732005565047814402008-06-06T22:25:00.000+10:002008-06-06T22:25:00.000+10:00Hi,In a few days Ill post a complete webpart for y...Hi,<BR/><BR/>In a few days Ill post a complete webpart for you guys to download and play with. I won't include everything, but enough for you to do the basic search with. That way you can extend it to meet your needs.<BR/><BR/>FadiFadi Nojahttps://www.blogger.com/profile/02808259855340521550noreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-436877366731539052008-06-06T22:19:00.000+10:002008-06-06T22:19:00.000+10:00Hi,We have also same requirement for our intranet....Hi,<BR/><BR/>We have also same requirement for our intranet. It will be great if you can let us know how to build this.<BR/><BR/>It will be really helpful if you can show us how.<BR/><BR/>Thanks<BR/>SachinAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-3510231325120292232008-06-06T07:27:00.000+10:002008-06-06T07:27:00.000+10:00Hi Bernhard,here's a bit of the code. I have the ...Hi Bernhard,<BR/><BR/>here's a bit of the code. I have the compelte code at work, but here's where i started from<BR/><BR/>private void fullTextQueryExecute(string strQueryText)<BR/> {<BR/> //Create the FullTextSqlQuery object for searching the index<BR/> FullTextSqlQuery kRequest = new FullTextSqlQuery(ServerContext.Current);<BR/> <BR/> ////Prepare the string to use wildcards<BR/> string strQuery = "'\"" + strQueryText.Replace(" ", "*\" AND \"") + "*\"'";<BR/> ////Set the query text to return columns and search appropriate fields.<BR/> ////The fields are based on what's indexed in the search settings.<BR/> kRequest.QueryText = "select " + this._searchColumns + " FROM Scope() WHERE (\"scope\"='All Sites' "<BR/> + ") AND CONTAINS(*," + strQuery + ") ORDER BY Rank DESC";<BR/> //Return all result types except best bets<BR/> kRequest.ResultTypes = ResultType.RelevantResults;<BR/> //Get the result table collection from the query<BR/> ResultTableCollection resultTbls;<BR/> try<BR/> {<BR/> resultTbls = kRequest.Execute();<BR/> }<BR/> catch (Exception ex)<BR/> {<BR/> ///Write error out to trace listener<BR/> System.Diagnostics.Trace.TraceError("Exception: " + Environment.NewLine + ex.ToString());<BR/> resultTbls = null;<BR/> return;<BR/> }<BR/> if (((int)ResultType.RelevantResults != 0) && (resultTbls.Exists(ResultType.RelevantResults)))<BR/> {<BR/> ResultTable tblResult = resultTbls[ResultType.RelevantResults];<BR/> if (tblResult.TotalRows == 0)<BR/> {<BR/> lblQueryResult.Text = "No Search Results Returned.";<BR/> }<BR/> else<BR/> {<BR/> lblQueryResult.Text = string.Empty;<BR/> ReadResultTable(tblResult);<BR/> }<BR/> <BR/> }<BR/> }<BR/><BR/>What you have to do is create a function called ReadResultTable to display the results properly. You can expand it to return the XML to the out of the box search results webpart (that's what I'm doing now).<BR/><BR/>You might also want to expand it to allow AND and OR statements in there. <BR/><BR/>If you need a hand, let me know.Fadi Nojahttps://www.blogger.com/profile/02808259855340521550noreply@blogger.comtag:blogger.com,1999:blog-3307522273508528368.post-55520437787916465482008-06-06T00:21:00.000+10:002008-06-06T00:21:00.000+10:00Hi,have to solve the same problem in our intranet....Hi,<BR/><BR/>have to solve the same problem in our intranet. <BR/><BR/>Would be great if you could publish it to the world!<BR/><BR/>Rgds<BR/>BennoUnknownhttps://www.blogger.com/profile/00400317871385309754noreply@blogger.com