[Fwd: Re: CAP-12-a: Stored queries still?]

(I accidentally sent this to Bruce - I meant to send it to the list)


[email protected] wrote:
> 
> We never reached a clear concensus on the issue of stored queries in 
> CAP.  The thread just stopped in mid-January 2003 and I still question 
> the usefulness of them in CAP.

Is what Bruce means, it it does not end until he agrees. There was
a debate - two of them over the last two years.

> As a refresher for those that may not recall that thread or are new:
> 
> CAP has the ability to store and refer to 'named' queries in the 
> protocol.  However, since there is no ability to wildcard any values in 
> the query ....

Which is irrelevant as there ARE queries that can be saved
without wild cards. No place in CAP does it say that
you must be able to do stored queries based on time or wild cards.


Such as these examples:

	QUERYID:Common
	SELECT VEVENT FROM VEGANDA WHERE STATE() = "UNPROCESSED"
	SELECT VTODO FROM VEGANDA WHERE STATE() = "UNPROCESSED"

	QUERYID:STUFF
	SELECT VEVENT FROM VAGENDA WHERE STATE() = "DELETED"
	SELECT VTODO FROM VAGENDA WHERE STATE() = "DELETED"

	QUERYID:Everything
	SELECT VEVENT FROM VEGANDA WHERE STATE() = "UNPROCESSED"
	SELECT VTODO FROM VEGANDA WHERE STATE() = "UNPROCESSED"
	SELECT VHOURNAL FROM VEGANDA WHERE STATE() = "UNPROCESSED"
	SELECT X-MY-COMP FROM VEGANDA WHERE STATE() = "UNPROCESSED"

	QUERYID:MY RIGHTS
	SELECT VCAR FROM VAGENDA WHERE SELF() IN DENY
	SELECT VCAR FROM VAGENDA WHERE SELF() IN GRANT

	QUERYID:MY CALS
	SELECT CARID FROM VCALSTORE WHERE SELF() in OWNER

	.
	.
	.


-- 

   Doug Royer                     |   http://INET-Consulting.com
   -------------------------------|-----------------------------
   [email protected]                 | Office: (208)612-INET
   http://Royer.com/People/Doug   |    Fax: (866)594-8574
                                  |   Cell: (208)520-4044

                  We Do Standards - You Need Standards

-- 

  Doug Royer                     |   http://INET-Consulting.com
  -------------------------------|-----------------------------
  [email protected]                 | Office: (208)612-INET
  http://Royer.com/People/Doug   |    Fax: (866)594-8574
                                 |   Cell: (208)520-4044

                 We Do Standards - You Need Standards