SharePoint 2010: Full text plus faceted search over an External Content List using Search Services (or possibly FAST)

Frank Rosario
  • SharePoint 2010: Full text plus faceted search over an External Content List using Search Services (or possibly FAST) Frank Rosario

    I have an External List over a products table in our database. I want to be able to build a search form over it via a full text search; in addition to being able to filter down on properties on my initial search.

    For example, say I'm looking for DVDs under 10.00 in product DB. I want to be able to have a search box where I enter "DVD OR Movie", but I also want to be able to have a price box where I could enter a max price of 9.99.

    My impressions of SP2010 search solutions is that its easy enough to perform a full text search over an EL with Search Services, but at the same time being able to filter down by additional attributes doesn't appear to be possible out of the box. I know with FAST, I can do a full text search; then filter down the results on the result page via each item's properties. However, we're building custom functionality on the results page allowing users to add an item from the search result set to another list; so I can't use Search Services or FAST's results page.

    I'm thinking my best bet is CAML; but my readings on the subject lead my to believe CAML doesn't support full text search. I could also try LinqToSharePoint ; but that doesn't support full text search either.

    Given my circumstances, do I have any other options besides CAML or Linq? Any constructive input is greatly appreciated.

    Thanks, Frank

caml-query linq search fast-search
Related questions and answers
  • I'm having issues with the provided Search WebParts. I'm currently using the "Text Filter" WebPart because it is the closest to what I need. The problem with that one is that it only searches through one of the columns in the list. I need it to search the entire list. But most importantly, I need the user to be able to enter a substring and it to return results. For example, if I enter "pro" I expect stuff like "proclaim" or "production support" to return, but it is not matching anything. Is there some better WebPart to do this? I'd prefer an oob solution, if possible. Any info would

  • My company is currently in the process of building a CMS on top of SharePoint 2010. Part of the functionality of the CMS will require being able to have a searchbox that searches the contents of a specific list (both custom lists and external content list types) and returns the list items relevant to the search as the results. My questions are: Is it possible to build a search Webpart that only searches a specific list? Is is possible to have an external content list sitting on top of a database table via BCS searchable through SharePoint Search Services? Any constructive input

  • , and then as part of that activation, drop web parts onto some specific pages. In my case I want to be able to drop it onto the "AllItems.aspx" page of a list, but I'm equally having trouble adding...), then there doesn't seem to be a way to just get a reference to the page, it always wants to overwrite it with a new file. But I dont want to do that, I just want to add a Web Part to the existing page. See my... work either. I should be able to do it by more heavily customising the List Definition, but that seems a little over the top and I'm reluctant to do that before ruling out the other options. So

  • have 11 pages of document links, each with its own subheadings. So far I have it set where each document has a custom field called "Page" with a check box list of all the document pages... items. Does anyone have any ideas as to how I could accomplish this, either via CQWP or by different means? Goals/Requirements of Installation Allow Intranet documents to be maintained..., but these are the requirements I have been given for the project. NOTE2: It's also entirely possible that I am going about this the entirely wrong way (I'm new to SharePoint). If anyone could point me in the right

  • Does anyone else have this problem and know of a work around? On a WebPart page, add a Search Box WebPart. Edit the properties of the WebPart and change the Query text box width (in pixels) option. I tried setting mine to 50, 300 and 500 and none of these values seem to change the way the text box looks on the page. It seems the Search Box WebPart doesn't honor the value set in the TextBoxWidth attribute. Sometimes I feel like I'm a beta tester on a released product...

  • to Spreadsheet, but it does not appear to support automated subdivision of the list items into separate worksheets. I do not know if Excel Services that come with MOSS are capable of it, but we do not have MOSS so we cannot consider it an option for now. EDIT It seems that by mentioning "out-of-the-box", I am implying that I'd prefer something quick and simple. Let's dispel that. I do a lot... of work level that can be suggested. I should also note that keeping the list linked with the spreadsheet is undesired. We want to be able to download the spreadsheet as a reference. Because

  • approach could I try? Any solution has to be security trimmed for the all important search function! ...I have 2 users, Martin and John I have 5 documents, all available to Martin and John. I also have 2 documents that are available to John only (Martin must not see them). To complicate matters... that have been replaced. A small amount of luck is that an administrator will specify which new document should ‘replace’ an existing document from the originals. Over time I would be required to add more

  • my CAML in Visual Studio to match my changes. I want to do this because I am creating custom fields and content types for my project and want to create a solution with these customizations. Since there doesn't seem to be a way to do this (create custom fields and content types) as a solution using SharePoint without putting them into a list, I am using Visual Studio and CAML for this. I also want to use Visual Studio and CAML so that I can put these CAML xml files in source control so that I can version my custom fields and custom types. I have tried using tools like http

  • Is it possible to use the Content Query web part to filter on multiple specific content types that do not have a parent/child relationship? I have a requirement to show Events (from a calendar) and Announcements (from an Announcement list) aggregated in the same area but as these come from two different branches in the content type tree, I can't do this via configuration of the web part. Would I be able to do this with a custom CAML query after exporting/re-importing the web part xml? Also I noticed the following two XML clauses in the webpart.xml file: <property name="ContentTypeName

Data information