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 🙂