SharePoint – Yet Another CAML Query tool (ala SQL)

Some time ago, I thought write a small tool in order to do CAML queries in plain text, as in SQL «where» clause. I have the idea forgotten, I missed myself in the daily work. Yesterday doing a little modification in a program I remembered this, of course while I was writting a complex CAML query.

I named it «Yet Another CAML Query Tool» aka (YACAML-QT).

By moment it’s a little toy, you can write your queries as in a «where» clause, using the same syntax that you’d write in a SQL Sentence. It’s is more easy!!!

Use «=null» as CAML IsNull operator and «<>null» as IsNotNull also you can use dates enclosed into sharp characters #01/01/1990# the sql Like operator is replaced by CAML Contains and the at «@» operator for the CAML BeginsWith. Also support parentheses for operator precedence.

TODO: a pretty interface 🙂

(File Updated December 9, 2007)

Un comentario sobre “SharePoint – Yet Another CAML Query tool (ala SQL)”

Deja un comentario

Tu dirección de correo electrónico no será publicada. Los campos obligatorios están marcados con *