I have a list with an URL-field. Nothing special, just the OOTB Hyperlink-field.
I want to execute a CAML-query that selects items with a certain value in the description part of the URL-field.
<Query> <Where> <Contains> <FieldRef Name="URL" /> <Value Type="URL">text</Value> </Contains> </Where> </Query>
Result Only items with 'text' in de url part are selected, if a item has 'text' in the description part it is not selected.
How do i select items based the description of the URL?