SPCAMLQueryHelper

Rating:        Based on 10 ratings
Reviewed:  9 reviews
Downloads: 113263
Released: Mar 19, 2012
Updated: Nov 29, 2015 by bandrben
Dev status: Stable Help Icon

Recommended Download

Application SPCAMLQueryHelperOnline.exe.zip
application, 328K, uploaded Nov 29, 2015 - 35395 downloads

Other Available Downloads

Application SPCAMLQueryHelper.exe.zip
application, 439K, uploaded Nov 29, 2015 - 75658 downloads
Source Code SPCAMLQueryHelper.zip
source code, 1022K, uploaded Jun 19, 2013 - 2210 downloads

Release Notes

11/29/2015 - Latest version SPCAMLQueryHelperOnline available, compatible with SharePoint 2010, SharePoint 2013, SharePoint Online and Office 365. No more SharePoint Object Model, can run from any computer with internet connection to SharePoint. Requires .NET 4.0.

Fixed runtime error when loading site lists.

Older versions still available for download too.

Download and run SPCAMLQueryHelper.exe. Tested in x86 and x64 systems, MS Server 2003, MS Server 2008, MOSS 2007, SharePoint 2010, SharePoint 2013, Office 365 and Windows 7 (x64), Windows XP (x86) as client.

New Features (as of 11/4/2013):
  • Supports Office 365.

New Features (as of 5/28/2013):
  • Session information is saved and loaded each time program is opened and closed. So the previously entered URL, query, credentials, etc. will be remembered.
  • More query sample templates are loaded to help build CAML Queries.
  • Netwonsoft API dependency removed, which occasionally caused query errors.
  • Exporting grids now uses a proper save file dialog instead of dumping to executable directory.
  • Does not load all sites within the currently loaded site anymore. When loading a site collection with hundreds or thousands of sites, this feature would crash the program. The program will now only load the current site entered and display all the lists in that site.
  • More list reflection, added a new button that will load List Details. Opens a new window showing list properties.
  • More field reflection, double click a field in the grid and a new window appears showing field properties.

New Features (as of 7/26/2012):
  • Bug Fixes (window resizing issue, new "tips" hover, <Query> wrapping difference for SOM and Web Services searches)
  • Connect using SharePoint Object Model or SharePoint Web Services
  • Resize/Maximize window resizes window controls
  • Choose a View to use its Query and Row Limit
  • Enter View Attributes too, ex. Scope=”Recursive"
  • Hit enter after typing the site url, to load the site's (collection) sites and lists
  • Open List Views and examine View Schema CAML
  • Copy Query and View Fields to C# code in "string" format
  • New Branding

Reviews for this release

     
I've been looking for a reliable CAML query builder/helper tool and this works perfectly for that. I need to quickly see the internal fields and test CAML queries and this tool does exactly that. Great BETA release!
by _tomdaly_ on Mar 21, 2012 at 8:44 PM
     
This actually worked... after trying out other buggy CAML query builders, this is really great. Thank you for making it available.
by quetzalpie on Dec 5, 2015 at 5:20 PM
     
Excellent software. It provides SharePoint names of fields, list guids, etc..
by baw02141 on Sep 22, 2015 at 9:43 PM
     
Quick and easy tool to get internal column names and CAML query building and testing. Has crashed from time to time but otherwise reliable and dependable.
by Arknev on May 14, 2015 at 5:48 PM
     
great tool and working for o365!
by felaray on Dec 29, 2014 at 5:54 PM
     
This tool is brilliant - must have when integrating with Sharepoint.
by joe_om on Mar 10, 2014 at 1:32 AM
     
just excellent
by nplanchart on Dec 19, 2013 at 4:18 PM
     
IT is very good to deign CAML with this tool... thanks for your effort
by kepils on Nov 28, 2013 at 10:43 AM
     
Works as expected in 2007 and 2010 SharePoint. Kinda simple interface, not too many features, but can't think of anything it really needs (maybe better drag-drop support, and saving export files to specific location?). Added to my list of tools to use for sharepoint dev.
by codemonkey01 on Mar 21, 2012 at 8:33 PM