.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

advanced search query

Posted By:      Posted Date: October 06, 2010    Points: 0   Category :SharePoint

Hi all,


I try to customize the advanced search  web part and form my own query which I add to ASB_ResType_Query.

the problem appear when with 1 text box value I need to look into several properties and I combine several field like that in my query.

My query can became very long like below:

Full Text Query:

SELECT Name, Title, Path, SiteName, CollapsingStatus, HitHighlightedSummary, HitHighlightedProperties, ContentClass, IsDocument, PictureThumbnailURL

from scope()

where ("scope" = 'All Sites') And ((FREETEXT(DLName,'document') OR FREETEXT(DLfName, 'document') OR FREETEXT (DLTitle,'document')) AND ((DLCompName ='Town) OR (DLAirport = 'Town') OR (DLExtComp = 'Town') OR (DLComp = 'Town') OR (DLRelevantComp = 'Town') OR (DLCorrespondent = 'Town')))

These always give me a no result or sometimes your query is malformed.

hope anybody can point me what is wrong with my query or which approach should I take to make it works.


Thank you all

Best regards,
-- Pingkan --

View Complete Post

More Related Resource Links

MS SQL Server: Search All Tables, Columns & Rows For Data or Keyword Query

If you need to search your entire database for specific data, this query will come in handy.

So when a client needs a custom report or some sort of custom development using Great Plains, most of the time I will have to track down the data in the system by running this query and find the table(s) it is in.

Advanced Search page no found



Currently when a user attempts to conduct an advance search they recieve a page not found message. When I tried to conduct a search myself I was able to enter in my search term, but the search results came up as page not found. On closer inpection I noticed that it is droping part of the URL.


http://sitesp.ca/sites/PETL-EPFT/searchcenter/Pages/Advanced.aspx becomes http://sitesp.ca/sites/PETL/searchcenter/Pages/Advanced.aspx

Has anyone seen this before? Any help would be greatly appreaciated.


FAST search query is slow...

Hi, we are using fast search for sharepoint 2010. We are crawling an external data source and this is used for search queries. we have around 30 metadata properties and all are full-text indexed. however, the search operation is slow for a database of 5k records in intranet (webserver and database server are in different geographic regions). typically a 100 item search takes 9-10 sec. it get worse over internet and the search query varies from 10-45 sec for 100 items. Any pointers will be helpful. thanks.  

DateTime custom managed property search fails with " Your query is malformed. Please rephrase your q

I've created a front end search page in Silverlight 4 for SharePoint Search.  Currently we are using WSS 3.0 + Search Server Express 2008 (v  The page interacts with the MOSS version of the search web service at:   <site collection>/_vti_bin/search.asmx The reason for this approach is the unique way the requirements specify the look and behavior of the results.  The built-in Search Center page or web parts will not satisfy these requirements. We are going into production but I still cannot figure out how to search against my custom managed properties that are of Type DateTime.  If I cannot get this to work, it is a showstopper. I've tried numerous variations on the SQL Syntax and cannot get it to work.  I know the error is in the date portion of the WHERE clause since I can remove it and searches work fine. Here is a working query: SELECT Size, Rank, Path, Title, Description, Write, RequestSubmittedDate, DocumentType, RequestPromisedDate, ProblemDescription, DatePublished, RequestOwner, RequestingDepartment, DocumentAuthor, ProjectNumber, ProjectDescription, RequestStatus FROM scope() WHERE CONTAINS ('"nmr"') ORDER BY "Rank" DESC yet if I try to use a date literal in the WHERE clause as in the following query modification, I get the "malformed"

Advanced People Search

Hi All, I'm having a problem with the Advanced People seach webpart, one of the fields under 'Search Options' is Memberships. I have updated it inline with this article http://support.microsoft.com/kb/935196, which now brings back results when searching by using a distribution list name, but I'm still getting no results when searching by a Site Name (as displayed under in the "Memberships" webpart on a mysite) Also is there a way to change the word "Memberships" in the webpart, to something like "Site Memberships"

Search query returning 0 results

I'm using a query which returns 0 results but was working some weeks ago.  I checked the code and nothing has changed since then.  I created a Search Center Site on another port and using the same terms I get many results there.  I checked my scopes and they are all right. Nothing changed there either. Could someone help me figure out what may be the problem in my query.  Or maybe it's my Scopes/Content Sources configuration. SELECT URL, FileName, Title, Description, Rank, Size, HitHighlightedSummary, Path FROM SCOPE() WHERE freetext(defaultproperties, ' +légumes')  AND ( "scope" = 'Scope - My Portal - All Site - fr'  )    ORDER BY Rank DESCDaniel Siconnelli There is neither good nor evil... only mogwais and gremlins

Behavior of advanced search

Hi, when searching by properties in the advanced search, for example by "authotr equals Danny Din" - should it find also items which contain the word Danny Din in the body of the item, or only in the metadata of the item?  

Advanced Search tiff files sharepoint 2010

hi, I have a question about advanced search in sharepoint 2010 would love if you could help me: I have a document management system that contains files of different types. Performing a standard search system finds documents, Advanced search performed on the document properties the system can not find such documents tiff. We installed ifilter tiff by the following link: http://www.borghoff.com/post/2010/04/02/Windows-TIFF-IFilter-and-SharePoint-2007.aspx But it does not work. Maybe you have another solution for me? Thank you.

Dynamic scope for advanced search

Hi all, Is there possible for us to use dynamic scope or url as the filter in the advanced search? I want to search only to specific document library or some site while if I'm using global scope I will need to define a lot of scopes. anybody can give me some clue how I can make it works? thank youBest regards, -- Pingkan --

How to Perform Query Side Expansion of Synonyms in FAST Search for SharePoint

Hi, I have added Two Way Synonyms in FAST Search Keywords option in Site Settings. If I type the synonym alone, it works but if I type it with some other keyword, the search results in no hits whereas with the Same Keyword if i give the Main Keyword instead of its synonym, the search is successful. I understand that for this we need to do Query Side Expansion of Synonyms. I also tried to Set a Resubmit Flag to AddSynonymsAutomatically but this also failed. Can u pls suggest a way for this?

How to add advanced search and results to the site?

I have a site with advanced search Box webpart. I would like to results to open to the same site with the search webpart. Not in the search center. I tried to add Search Core Results, but said results are available. Either no query is specified, or the query came from advanced search (Federated Webparts do not support Advanced Search queries).   How to do? Kenny_I

Custom advanced search form

Hi all, I've got some requirement which related with the advanced search form. I'll need to make a tree view which listed the site subsites and document library inside each site. For example:  sites A       DocLib 1       DocLib 2       subsites B              DocLib 3              DocLib 4       subsites C              DocLib 5              DocLib 6 Also I want to make the node which is selected as the scope for search. Is there any body can give a clue or pointer how I can make this? Any insight is appreciated.. Thank you Best regards, -- Pingkan --

Advanced search box webpart customization

Hi, I add the Advanced search box web part on to a page and if I uncheck any of the check box in edit mode, the search wouldn’t work and throw a JavaScript error like “'***TextBox.value' is null or not an object” ·         Show "All words" search box ·         Show "exact phrase" search box ·         Show "any words" search box ·         Show "none of these words" search box It looks like a bug of sharepoint 2010, I am not sure if anyone see this before? Is there a walk around for that?

Custom Advanced Search to search in 1 scope only

I have a custom searchpage, search result, advanced search page and custom scope that configured in SSP. I can set the advanced search to redirect to my custom search result but the result is not from the custom scope (from "All Sites" scope). How do i configure it so that it will search from the custom scope via custom advanced search?

FASTSearchQueryException encountered when creating FAST Search query scopes in PowerShell

Hi, I made an update to an existing FAST Search query scopes. The updates are on the ExtendedSearchFilter parameter. Since the Set-SPEnterpriseSearchQueryScope PowerShell cmdlet does not work to update the parameter, I removed the existing scopes using Remove-SPEnterpriseSearchQueryScope and created new scopes using the New-SPEnterpriseSearchQueryScope cmdlets. I have noticed that after creating the scopes, I sometimes encounter the "The search request was unable to execute on FAST Search Server" (FASTSearchQueryException) when executing query against the search scope. I am not sure if the exception is related to how the scope objects are disposed after running the Remove-SPEnterpriseSearchQueryScope cmdlet. I tried to look into the Event logs of the FAST search server but I was not able to see the error. I would like to ask the community if the exception can be attributed to the exsiting scopes that were removed then recreated.  Thanks. Jo-an  

How to hide "No results are available. Either no query is specified..." in Core Search Results webpa

Hi All, by default core search results webpart displays this message "No results are available. Either no query is specified, or the query came from advanced search (Federated Webparts do not support Advanced Search queries)." till you perform your first search. So, how can i hide this message when page loaded ? Thanks,

Targeting search to the certain document library in the Advanced Search Box

Advanced Search box have properties fields. How to add there document libraries. I would like to make search to only 1 document library? How to customize?Kenny_I
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend