Fetch Data From Multiple SharePoint Lists

Fetch Data From Multiple SharePoint Lists

Today, we have a very interesting Topic that is "Fetch Data From Multiple SharePoint Lists" to discussion. there are many ideas by which it can be happened. here we have three methods which are following-

1- By using CQWP- this is totally depends on search service application. it can be implemented by SharePoint administrator by using User interface. you only needed a query to fetch data from search.
here search service application is playing a important role so it also has an impact on your CQWP which is added in web part zone on .aspx page.

2- By using Linked Data Source- This can be done by using SharePoint Designer. Linked data source is configured for multiple SharePoint lists through SharePoint designer. after Configuration of linked data source, Just create Data view by using linked data source. this has an advantage of not depending on search service application.
By this method, only two operation can be performed that is Merge with same column definition and join without column definition. This has not much flexibility in term of operation . this is Main Drawback of this method.

3- By Using SP Site Data Query Class- This class represent a query that can fetch data from multiple lists of multiple sub site with in a site collection.so it a a limitation of a site collection and list template will be same of all lists from which data is fetched. your need programming skill to implement same.

4- By using Join operator with Caml Query- Generally this is not preferred method to fetch data from lists.

1 and 2 method can be implemented by a SharePoint Administrator but 3 & 4 method is required a development skill.

Comments

Difference between SharePoint Online PowerShell and PnP PowerShell

Difference between SharePoint Online PowerShell (SPO) and PnP PowerShell (SPO vs PnP) Basically, during interview these topics like Difference between SPO and PnP, Connect with SharePoint by PowerShell Command are very common to be discussed. We will start from the Difference between SPO and PnP. At the end, we will also discuss 'How can connect to SharePoint online by using the SPO and PnP commands?' Question-1 Difference between SPO and PnP? PnP PowerShell- It is managed by Patterns and Practices team. It can be used for SharePoint Server as well as SharePoint Online. it means that is a cross platform library. It works in context of the current user. It mean that no need to have tenant level /SharePoint administrator right to manage. It works at level of site collection. It has wide range of commands at Site, List and Item level. SharePoint Online (SPO) PowerShell- It is managed by Microsoft ...

Disable User filtering in SharePoint 2010

Remove Disabled User from People Picker As we know experience always better then theory but good combination is experience plus theory of relative experience. This combination enhances your knowledge. Today, we have a critical reporting issue from client that is “ Employee has left organization but Employee is still in People Picker” . This issue is related to User profile Synchronization. To overcome this issue we need to creating User profile Synchronization Exclusion Filters using the Active Directory Attribute ”userAccountControl”. Exclusion filter has an advantage of reducing the amount of “Junk” in the profile database and also decrease the time taken to perform synchronization. The userAccountControl attribute is used to store the account options for an AD user object. These options include the status of the account (e.g. disabled, or locked out). Each option is a property flag. These flags are cumulative and thus there is only ever one value for userAccou...

Calendar Overlay Issue

Error - ' Unable to find specified web in the given URL' Above given Error Message is related to SharePoint Calendar. To resolve this problem, SharePoint Calendar Overlay functionality need to be understand. SharePoint Calendar Overlay works well for site collections in the same web application, but not for across web application. Steps for Resolve this Error- 1- Verify the Calendar Overlay Setting and clicking on Calendar Overlay button in calendar ribbon. 2- Check your URL in web URl field. This is same as defined in AAM. click on resolve. 3- Check List and List view. Verify that your url is resolved, Automatically all fields will be filled. List view field value will be your calendar name. 4- Click on save. Now check your calendar and your problem will be resolved. Note- Please check out your page on which calendar is rendered before doing Troubleshooting. Thanks........

Default Web Services in SharePoint

By default, SharePoint has multiple web services that are given below. http://ServerName:99999/_vti_adm/Admin.asmx – used for creating and deleting sites, change 99999 with your administrative port number http://ServerName/_vti_bin/Alerts.asmx – used for working with alerts http://ServerName/_vti_bin/DspSts.asmx – used for retrieving schemas and data http://ServerName/_vti_bin/DWS.asmx – used for working with Document Workspaces http://ServerName/_vti_bin/Forms.asmx – used for working with user interface forms http://ServerName/_vti_bin/Imaging.asmx – used for working with picture libraries http://ServerName/_vti_bin/Lists.asmx – used for working with lists http://ServerName/_vti_bin/Meetings.asmx – used for working with Meeting Workspaces http://ServerName/_vti_bin/Permissions.asmx – used for working with SharePoint Services security http://ServerName/_vti_bin/SiteData.asmx – used by Windows SharePoint Portal ServerName http://ServerName/_vti_bin/Sites.asmx – used to ret...

