Re: Evaluation

Dirk H Bartley <[email protected]> Sat, 16 May 2009 10:46:07 -0400
Newsgroups gmane.comp.cms.opengroupware.user
Message-ID <[email protected]>
> > Yes, as I said, the ZideStore is too old. It had quite a set of 
> 
> I believe his version has the GroupDAVv2 fixes from r2207.
> 
> The contents of the public/Contacts folder is initially derived from the
> query -
> SELECT c1.company_id AS pkey, c1.name AS sn, c1.firstname AS givenname,
> c1.object_version AS version
> FROM company c1
> WHERE c1.is_person=1
> AND (c1.is_account=0 OR c1.is_account IS NULL)
> AND (c1.is_private=0 OR c1.is_private IS NULL);
> [pg. 62 of the current WMOGAG, the "Folder Hierarchy" section covers how
> each folder in ZideStore is derived from the database.]
> 
> I assume that 10121 is presented by this query?
OGo=# SELECT c1.company_id AS pkey, c1.name AS sn, c1.firstname AS
givenname,
OGo-# c1.object_version AS version
OGo-# FROM company c1
OGo-# WHERE c1.is_person=1
OGo-# AND (c1.is_account=0 OR c1.is_account IS NULL)
OGo-# AND (c1.is_private=0 OR c1.is_private IS NULL);
 pkey  |      sn      | givenname | version 
-------+--------------+-----------+---------
 10121 | Dirk Bartley | Dirk      |       2
 36560 | Berner       | Sean      |       1
 36573 | Bosnjak      | Jill      |       2
 36586 | Pennington   | Joe       |       2
 36643 | Carlson      | John      |       1
(5 rows)

The contact in question is me.


Dirk


-- 
OpenGroupware.org Users
[email protected]
http://mail.opengroupware.org/mailman/listinfo/users