I have two indexed fields, FieldX and FieldY. I want to search for all instances of FieldX that contain 'ABC' where FieldY does not contain '123'. I assume the format would start something like:
FieldX=ABC AND FieldY
but I don't know how to finish that. Would someone please help me out?
... View more