[Helma-user] invalidate() does not work on grouped collections

[Franz Philipp Moser]

Hi list,

I have a children collection in a NewstickerMgr mounted on Root 
(newstickermgr = mountpoint(NewstickerMgr)):

_children                 = collection(NewstickerEntry)
_children.group           = NTE_COUNTRY
_children.group.prototype = NewstickerCountry
_children.order           = NTE_ORDER ASC
_children.readonly        = true


As you can see I have them grouped by the country column.

These two things don't work:

Root.newstickermgr.invalidate();
Root.newstickermgr.get("de").invalidate();

In the SQL logs I see the following for the second statement:
SQL SELECT_IDS NEWSTICKERENTRIES 0: SELECT NEWSTICKERENTRIES.NTE_ID FROM 
NEWSTICKERENTRIES WHERE NEWSTICKERENTRIES.NTE_COUNTRY = 'de' ORDER BY 
NTE_ORDER ASC

But I still get the old values when doing:
Root.newstickermgr.get("de").get(something);

I need this because the values for the newsticker are inserted by an 
separate update script witch inserts directly into the database.

I know I can do this with a workaround for example mount collections for 
every needed country or doing a seperate sql statement, but I'd like to 
do this with helma group functionality.

Can somebody help, please?

cu Philipp
-- 
XML is the ASCII for the new millenium
(Cocoon Documentation)