Karine Bosch’s Blog

On SharePoint

CAML Designer support for SharePoint Online


Yesterday we’ve put a new version of the CAML Designer online. This version fixes a number of bugs but also introduces support for SharePoint Online and cross-site lookups.

When you open the CAML Designer and click the CAML Query tab, the logon dialog is immediately displayed. You can fill out the URL to your SharePoint Online site. You don’t have to specify your credentials in the credentials box at the bottom of the logon dialog because they will be asked later on while authenticating. Don’t forget to switch to Client Object model or even the SharePoint Web Services.

Once you click the OK button, a browser is opened which asks you to enter your credentials to get authenticated against SharePoint online.

Once your credentials are validated, you will that the treeview gets populated with the lists and libraries of the SharePoint Online site.

We also changed the flow of the user interface a bit. When you click the Connect button, the logon dialog is displayed. After entering a valid URL and having clicked the OK button, your are automatically redirected to the CAML tab. Once on the CAML tab, the treeview is automatically populated with the lists of the SharePoint site you wanted to connect to. Selecting a list will populate the left panel with fields, but also activate the Where button so you can immediately start building the Where clause.

Another improvement we built in based on input of one of our users, is the dropdown list on the logon page with URLs you already accessed using the CAML Designer.

More detailed documentation on CAML and the CAML Designer can be found here.

One of our “users” – or may we call him beta tester? – Maximilian Melcher also recorded a video on the CAML Designer🙂. Thanks Max!

June 6, 2012 - Posted by | CAML Designer

6 Comments »

  1. Excellent work guys! Very useful for Office365 projects🙂

    Comment by Twitter: @SharePointOscar | June 20, 2012 | Reply

  2. Crashes every time I try and click on list field to drag across

    Comment by John | November 5, 2012 | Reply

    • Hi John,
      Thanks for your feedback. Can you send more detailed info and screenshots to camlfeedback@biwug.be? I’ll try to find out and resolve the problem.
      Karine

      Comment by Karine Bosch | November 5, 2012 | Reply

  3. whoah this weblog is magnificent i like studying your articles.
    Keep up the good work! You realize, a lot of people are hunting around for this information, you could
    aid them greatly.

    Comment by IT Managed Services | September 24, 2013 | Reply

  4. Heya just wanted to give you a quick heads up and let you know a
    few of the pictures aren’t loading correctly. I’m not sure why but I think its
    a linking issue. I’ve tried it in two different internet browsers and both
    show the same results.

    Comment by Chet | December 27, 2013 | Reply

    • Thanks for the comment. I’ll check the images as soon as I can.
      Karine

      Comment by Karine Bosch | December 27, 2013 | 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: