Category Archives: CAML

Querying a Hyperlink field using CAML

Recently I had a requirement to search for items with a certain URL in the Hyperlink field. I noticed that the value being stored in the Hyperlink field is of the format ,. The is an absolute URL. Using a … Continue reading

Posted in CAML, SharePoint | Leave a comment

New CAML operator in SharePoint 2010: IN

It took me 20 mins to work out why my CAML was working against 1 environment and not another. It turns out because I was using the IN operator and that’s new in 2010 and not available in 2007. This … Continue reading

Posted in CAML, SharePoint | 2 Comments

CAML Gt AND Lt AND calculated field AND the wicked U2U CAML Query Builder

U2U CAML Query Builder is a must have tool for SharePoint developers, but today it was giving me grief. I have a calculated column called ‘Duration (months)’. I wanted to find items where duration is less than 24 and more … Continue reading

Posted in CAML, SharePoint, SPFieldCalculated | Leave a comment