Query Settings & Options

Query Settings

QuickCAML provides the following query settings for you to adjust as needed:

• Site Url: Sever-relative URL of the site you want to work with. Click the Change link to change the URL. By default, it is set to the site you're currently viewing. Because of security restrictions in SharePoint, the URL must be in the same site collection where QuickCAML itself resides.
• List or library: The list or library you want to query.
• Query (CAML): Your CAML query. The text editor provides intellisense, smart indenting, and syntax highlighting to help you write your query. Microsoft has a CAML query reference here: https://msdn.microsoft.com/en-us/library/office/ms467521.aspx
• Row limit: The maximum number of results to fetch from SharePoint. You can interpret this as "results per page" if your query returns more than one page of data.
• Calendar date: This setting only applies if you're querying a calendar list and have also enabled the Expand Recurrence query option. It provides a context date for SharePoint to use when querying calendar events. If empty, SharePoint returns events relative to the current date.
• Folder Url: Server-relative URL of the list/library folder you're querying. QuickCAML sets this to the root folder of the list by default since that's how SharePoint behaves. If you want to only query a sub-folder, you can change this URL as desired.

Query Options

QuickCAML also provides several query options to change how your query is interpreted by SharePoint. The query options provided by QuickCAML are:

• Dates in UTC
• Expand Recurrence
• Expand User Field
• Include Attachment URLs
• Include Attachment Version
• Include Mandatory Fields
• Include Permissions
• Recurrence Order-By

All of the above are documented by Microsoft here (see the queryOptions parameter in the Syntax section):

http://msdn.microsoft.com/en-us/library/lists.lists.getlistitemchangessincetoken%28v=office.12%29.aspx

The above article targets SharePoint 2007 (WSS 3.0) but is still accurate. Microsoft's newer articles targeting SharePoint 2010 and 2013 don't provide as much detail on these options.