tag:blogger.com,1999:blog-3893582346020662759.post5993191628739099146..comments2024-03-02T10:24:11.056+05:30Comments on SharePoint, ASP.Net, JQuery, SQL Solutions: SharePoint list view web part wildcard searchAnonymoushttp://www.blogger.com/profile/11277148819153438060noreply@blogger.comBlogger45125tag:blogger.com,1999:blog-3893582346020662759.post-27500568612442500352014-12-08T15:59:24.194+05:302014-12-08T15:59:24.194+05:30Nice article.I have a similar issue. I have a web ...Nice article.I have a similar issue. I have a web part page with 2 list web parts. So I am unable to use the •http://mosssite/pages/listviewcustomwildcardsearch.aspx?FilterName=Title&FilterMultiValue=*prav* <br /><br />how can i perform search on my page?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-7603021944161141192014-04-26T04:08:40.648+05:302014-04-26T04:08:40.648+05:30how to use or condition so make it a search box so...how to use or condition so make it a search box solutionAmit Lohogaonkar Sharepointerhttps://www.blogger.com/profile/13571670068586762663noreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-21157359535009947592014-02-05T13:44:49.969+05:302014-02-05T13:44:49.969+05:30Thanks Praveen, Spent lot of time on this. U gave ...Thanks Praveen, Spent lot of time on this. U gave me the simple solution.<br /><br />- RajashekarAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-20984155785806195462013-09-16T13:13:59.023+05:302013-09-16T13:13:59.023+05:30Hello,
Firstly, great work Praveen! I can't t...Hello,<br /><br />Firstly, great work Praveen! I can't thank you enough for this solution. However, multi-value searches seem to be problematic for me. Searching for val1 and val2 using the code above gives the search query *val1;val2* which is incorrect. It returns only search results for val2 or other quirky results. Also, I would rather have an AND keyword search rather than an OR - both val1 and val2 should be present in each search result, even if they are wildcards. I believe the search query should be *val1*+*val2* (correct me if I'm wrong) as described in this code below:<br /><br />function RedirectUrl()<br />{<br /> var tb = document.getElementById("tbSearch").value;<br /> if(tb != null)<br /> {<br /> var arr = tb.split(";");<br /> var str = "";<br /> for (var i = 0; i < arr.length; i++)<br /> {<br /> str += "*" + arr[i] + "*";<br /> if(i == (arr.length - 1))<br /> {<br /> return str;<br /> } else {<br /> str += "+";<br /> }<br /> }<br /> window.location.href="?FilterName=Title&FilterMultiValue="+str;<br /> }<br /> return false;<br />}<br /><br />- StanleyStanleynoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-71969773826724792442013-08-06T00:20:36.646+05:302013-08-06T00:20:36.646+05:30Praveen,
Did you have a chance to add the screen ...Praveen,<br /><br />Did you have a chance to add the screen shots with more detailed steps? I am a newbie at SharePoint so was not able to follow some of the steps.<br /><br />Thank you!<br />DeeAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-72311183172089360392013-06-12T14:07:28.087+05:302013-06-12T14:07:28.087+05:30Hi Praveen,
Thanks a lot for this post. We have i...Hi Praveen,<br /><br />Thanks a lot for this post. We have implemented this and it works fine, except for one thing: we are using the filter on a grouped view of a list and after applying it indicates in which groups we can find the item, but all items of that group are still shown. Do you know what could be the issue here and how we could solve it?<br /><br />Regards,<br />Anna and MaryAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-50613730409813699002013-04-06T01:03:54.996+05:302013-04-06T01:03:54.996+05:30Praveen,
This script works great. One question, w...Praveen,<br /><br />This script works great. One question, when no result is found, how can we notify the user instead of just returning to the default page? Thanks. Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-64705635700933709422013-01-03T07:36:05.481+05:302013-01-03T07:36:05.481+05:30I will test it quickly and let you know! What fiel...I will test it quickly and let you know! What field type you tested on forum list?<br /><br />-Praveen.Anonymoushttps://www.blogger.com/profile/11277148819153438060noreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-13460371494230847392013-01-01T14:27:23.598+05:302013-01-01T14:27:23.598+05:30Hi Praveen,
I am able to get this working for a r...Hi Praveen,<br /><br />I am able to get this working for a regular list, but when I try to use it on a team discussion list (like a forum), it doesn't seem to work. Any ideas?<br /><br />Thanks,<br /><br />EliAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-52016196969574584932012-08-31T01:27:11.377+05:302012-08-31T01:27:11.377+05:30What can I do if I need to pull all records betwee...What can I do if I need to pull all records between 2 dates and a column name. EX:<br /><br />I have multiple columns for different steps that contains the date it starts. <br />Column A - Column B<br />01/01/2012 - 03/01/2012<br />02/01/2012 - 03/15/2012<br /><br />I should be able to provide 2 filters like - Show me all records where Column A dates are between 01/01/2012 to 01/31/2012.<br /><br />How can I do this?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-88128549551017550702012-05-29T11:45:36.013+05:302012-05-29T11:45:36.013+05:30The FilterMultiValue does NOT work for non-English...The FilterMultiValue <b>does NOT work for non-English keyword</b>, for example, cannot provide a Chinese word between * and *.<br /><br />This will not work:<br />http://server/DocLib1/Forms/AllItems.aspx?FilterName=_x59d3__x540d_&FilterMultiValue=*上*<br /><br />(Have used InternalName for FilterName)<br /><br />Any idea?<br /><br />- LindaAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-71333170272210526362012-04-19T19:06:27.556+05:302012-04-19T19:06:27.556+05:30I found this example:
http://jasear.wordpress.com...I found this example:<br /><br />http://jasear.wordpress.com/2012/04/19/sharepoint-2010-basic-list-search-filter-webpart/<br /><br />It works with pagination.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-31213791850828452442011-11-22T12:50:43.834+05:302011-11-22T12:50:43.834+05:30Thanks a lot for this solution.
Thanks to Bill( c...Thanks a lot for this solution.<br /><br />Thanks to Bill( cbandman_# ) for the enhanced JS to improve wildcard search.aruthttps://www.blogger.com/profile/02698355303032319277noreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-88415710707085900972011-10-18T04:56:40.112+05:302011-10-18T04:56:40.112+05:30This solution works really well, except when I try...This solution works really well, except when I try to search on multiple values. When I separate the values with a semicolon, it will only display the last value, unless the text in the first value is the last word in the text string. For example if I enter search values: "rate;preventive" only the Preventive line item will display. However, if I search on: "rate review;preventive", then I'll get both line items. Do I need to modify the code to ensure that I get all results or is this just a limitation of the search. Please help.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-34835449747782750292011-09-26T09:22:08.519+05:302011-09-26T09:22:08.519+05:30I found this very helpful. Thanks very much for p...I found this very helpful. Thanks very much for posting this.Dennishttps://www.solveitwith.net/blognoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-6557772463084068942011-09-22T07:10:16.992+05:302011-09-22T07:10:16.992+05:30When using this method with grouping the filter do...When using this method with grouping the filter does not apply to any collapsed groups, any idea how to overcome this?AdvaComphttps://www.blogger.com/profile/14278483829176323871noreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-72030509346158627942011-06-07T20:18:38.544+05:302011-06-07T20:18:38.544+05:30Praveen,
Did you find a solution to the paginatio...Praveen,<br /><br />Did you find a solution to the pagination problem?<br /><br />I am new to Share Point and loved your code but the only issue is that the filter gets cleared when I move to other page.<br /><br />Hope you must have got a solution by now?<br /><br />Thanks anyways.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-8040352577489579802011-06-06T22:48:45.766+05:302011-06-06T22:48:45.766+05:30Awesome! Worked like a charm and so easy.Awesome! Worked like a charm and so easy.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-58590878793987091692011-05-09T13:25:44.229+05:302011-05-09T13:25:44.229+05:30Hi there.
Great job!
What I'm missing is the ...Hi there.<br />Great job!<br /><br />What I'm missing is the way to show documents wich are stored in folders.<br /><br />I'm wondering if this could be achieved:<br />1. ASK the user for the folder name and insert it in the URL<br />2. Create a new view that shows all files from all folders and use it in the URL<br /><br />In both options i'm lacking the way to modify <br />window.location.href="?FilterName=DocNo&FilterMultiValue=*"+tb+"*";<br /><br />Where here can I put as a parameter the folder name or "NoFolders.aspx"?Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-55832956817138306642011-02-18T01:33:11.779+05:302011-02-18T01:33:11.779+05:30Hey Praveen,
When searching the web on this topic...Hey Praveen,<br /><br />When searching the web on this topic, I have found a third party web part that can do wildcard search on a SharePoint List view.<br /><br />The URL is http://demo.metadatasys.com <br /><br />Thanks<br />SriniAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-37852294584139801122011-01-25T22:15:17.016+05:302011-01-25T22:15:17.016+05:30Hi Praveen, is there a way to use the wild card se...Hi Praveen, is there a way to use the wild card search to retain the filter values if we select one of the values obtained by search.vjnoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-38287926550439241262011-01-07T21:31:42.396+05:302011-01-07T21:31:42.396+05:30Great Post and useful info. However, like some I r...Great Post and useful info. However, like some I ran into columns not working (throwing error) etc. This is because sharepoint has both a 'display' name and a real 'name'when it generate a list. To search you need to use the real name. Here is some JavaScript I used for a search feature on our little farm.<br /><br />--------------<br />You can pick it up as a txt as it is too big to post here.<br /><br />http://www.listedthings.com/SPsearchWild1.txt<br />--------------<br /><br />Enjoy!<br /><br />Billcbandmanhttps://www.blogger.com/profile/10470545555563245966noreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-17376470568864632252010-11-26T22:21:13.961+05:302010-11-26T22:21:13.961+05:30It works fine for me.
When i try to filter using ...It works fine for me.<br /><br />When i try to filter using promoted column it throws me the error :<br />One or more fields types are not installed prperly.Go to the list settings page to delete these fields<br /><br />Please assist meVijinoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-12297387831309685952010-11-26T21:52:20.991+05:302010-11-26T21:52:20.991+05:30Awesome work!!!!
I need the same functionality fo...Awesome work!!!!<br /><br />I need the same functionality for a form library. Could you help me outvijinoreply@blogger.comtag:blogger.com,1999:blog-3893582346020662759.post-19612125227634436822010-08-07T21:12:12.210+05:302010-08-07T21:12:12.210+05:30Awesome article! Thanks a lot for posting it.
Ch...Awesome article! Thanks a lot for posting it. <br /><br />Cheers<br />MaxMaxhttps://www.blogger.com/profile/13926738228164463716noreply@blogger.com