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

[Andreas Jung]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



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?

Weird idea. Getting hold of content objects created or modified after
some given date is nothing like a standard range search using the
ZCatalog.  Where and why would one need a RDBMS here?  Where would and
why would one need a JOIN here? Sorting on multiple criteria is both
doable with AdvancedQuery and sequence.sort()....so your question is?
Everything is doable with the base functionality of Plone. Why do you
need something different? The solution is at your finger tips...your
problem is?

- -aj
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.11 (Darwin)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org/

iQGUBAEBAgAGBQJPrzRxAAoJEADcfz7u4AZjqqgLwLaOGXrNkd3yb8UXAHnbbc0J
hSomVljVp+Sm9523NOE70+cF3jNmPsUtheapV+4IXjWj5Zs1PfpiyF8xJYSTLs+f
25gY32ai82bxC3gZBepswgo627xCYC05eq/aBpYOhOkA3N6gEEvODGdDtqZeDjpu
esryTgHnhvnFSidWEGfvQ4uGEqxuZAwr6d6gcHYXb6u4vg3S7HoCcCKBCVMxVYLx
9O1qo7GBAhIxewzuuba0sxvtV+utnUskYXEebHgs7nOpuYLzTLekGASWmWzwmWE3
1BKqQRL0ayJFIq2YUtgNogFJzCgKsrlVIaQnq0fQZF9w0uKNIhwd7RLsNH39sgwV
RxLgT8lUDHqPx2c16GDu4f35HA2P702gHxwKTfxFa4uDG8UaZPGL3hvozlc15RIm
bHX4bZyLYa05PhpDM8R0g9NJ3Kj5NXqx2s/PPok0ya0JuZCBUAJ76p5mFCmH+ZOQ
Jd8bfBs2K7+B9WM/Op6tvZ90H9LoRg0=
=oy45
-----END PGP SIGNATURE-----
-------------- next part --------------
A non-text attachment was scrubbed...
Name: lists.vcf
Type: text/x-vcard
Size: 310 bytes
Desc: not available
URL: <http://lists.plone.org/pipermail/plone-product-developers/attachments/20120513/e3dfe06d/attachment.vcf>