I've spent about two hours trying to get this to work...no luck yet...need help please!
The value I'm looking for is "3 - Planning" in the CurrentPhase lookup field.
Here is my CAMLQuery: (I can't use the paste code function...it's blocked by my network)
...inside the "Where" tags: <FieldRef Name='CurrentPhase' LookupId='True' /><Value Type='Lookup'>3 - Planning</Value>
Returns no records. I've tried LookupId True/False to no avail. I've tried formatting the criteria the way it's returned in a recordset - "3;#3 - Planning"...to no avail. I've also tried using a var to hold the criteria...no
worky. I've tried LookupId='False' and using the number 3 as criteria...no luck.