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


Post New Web Links

search on multiple lists

Posted By:      Posted Date: September 10, 2010    Points: 0   Category :SharePoint
 
Team, I have a situation where i have to do a search on multiple lists at once. List A - Field A, Field B List A - Field A, Field C List A - Field A, Field D When a user searches by Field A i want to pull all records from all lists. How do i present it after u have done the search. What web parts should i use? Is is possible to search on multiple lists. How to do it through designer? Do i need to a roll up view and search on it. If its possible.. Should i do join of lists and try to filter it based on FIELD A? Can we filter on joined lists? Any ideas on this .... Thanks a lot in advance.      


View Complete Post


More Related Resource Links

search multiple words into textbox and populate all records in gridview related those keywords

  

I have a textbox and a gridview which is bound to a table

what I want to achieve is a solution where lets say there are two records - e.g. "1. Book and 2. Red", i want a user to type in those words and the gridview shows the results as followed;

1. Book

2. Red

I have set up the sql data source and everything and my like operator is this...

LIKE '%' + @record + '%'

how can I solve this problem?


Filter search over multiple text columns

  

Hi everyone,

I'm working on a library that stores information on various cases. The case table has several columns that contain descriptive strings on what happened in the case. I would like to create a single filter that returns all cases where the search string is found in any of the columns. I've looked at Dynamic Data Filtering, but as far as I can tell, the "Contains" filter only allows you to connect to each column individually. Has anyone tried this?

Thanks,

Andrew


Quick Note: Accessing Multiple SharePoint 2010 Lists by Using LINQ

  
In this exercise, you develop and deploy a visual Web Part that reads data from three lists by using LINQ queries and displays the results in a grid view control.

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance. I am using MOSS 2007 standard edition.

Connect multiple lists

  
Hi, I have a list "List1" with column let's say "A". I have 4 more lists List2,List3,List4,List5 with different columns. Once an item is created in List1, another item will be created in all the other lists. My requirement is to connect all these lists some how may be I can use column "A" from List 1. I know look up column works but I guess it is only one way. I need to be able to navigate from one list to another ex. If I use look up column, then I can navigate only one way from List1 to List2. I need to also navigate from List2 item to List1item. Please let me know a possible solution. Thanks in advance.   I am using MOSS 2007 standard edition.

Search Multiple Data Base

  
Hi,I am working on a Large Database application .  I have 5 Product catalog database   with atleast 5+ million product information on each .  database is deployed in multiple servers. . when the user performs a search it should search in 5 different database and combine the  results to show in the search results.product row has a priority key and based on the priority i need to show the results. In case if same results is found  in all the five  database then we need to group the result and shows the count in result column.For exampleIf Product1  is exist inn all the five database database  then i need to show Product1 - count=5and also we have priority index for showing the result . default search should be sort by priority  .Can any body let me know what will be the best approach to do the search on this multiple  database and  process this data to find the duplicates and sort accurding to the sort index..(we are also planing to restrict the max result from each data base) . Thanks

Search across multiple site collections

  

I am working on a MOSS 2007 farm and like to know what would be a best way to setup Search so that I can search across multiple Site Collections? Basically, our SharePoint farm use to have only one site collection with lots of subsites. We reorganized and  promoted a lot of those subsites to site collections. After the promotion, I noticed that on each of the new site collection under the search dropdown, the only search scope that was available was “This Site”. I was able to fix this by changing search settings and creating a custom scope by providing the link to the Search Center site that had already existed in the root site collection. However, when I try to search from any site collection using the "All Sites" search scope, no results are displayed and I get a blank page. Any idea what I might be doing wrong? Thanks in advance for your help.


Is it possible for a sharepoint VIEW to aggregate multiple TASK LISTS?

  

I have a few TASK LISTS, each with identical structure, that can't be combined initially, based on the groups that control the task lists.  ALL Task Lists reside on the same SITE.  I would like to find a way to "UNION JOIN" multiple task lists under a single Tasks List VIEW, if that can be done.  Alternately, is there a WEB PART that can do this?

Is there a way to merge multiple similar-structured task lists within a single site - and if so, how would it be done?


Optmization in multiple search scenario

  

I have a situation where the tables have more than 500 columns and users have privileges to construct dynamic query using an application. 

we need to optimize search in this scenario. I can't create indexes on all columns or even a single index for all columns. also we need to do this with out changing the database schema and application.


Cheers!!! SqlFrenzy

Combining lists from multiple sites into SPGridview

  

