[Zope-CMF] sum up member properties for specific time period

[Raphael Ritz]

Norman Khine wrote:

>hi dieter,
>thanks for the reply, but i am not sure i understand ;^(
>
>you're saying that i should store these data within a database rather than
>the ZODB? or am i wrong?
>
>what i have is that i have setup some additional properties to the Member on
>the CMF, this includes Join_Date, Office_Location etc, so when a user joins
>the form registers the Date & Time and also it asks them to select from a
>drop-down box the Office_Location(this is stored as 1, 2, 3 - where 1 is the
>Head Office, 2 is Editorial, and 3 is Developmet) - all this is stored on
>the ZODB and if I use the how-to http://www.zopelabs.com/cookbook/1048010784
>i can see all the data that I need to analyse, BUT don't have the know-how
>of how to achieve this ;^(
>
>also, looking at the http://www.zopelabs.com/cookbook/1054497272 we can
>count how many members we have? so isn't there a way to group these by
>Join_Date property?
>
>does this make my query still unworkable, or have i missed something in your
>reply.
>

An alternative might be to use the catalog for your task.
If you index Join_Date you could do a date-range search on that later.

Raphael

>
>thanks
>
>norman
>
>----- Original Message -----
>From: "Dieter Maurer" <dieter@handshake.de>
>To: "Norman Khine" <norman@khine.net>
>Cc: "Zope-CMF" <zope-cmf@zope.org>
>Sent: Monday, June 02, 2003 6:05 PM
>Subject: Re: [Zope-CMF] sum up member properties for specific time period
>
>
>  
>
>>Norman Khine wrote at 2003-6-2 08:31 +0100:
>> > how can one, sum up the member properties? for example, i would like to
>>    
>>
>be
>  
>
>> > able to sum up all the members that had joined the cmf portal within a
>> > specific time period, and get a table like so:
>> >
>> >
>> >   Date  \  Member Type  |   REVIEWER     |     MEMBER   |  TOTAL
>>
>>    
>>
> > ------------------------------------------------------------------------
>  
>
>> > MAR-03                       |      2                   |           10
>> > |  12
>> > APR-03                       |        4                 |            12
>> > |   16
>> > MAY-03                      |        1                 |            23
>> > |     24
>> > JUN-03                        |       0                 |
>>    
>>
>2
>  
>
>> > |      2
>>
>>    
>>
> > -------------------------------------------------------------------------
>  
>
>> > TOTAL                      |             7            |
>>    
>>
>47
>  
>
>> > |      54
>>
>>Zope does not directly maintain this information for you.
>>
>>When you are using FileStorage (the default ZODB storage),
>>then in principle historical information is maintained
>>up to the last pack time. But it is not easy to access
>>this information (for ObjectManager like objects).
>>
>>The best way is that you store the information yourself.
>>
>>
>>Dieter
>>
>>_______________________________________________
>>Zope-CMF maillist  -  Zope-CMF@zope.org
>>http://mail.zope.org/mailman/listinfo/zope-cmf
>>
>>See http://collector.zope.org/CMF for bug reports and feature requests
>>
>>    
>>
>
>
>_______________________________________________
>Zope-CMF maillist  -  Zope-CMF@zope.org
>http://mail.zope.org/mailman/listinfo/zope-cmf
>
>See http://collector.zope.org/CMF for bug reports and feature requests
>
>  
>