Karine Bosch’s Blog

On SharePoint

CAML Designer for SharePoint 2013 released!


Andy Van Steenbergen and I worked very very hard to revamp the CAML Designer and finally the tool is ready to be released: here is the CAML Designer for SharePoint 2013!I don’t need to mention that we are very proud of it🙂

This version is much more user friendly and no hasle with resizing of the different panels anymore. The design is metro style based.

CD2013

The functionality of this version of the tool is similar to what it offers you for SharePoint 2010:

  • you can build CAML queries for single lists
  • you can build queries that can be executed with SPSiteDataQuery
  • beside the pure CAML queries, you can also get code snippets for the server-side object model, the .NET client-side object model, the JavaScript client-side object model and last but not least code snippets when working with REST.

With this first version of the tool you are not able to connect to SharePoint 2013 online yet, but it is definitely something we are going to look at for next version.

In the past, a number of additional functionalities have been requested, like f.e. a search box to search for a field in a list with a lot of fields. These functionalities have not yet been built in. Also taxonomy support for client-side object has been enhanced in SharePoint 2013 but these enhancements are not yet reflected in the tool.

As you can see, we still have a lot of work on our plate to make it the perfect tool🙂

You can download the tool from the BIWUG site. Click the download tab, select the CAML Designer and there you will find a link to download the application.

A detailed explanation on how to use the tool can be found here.

Have fun with it and please, don’t hesitate to give us your feedback!!

December 13, 2012 - Posted by | Uncategorized

25 Comments »

  1. Thanks a lot..🙂

    Comment by Raghavendra Shanbhag | December 14, 2012 | Reply

  2. […] CAML Designer for SharePoint 2013 released! « Karine Bosch’s Blog Anyone who’s worked with CAML before knows how crappy and unforgiven the syntax can be. Karine has done a great job of getting the designer out there in the wild already! Highly recommend this for anyone writing CAML! […]

    Pingback by My SharePoint links December 18, 2012 | Jeremy Thake's musingsJeremy Thake's musings | December 18, 2012 | Reply

  3. Reblogged this on c:Marius Blog and commented:
    I’ve been using quite extensivelly ever since SharePoint 2007 the valuable CAML builder made by people at U2U. An update has been released not so long ago for SharePoint 2013 (yes, despite what you might have heard CAML is here to stay, even though XSLT is really picking up on the User Interface side of things).

    Comment by C. Marius | January 14, 2013 | Reply

  4. Thanks ! That could help me with my JavaScript API I built for Sharepoint (http://aymkdn.github.com/SharepointPlus/). In my API the user uses the SQL syntax and the script then converts it to a CAML syntax🙂

    Comment by aymkdn | January 18, 2013 | Reply

  5. CAML designer is very useful tool.I can say it’s a really improved version of the CAML Query Builder.By this I could connect to the Server Object Model,the client object model and SharePoint web services.

    Comment by Walter Puckett | January 21, 2013 | Reply

  6. wow its just an awesome product … that has been built… awesome metro UI, awesome code generation.. and what else can be more beneficial for sharepoint…

    @Karen are u looking forward for support of joins and projections in the next release….
    We need it… that would have been more awesome …🙂

    Comment by THATTHATGUY | February 14, 2013 | Reply

  7. Hi that guy,
    Yes this is only version 1. We are going to extend it with other snippets and also with joins and projections.
    Thanks for liking the app!!
    Karine

    Comment by Karine Bosch | February 17, 2013 | Reply

  8. Very nice. Few things though. I have a LookupCode and LookupDescription columns in the list. In viewfields, it generates LookupName and LookupDescription. Also, I could not do IsNULL. Am I missing something?

    Comment by Bhaskara | February 22, 2013 | Reply

    • Hi Bahaskara, the CAML Designer shows the display name in its lists of fields. I’ll verify why you can’t do a ISNULL becuase I though this should work.

      Comment by Karine Bosch | February 22, 2013 | Reply

  9. […] CAML Designer for SharePoint 2013 released! « Karine Bosch’s Blog. […]

    Pingback by Quick Note: CAML Designer für SharePoint 2013 veröffentlicht | WTF.Net | July 9, 2013 | Reply

  10. hmmm it does not support https

    Comment by Viperhx | September 6, 2013 | Reply

  11. Hi Guillaume, thanks for your feedback. Unfortunately, I cannot help you with the CAML Builder, its U2U property. But you can also try to be constructive to make this tool better and send your bugs to camlfeedback@biwug.be.
    Kind regards,
    Karine Bosch

    Comment by Karine Bosch | February 8, 2014 | Reply

  12. Do you have download link to SharePoint 2003 version?

    Comment by falaky@gmail.com | February 19, 2014 | Reply

    • You can download it from the biwug site: http://www.biwug.be.
      Kind regards,
      Karine

      Comment by Karine Bosch | February 19, 2014 | Reply

  13. Does this utility work with sites that use forms authentication? I have attempted several permutations and am unable to get connected to my site.

    Comment by Tony Fountain | March 25, 2014 | Reply

    • Hi Tony,
      This is one of the cases we never tested out; I’ll put it on our bug list. Thanks for the feedback.
      Kind regards,
      Karine Bosch

      Comment by Karine Bosch | March 26, 2014 | Reply

      • Thanks! I’ll keep an eye out for an update.

        Comment by Tony Fountain | March 26, 2014

  14. […]  1. using the server-side object model when the CAML Designer is installed on the machine running SharePoint 2013 2. using the .NET client-side object model when the CAML Designer is installed remotely 3. using the plain old web services of SharePoint Download for SharePoint 2010 here Download for SharePoint 2013 here […]

    Pingback by CAML designer | Errors - Problems (SharePoint - ASP.Net - SQL ... etc) | October 14, 2014 | Reply

  15. […] 21 CAML Designer for SharePoint 2013 […]

    Pingback by SharePoint Developer Tools | mcitpsharepointsupport | May 6, 2015 | Reply

  16. Awesome tool. Create REST, CSOM and CAML Query. Wow… thanks for your efforts.

    Comment by Chintan | December 31, 2015 | Reply

  17. In Caml Designer there is no option for generating javascript caml query ..Can any one help me to generate javascript query

    Comment by swetha | February 17, 2016 | Reply

    • Hi Swetha,
      Thanks for your feedback. This is on our TODO list.
      Karine

      Comment by Karine Bosch | March 9, 2016 | Reply

  18. This is a fantastic utility. Thanks for writing it. Two items to consider:

    Would be great to add support for IncludeTimeValue=’TRUE’ for datetime column types a Leq or .

    Also, ability to reset columns once you add them to the ViewFields or Where UI panels, you cannot remove them in the UI. You have to start from scratch.

    All the best and thanks again.

    Comment by Edgar | April 28, 2016 | Reply

    • Thanks for the feedback, we are going to take this into account!
      Karine

      Comment by Karine Bosch | May 5, 2016 | Reply


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: