[Product-Developers] How to search and sort content based on owner last login time?

Jens W. Klein jens at bluedynamics.com
Tue May 22 07:24:10 UTC 2012

On 2012-05-13 03:08, zjs2k wrote:
> I would like to hear any suggestion and comment on how to do this. First, I
> will create a property/field somewhere to update the user login time
> (probably a property on user metadata). They I want to present contents
> sorted on user's last login time. So the contents made by the most recently
> login user will be listed first. (then, I would sort contents from the same
> user by modification date. I think AdvancedQuery can do multiple index
> sort.)
> Is this possible with zcatalog? Or do I have to go with relational database?
> For mysql, I can see "join" table search working for this purpose. But how
> do I do it with Plone/zodb? I don't want to update all contents by a user
> every time he logs in. It could mean updating thousands of objects for just
> one user, who could login multiple times a day. Any thoughts?

I'd do it this way:

a) add a subscriber and let it write login time to some IOBTree 
(annotate it to the portal) with key Integer-Value from Creator Index 
and value the login time (maybe using a timestamp similar the one from 
dateindex can reduce this to use the faster IIBTree).
maybe collective.lastlogin does so or similar, i never used it.

b) write an catalog index 'userslastlogin' which does not store 
anything, but maps on low-level (IITreeSet) Creator index to login 
timestamp from your IIBTree and return it sorted. an example how such an 
index may look is DateRangeInRangeIndex.

So you can - with a good performance - simply ask the catalog to sort_on 
your new index.

After that youre familar with how to write catalog indexes. It isnt that 
hard but theres nowhere good documentation about it (except the code 

hth Jens
Klein & Partner KG, member of BlueDynamics Alliance

More information about the Product-Developers mailing list