Recently ran into a strange bug with Query of Query.
I’m looping over an outer query "queryA", which has the collection of patterns.
For each one, I have 2 other queries; queryB and queryC.
I tried getting a QofQ on the queryB, then looping over that to check an error condition. then for error, list a key field of the outer main A query. Looping over the QofQ gave me the wrong result from the outer query!
Tip: If you’re using a Q of Q, and looping over it, make sure to put fields from the outer query in local variables. Or find a way that doesn’t involve Q of Q until they finally fix the stupid thing 🙂
(same or similar issue was there ever since CF5; still in 7.0.1 cumulative hotfix 2. We’ve run into on many projects)
– David and Ajay