SharePoint Interview Questions and Answers: SPSiteDataQuery

Download: https://sites.google.com/site/sasivalipireddy/home/SPSiteDataQuery.png 

1. What are SPQuery and SPSiteDataQuery?
2. SPSiteDataQuery properties?
3. Difference between SPQuery and SPSiteDataQuery?
4. What are the limitations of both?
5. How the SPQuery and SPSiteDataQuery return?
6. How to set the row limit to the both?
7. Searching scope levels of SPQuery and SPSiteDataQuery?
8. What is the max limit of querying the lists using SPSiteDataQuery?
9. Is it possible to query the records across the site collection level using SPSiteDataQuery?
10. What is the default row limit value for the SPQuery?
11. SPQuery.RowLimit Property?
12. To Query all Web sites in this site collection?
13. How to query the specific lists only using SPSiteDataQuery?
14. Difference between Caml and Linq queries?
15. How to set the Max lists limit?
16. what all are Errors you faced while working on SPSiteDataQuery?
17. I have created a custom list called “Employees” in all the sites in a site collection and have added the data in all the lists. Now I want to query those specific lists only. What is the approach?
18. How can consider hidden lists also in SPSiteDataQuery?
19. Is it possible to do joins lists using SPQuery?
20. How to query with the type: Single line of text, multiline of text, persons or groups, DateTime etc..
21. How to get the folders and sub folders levels documents from the document library?
22. How to query specific list using SPSiteDataQuery?

How to query specific list using SPSiteDataQuery?
Query.Lists="    <Lists><List ID=”960BF6F6-F264-4305-B3CB-BDB9BF8F67DF” /></Lists>" – query a specific list 

Using Folder, FilesOnly, Recursive, RecursiveAll in SPquery in SharePoint

http://spdailytips.blogspot.in/2011/09/using-folderfilesonlyrecursiverecursive.html

 

Joins in SPQuery

http://msdn.microsoft.com/en-in/library/ee539975%28v=office.14%29.aspx

http://sprider.org/2011/07/09/sharepoint-2010-list-joins-spquery-enchancements/

http://sharepointfordeveloper.blogspot.in/2011/10/step-by-step-spquery-list-joins.html

SPQuery Quick Guide

//Query on single line of text:
SingleLineOfText

//Query on Multiline of text: - note use of [CDATA[] to avoid parsing errors
<![CDATA[Search Criteria]]>

//Query on Person or Group (By Name)
Sasi Kumar Reddy

//Query on Person or Group (By ID)
4

//Query on SPUser ID

7 

//Query on SPUser Name
john 
 

//Query on DateTime Only
2012-01-10

//Query on DateTime 
>

//Query on Lookup by text
SasiReddy

// Query on Lookup by ID
108

// Query on Today date


// Query on last week


//Query to return only empty columns, 
query.ViewFields="";  

Best Reference:

http://joshmccarty.com/2012/06/a-caml-query-quick-reference/

http://www.paint-it-yellow.co.uk/bobsblog/?p=472

http://snahta.blogspot.in/2009/07/spquery-few-important-things.html

http://ranaictiu-technicalblog.blogspot.in/2009/11/sharepoint-user-idname-in-spquery.html

http://kartooz.wordpress.com/2009/02/12/using-spquery-to-filter-lists-by-domain-user-account-and-spuser-id/ 

Thanks,
Sasi Kumar Reddy

http://sharepointquicksolutions.blogspot.in