I need to query from pages library to get a HTML column. This column contains rich text and references to various URLs(anchor tag). The query should return items which contain a column value with hyperlink to certain URL Pattern.
For ex: Column contains
Below is my caml query:
<ViewFields> <FieldRef Name='MyColumn' /> </ViewFields> <Where> <Contains> <FieldRef Name='MyColumn' /> <Value Type='HTML'>a href=http://example.com/my-sites/</Value> </Contains> </Where> <QueryOptions> <ViewAttributes Scope='RecursiveAll' /> </QueryOptions>
This query does not return expected results.
I would like to know what is the best way to retrieve such items. I need to use this query in a power shell script.
Can anyone help me here, please?
Thanks in advance!!!