current search spec too complex error
Hello All,
I am running a web service were I am comparing values from a csv to those already in CRM. When the csv is a small file(less than 50 records), everything is fine. If the file is larger I get the "current search spec too complex" error. I see that the error is related to the "OR" operator and there is a workaround when comparing 2 expressions.
(Expression A) OR (Expression can be converted to the equivalence: NOT (NOT (Expression A) AND NOT (Expression )
But I have 100s of expressions. Will someone please show me an example of the syntax that can be used when comparing more than 2 expressions?