Skip to main content

SharePoint 2010 : New CamlDesigner (CAML Builder)

Image
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 :).


Labels:

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
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...
1 comment
Read more

SharePoint 2013 Search Database Part 1

By
SharePoint 2013 Search architecture drastically change, as earlier in FS4SP 2010 we have 2 search applications “FASTContentSSA” and “FASTQuerySSA” and 7 total database in use. Following are the List of DB (FS4SP) FASTContentSSA Search Service Application DB Search Service Application Crawl Store DB Search Service Application Property Store DB FASTQuerySSA Search Service Application DB Search Service Application Crawl Store DB Search Service Application Property Store DB FASTSearchAdminDatabase : Fast Search Admin Database  In SharePoint 2013 search has only 1 Search Service application and 4 database in use. No property store database need any more, now the properties are directly stored inside the index component and all the index directly indexed to the physical system where FS4SP data comes from database as well as from the File system now data directly stored and indexed/ retried from the Physical disk because of this performance increase and search experien...
Post a Comment
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 ...
Post a Comment
Read more