I have one main SharePoint site which has 5 child sites. Each child site represents a different department. On each of these sites there is a list called "ActionPlans". These lists all have the same name and the same number of columns. I need to somehow combine the 5 "ActionPlans" from the child sites into one on the main page.

I was able to loop through the SharePoint object and pull out one list, populate a datatable and display it in the SPGridview. I am having problems looping through the other sites and combining all lists.

Please help, Ninel


MOSS 2007 - Propagate changes to multiple sites and lists

  
We use MOSS 2007 for doc mngmt and maintain individual sites containing lists and libraries for each of our 90+ projects.  All sites are created from a site template and we wish to keep them all identical.  How should I push out changes and updates as business requirements change?  In other words, if we change/update the template, how can I make all the sites and lists look the same?

Show filtered data from multiple data lists in a view

  

I am attempting to build a very simple Sharepoint site with 3 data lists: 1) Themes,  2) Value Statements, 3) Supporting Details

Each Theme has 2+ Value Statements and each Value Statement has 2+ Supporting Details. 

Currently, I have the Forms setup so that when I enter a new Supporting Detail, the individual must select from the avaialable Value Statements (using a Lookup Column). 

What I would like to do, now, is allow an individual who is looking at a view of all the Value Statements to see the Title field of all the Supporting Details that have been entered for that particular Value Statement (with hyperlinks).

I'm guessing that I need to use SharePoint Designer 2010 to customize the view, but am not certain how to do it from there.


Thanks


Best way to get anonymous InfoPath data into multiple lists/libraries?

  

I'm trying to figure out the best way to create a solution for the situation I have.  I'm still pretty new to SharePoint, and very new to InfoPath.  I'm working with MOSS 2007 and I've created a browser-enabled InfoPath 2007 form that I need to make available to both anonymous users at the top level of my site, and AD authenticated users from within a secured site collection.  It will be important for me to be able to determine whether the form is being submitted by an anonymous or authenticated user, as it will have some fields that need to be handled differently in each case.  Once the forms are submitted, I need to be able to store them in a forms library in the secured site collection, and also create a list item in the top level site with some of the basic info from the form.  That list will be visible and searchable for the anonymous users.

After searching through this forum, I've found at least 2 possible ways for anonymous users to submit forms to a form library.  Right now I'm leaning towards having it submit to a web service which would handle the task of moving/copying the data to the proper places.  Would that be the best solution in this case, or am I missing something?

The next thing I'm not sure about is what my options are for presenting the form 

Search query with multiple search feilds

  

Hi,

I have a search page with four fields. Each field belongs to columns in the database. None of these fields are mandatory, so user can choose which field/feilds they want to enter. I want the search results to be more specific as they enter values in more than one field.

For example.

First name, Last name, Pin code and Mobile are the 4 search fields.

 

Any help will be appreciated.

Thank you

 


Merge Multiple Task Lists

  

Hi-

I am a sharepoint user with very little technical know how so please bare this in mind if/when responding! :)

I have a sharepoint site that has various meeting workspaces. Within the workspaces there are individual task lists. I need to show all tasks in the task list of the sharepoint site. Is this possible?

Thanks in advance for your help!

C


Search in (multiple value) Parameter (for usage in WHERE-clause)

  

Hi there,

I'd like to give you a little bit of a background story first in order to explain my problem better:

I have created a report, where there is a parameter with multiple values - in this case country codes like DE, DK, FR, GB etc. .
These values are selected with the help of a query out of a MS SQL 2008 database (Navision).

Now the problem is, that in the customer-database where the single lines contain the information of the country code, there is a country code for each foreign customer, but not for the domestic customers. These are simply blank.
Apparently this can not be changed easily and I have to cope with it.

Example of the problem:

Let's say that the domestic country is DK. So there is no actual value for customers of DK, just a blank 'value'.
The parameterlist contains DK because it is in the country database, where I get the information from.

So if the reportingservices user selects something in the parameter like "DK, GB", I could query something like:

SELECT bla, blub, [Country Code]
FROM    Customer
WHERE  [Country Code] IN (@Country_Paramater, '')

The , '' because I also want to have the empty country codes.  This works fine... until I decide NOT to show domestic data in the parameters.
Example: Reportingservices

Search multiple document library in Query

  

How to search multiple document library in a sitecollection. these document library has same named : DocLib1, DocLib2, DocLib3 ... they all in a same sitecollection.

How to search document via FullTextSqlQuery or other Search Objects?

If there is another sitecollection structured similiary with this one, how to search all these document library? Can we search all sites documents then use url for filter ?

Thanks a lot.

 


Categories: 
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