SharePoint 2010 Search and Detail Solution, Architecture, Solution Required or Direction

Posted on 2012-08-20
Last Modified: 2012-10-08
I am quite new to SharePoint. I am tasked to develop SharePoint solution for following requirements.

Basically it is Search and Display Results

BUT (There is always a BUT, Right!).

SharePoint Site Collection Owner will enable which fields end user can search from a long list of fields. Like a Check box against each fields.

End User can search only on those fields.

We have different data sources. There should be some way to enable or disable a data source(s); again SharePoint Site Collection Owner will enable data source(s) end user can search from list of data sources, like a check box against each data source.

These different datasoruces will not have same column names. E.g.: First Name, Last Name in DatasourceX can be Fore Name and Surname in DatasourceY. Column names will be different in different data sources.

All external data sources are different databases in Oracle Database.

When user enters the search term and clicks on Search button. System should present end user with few column names and if the end user is interested in the record, end user will click on the record and system should present with detail view.

Search should deliver results very fast any search taking more than 30 seconds to deliver will not be used.

User should be able to search results for future reference.

As i said i am very new to SharePoint. Can any one of you experts design a possible solution please?

Will it be web part, visual web part, fast search, etc?

Please help.
Question by:NetSri
    LVL 41

    Assisted Solution

    It seems you need lot of customization. I suggest, better you hire a Sharepoint expert, who can help you to set this up, the way you want. Or you can also play with default templates.
    LVL 13

    Assisted Solution

    by:Yagya Shree
    There is already a tool available on codeplex which comes very close to your requirement.

    SharePoint Search Service Tool

    Check out the screen present on the site with check boxes.

    Accepted Solution

    Thank you very much for all the advise before , any solution pleasessss

    Author Closing Comment


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    MS Access 2003 or later To MySQL Migration Project Hello All, this is my second article in the category of MS-OFFICE Automation. In internet I am not able to find any comprehensive resource on the Migration of MS Access back-end to MySQL so I fin…
    Technology opened people to different means of presenting information, but PowerPoint remains to be above competition. Know why PPT still works today.
    Viewers will learn how to maximize accessibility options in an Excel workbook for users with accessibility issues.
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now