Six Pillars of SharePoint-2010

Six Pillars of SharePoint SharePoint Server/ SharePoint Online has six pillars basically Six core areas that make it popular in IT industry . SharePoint Online is a cloud version of SharePoint server. it is integrated application in Microsoft 365/Office 365. 1- Sites SharePoint Sever has core functionality to allows users to create different type of site like team, project, enterprise search center etc. in just a few clicks or hardly with in 5 to 10 mins. Newly created site will be in ready to use mode without any coding. 2- Communities SharePoint Server provides great teamwork tools like team site, news, blogs etc. that allow users to share information, find out the information, and discuss with people with in organization boundaries. 3- Content SharePoint Provides the functionality to user to create and manage content easier as compare to other content management systems available in market. it is also integrated with Microsoft office. ...

Create file with dynamic name by using PowerShell

Power Shell is a scripting language which has amazing capabilities to automate the administrative tasks without any intervenes. By using it, log files can be created and deleted after some duration like after 7 days, 30 days etc. This is a common task that is performed by window administrators. Let me take an example like Application logs files are created in production environment. Day by Day Size of the log folder is increased due to log files those are created on daily bases. In directly, log folder is utilizing the server space. This will affect the server performance. To clean the log folder dynamically on daily bases, Power shell script can help. Below we will write the script to perform same task by understanding with below mention topics. How can create a log file with dynamic name by using PowerShell? How can delete log files after 7 days by using Power Shell? How can create a log file with dynamic name by using PowerShell? Main problem is log files name must be un...

Target Audience in SharePoint Online (News Web part & Event Web Part)

Target Audience in SharePoint Online (News Web Part & Event Web Part) SharePoint has target audience feature to hide and show the information for the authorized audience. That is the way to manage the critical information only for required group of people that is called Audience. In SharePoint Online, few out of box web parts which are following below supports audience targeting. News Web part Events Web part Highlighted Content Web part Quick links Web part At Site Page library Navigation links Viva Connection Dashboard In this blog, Only News Web Part and Event Web Part will be discussed. New Web part – Whenever any author is creating news post. It creates in Site Page library as a new page. So enable audience targeting is a two-step process that are given below. Enable audience targeting at Page Library in which your news pages are created. Enable audience targeting at the news web part level. We will discuss one by one each pro...

Targeting Audience with SharePoint

Target Audience with SharePoint Targeting audience in SharePoint Server is key functionality to manage the information access to specific set of employees on SharePoint site pages. In interview common question is" how can handled a set of people with same interest I mean group of people which are from Same departments like Sale, HR, Management etc. in an Organization ". Lets Start answering for this question. Basically SharePoint has multiple ways to handle Target Audience for different type of content. which are following- 1- Set Target Audience for a Web Part- This is very common way to handle Target Incidence. this used by SharePoint Administrator. Target audience is supported by few Out of Box Web Parts like Content editor. To set the audience, First move page in edit mode then edit the Content editor Web Part. set the audience name in audience field. 2- Display SharePoint List and Library items in Webpart to Targ...

Custom Master Page In SharePoint-2013

Custom Master Page In SharePoint-2013 Today We are Going to creating a custom Master Page for SharePoint 2013 using Visual Studio 2012. The Process is similar as was done in SharePoint 2010. Steps are following to create my custom Master Page: Step-1 Take a copy of your SharePoint-2013 master pages like Seattle.master and Oslo.master from the directory "15\TEMPLATE\GLOBAL". Paste this master page in a folder and rename the file like (i.e Custommaster.master) Step-2 Add a new Module(name like CustomMasterPage) and delete sample.txt file that was created automatically by adding module. Step-3 Add Custommaster.master file to the Module and change some Parameters like ...

SharePoint Mania

Search This Blog