FormQueryPlugin, MailerContrib and newsletter problem

I have a problem generating newsletters using WebNotify when the original pages on the wiki are generated by FormQuery/ShowQuery results of the same underlying Forms based database. It looks like the DB Cache is not flushing between newsletters, resulting in duplication of entries in the later newsletters.

My WebNotify looks something like:

* MyUserName : FormQuery1WikiPage! FormQuery2WikiPage! FormQuery3WikiPage!

The first email newsletter (which may change depending on how mailnotify sorts the above entries) will match its corresponding wiki page, but the later email newsletters will not. If N pages are added to WebNotify as newsletters, the Nth email will have N times the original number of entries on its corresponding wiki page. Very strange.

I'm working with a local database created using Forms, but I could probably try to reproduce this with the user data forms on the Main web. I'm just wondering at the moment if anyone has encountered this issue previously.

Is there a way to force the FormQuery cache to empty between each newsletter? Is that the problem?

---

Almost certainly. Unfortunately there is no way to flush the cache. Good point, raise a task to get that added (or code it yourself, much faster turnaround that way)

-- CrawfordCurrie - 03 Aug 2011