SharePoint 2010 : New CamlDesigner (CAML Builder)

By -

CAML Designer (Known as CAML Builder) is a great tool for generating CAML Query and some of the advanced CAML search result. This tool is created by SharePoint MVP Karine Bosch and Andy Van Steenbergen. You can download the tool from here.


Some of the feature contains by CAML Designer.
  • You can connect three ways: 
    • using the server object model 
    • using the client object model 
    • using the SharePoint web services 
  • UI support Ribbon 
  • UI support for LookupId='True' (filter on the ID of a lookup value) 
  • UI support for QueryOptions 
  • UI support for Query all files and folders by using (ViewAttributes Property of the SPQuery Class) 
  • Code snippets 
    • The Server Object Model 
    • The .NET Client Object Model 
    • The web services 
  • Drag and drop functionality 

Problems 
  • Not supported MOSS only works in SharePoint 2010. 
  • Design issue : Query main Screen Scroll-bars missing  ex. Files and folder Options not visible (Query Options from the ribbon)
  • Code snippets Problems example : Server Object model (ViewFields missing single quotes and verbatim (@) at the begging of the Viewfieds) 
  • qry.ViewFields = "<FieldRef Name="ContentType" /><FieldRef Name="Modified" /><FieldRef Name="Modified" /><FieldRef Name="ContentType" />";
Download and explore your self. You really like this :).


Comments

  1. Andy Van Steenbergen15 May 2013 at 00:29

    hey

    I've noticed this post, if you want you can download the new CamlDesigner 2013... It now support SharePoint 2010 and looks a lot nicer as well ;-)

    kind regards
    andy

    ReplyDelete
  2. Anonymous22 May 2013 at 21:51

    It stinks. It is very very pretty and useless.
    If only the time taken to make it pretty was used to make it work!

    ReplyDelete

Post a Comment

Popular posts from this blog

SharePoint RPC Protocols Examples Using OWSSVR.DLL

By -
Image
What is SharePoint RPC Protocols? Part 1 This reference includes information about the methods and usage of SharePoint Foundation Remote Procedure Call (RPC) protocol. This protocol can be used in Win32-based applications or in ASPX applications to make HTTP POST requests to the server. Methods in this protocol that do not modify the contents of the database can also be used in URL protocol to make HTTP GET requests. Definition taken from http://msdn.microsoft.com/en-us/library/ms448359.aspx You will find the OWSSVR.DLL in SharePoint 2010 Server Physical Path: C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\14\ISAPI and MOSS C:\Program Files\Common Files\Microsoft Shared\Web Server Extensions\12\ISAPI OWSSVR.DLL List of commands DialogView  Display ExportList GetProjSchema GetUsageBlob HitCounter RenderView To read more about the OWSSVR.DLL command Please read the URL Protocol from Microsoft Blog having a URL http://msdn.microsoft.com/en-us/
Read more

Send Email using SharePoint Rest API

By -
We have a requirement to send email vai SharePoint Rest API. We dig and find the below solution to send email using SharePoint API. Point Must be remember End point " /_api/SP.Utilities.Utility.SendEmail " end point to send email.  In JSON __metadata we used the type " SP.Utilities.EmailProperties ". The User / Group must have a read permission for particular site. where we placed this site code. JS Dependency  JQuery Code URL:  https://gist.github.com/BasantPandey/05189832546f2c6cc0bd008fcfec3264#file-sharepointsendemail-js Code  var Email = function (){ // Email Either email groupname or email address var from = ' abc.yahoo.com ' , to = ' abc.yahoo.com ' , cc = ' abc.yahoo.com ' , subject = ' My Email Subject ' ; this . options = this . options || {}; this . options [ ' fromEmail ' ] = this . options [ ' fromEmail ' ] || {}; this . options [ ' toEmail &
Read more

Query suggestions in SP 2013 Using Rest API (/_api/search/suggest)

By -
Image
SharePoint Query suggestions: In this post I am going to share with you code snippets to implement the query suggestion in custom text box. Below are the dependency files  1. Jquery UI : http://code.jquery.com/ui/1.10.0/jquery-ui.js 2. Jquery AutoComplete CSS: http://code.jquery.com/ui/1.10.0/themes/base/jquery-ui.css http://code.jquery.com/ui/1.10.0/themes/base/jquery.ui.autocomplete.css 3. JQuery: http://code.jquery.com/jquery-1.8.3.js Query Suggestion Parameter: Here is the post http://blogs.msdn.com/b/nadeemis/archive/2012/08/24/sharepoint-2013-search-rest-api.aspx that specified the detail query suggestions parameter list. Implementation: I have two vertical examples. 1. People Vertical 2. Everything Vertical I wanted to display the query suggestions on TeamSite pages although my search is configured in one of our serach center, so when user search for a particular term and it contains in the search query completion list t
Read more