Adam Tauno Williams | 5 Nov 17:56 2007

Task & kind

Project's have a "kind" field that can be used to designate special
types of projects.

Tasks also have a "kind" field, but tasks with a kind other than NULL
are always filtered out of todo/delegated lists.  It looks like this
"kind" field was used by some now obsolete features ("Root Process"?).
Would it be safe / acceptable now to 'liberate' this field [1]?  

It would be extremely useful to us to be able to designate a task type,
but currently if we set this value the task completely vanishes both in
the WebUI (which is OK, at least for us) and also via ZideStore /
XML-RPC [ obviously, since the kind IS NULL constraint is in Logic ].

[1] Advising people before upgrading to purge ((kind IS NOT NULL) OR
(is_control_job = 1)) detritus from their database).

Adam Tauno Williams | 5 Nov 17:57 2007

Re: Changes to trunk, Testing

On Tue, 2007-05-29 at 00:59 +0200, Helge Hess wrote:
> I've done a few changes to the way insert/update operations work.
> First of all primary key batches now work again, don't know how they  
> got lost (the SQL sequences reserves a batch of 10 keys per  
> invocation, so far we only used one of them resulting in wasted key  
> space ...).
> Next I changed the way object_version, last_modified, etc fields are  
> updated, and I added those to a few classes which didn't have them  
> before (eg docs, notes and projects).
> Finally I plan to enhance the database schema for 5.4. Mostly:
> - notes/documents attached to company records
> - parent_id in project table
> - a few other minor things
> If someone has wishes for additional fields, shout now ;-) This isn't  
> committed yet.

Any more thoughts / updates on these changes?
Helge Hess | 5 Nov 23:03 2007

Re: Changes to trunk, Testing

On 05.11.2007, at 17:57, Adam Tauno Williams wrote:
>> Next I changed the way object_version, last_modified, etc fields are
>> updated, and I added those to a few classes which didn't have them
>> before (eg docs, notes and projects).
>> Finally I plan to enhance the database schema for 5.4. Mostly:
>> - notes/documents attached to company records
>> - parent_id in project table
>> - a few other minor things
>> If someone has wishes for additional fields, shout now ;-) This isn't
>> committed yet.
> Any more thoughts / updates on these changes?

I have a few pending changes which I'm going to commit in Nov or so.

Greets,
   Helge

--

-- 
OpenGroupware.org Developer
developer@...
http://mail.opengroupware.org/mailman/listinfo/developer

Helge Hess | 5 Nov 23:02 2007

Re: Task & kind

On 05.11.2007, at 17:56, Adam Tauno Williams wrote:
> Project's have a "kind" field that can be used to designate special
> types of projects.
>
> Tasks also have a "kind" field, but tasks with a kind other than NULL
> are always filtered out of todo/delegated lists.  It looks like this
> "kind" field was used by some now obsolete features ("Root Process"?).
> Would it be safe / acceptable now to 'liberate' this field [1]?

Looking at the source it seems that the "kind IS NULL" constraint is  
embedded rather deeply. Not sure whether it would be dangerous to  
relax that ... And then, I'm not sure what we need 'kind' for.
[I don't remember what it was good for]

In a legacy DB I could find those:
=> SELECT DISTINCT(kind) FROM job;
        kind
-------------------
00_process
01_root_milestone
01_root_process
(4 rows)

So it seems to be related to the "milestone" stuff which I mostly  
removed.

> It would be extremely useful to us to be able to designate a task  
> type,
> but currently if we set this value the task completely vanishes  
> both in
(Continue reading)

Adam Tauno Williams | 6 Nov 00:05 2007

Re: Task & kind

> > Tasks also have a "kind" field, but tasks with a kind other than NULL
> > are always filtered out of todo/delegated lists.  It looks like this
> > "kind" field was used by some now obsolete features ("Root Process"?).
> > Would it be safe / acceptable now to 'liberate' this field [1]?
> Looking at the source it seems that the "kind IS NULL" constraint is  
> embedded rather deeply. Not sure whether it would be dangerous to  
> relax that ... And then, I'm not sure what we need 'kind' for.
> [I don't remember what it was good for]
> In a legacy DB I could find those:
> => SELECT DISTINCT(kind) FROM job;
>         kind
> -------------------
> 00_process
> 01_root_milestone
> 01_root_process
> (4 rows)
> So it seems to be related to the "milestone" stuff which I mostly  
> removed.

That is pretty much what I assumed.  Anyway,  I've plucked the
restriction out of at least the Logic bits, and so far.... by servers
are still chugging away.

I've tested the task lists in webui (todo, delegated, archived) and
listing the tasks vi the project viewer.
Adam Tauno Williams | 6 Nov 00:20 2007

Re: Task & kind

> > It would be extremely useful to us to be able to designate a task  
> > type,
> > but currently if we set this value the task completely vanishes  
> > both in
> > the WebUI (which is OK, at least for us) and also via ZideStore /
> > XML-RPC [ obviously, since the kind IS NULL constraint is in Logic ].
> Not sure what "kinds" you think of. Probably "keywords" is what we  
> want here? (and map that to iCal keywords?)

We've used the task list to provide the users with a unified task list;
now we've added specific types of tasks.  The intranet displays tasks
lists and the normal task information but it also looks at the kind of
the task and displays additional fields based on the kind,  those
additional fields are then stored in properties.   Intranet forms are
also used to drive the creation of different kinds of tasks, making sure
the creating user provides the necessary bits of information.

We aren't using 'kind' as a human-readable value which I would think
keywords should be.

--

-- 
OpenGroupware.org Developer
developer@...
http://mail.opengroupware.org/mailman/listinfo/developer

Helge Hess | 6 Nov 21:04 2007

Re: Task & kind

On 06.11.2007, at 00:05, Adam Tauno Williams wrote:
> That is pretty much what I assumed.  Anyway,  I've plucked the
> restriction out of at least the Logic bits, and so far.... by servers
> are still chugging away.
>
> I've tested the task lists in webui (todo, delegated, archived) and
> listing the tasks vi the project viewer.

OK, I don't mind if you remove it.

> We've used the task list to provide the users with a unified task  
> list;
> now we've added specific types of tasks.  The intranet displays tasks
> lists and the normal task information but it also looks at the kind of
> the task and displays additional fields based on the kind,  those
> additional fields are then stored in properties.   Intranet forms are
> also used to drive the creation of different kinds of tasks, making  
> sure
> the creating user provides the necessary bits of information.
>
> We aren't using 'kind' as a human-readable value which I would think
> keywords should be.

Ack.

Greets,
   Helge
--

-- 
Helge Hess
http://www.helgehess.eu/
(Continue reading)

Sebastian Reitenbach | 14 Nov 12:44 2007
Picon

bugfixes and enhancements for advanced document and contact/company searches

Hi,

I uploaded some patches a while ago to the bugzilla, one bug report, and two 
enhancements. 

The patch to this bug report would fix the save of AND/OR selector for
contacts and company searches:
http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1920

The patch to this enhancement request would allow to create custom
tabs for document searches within a project:
http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1919
everything is working here, but I have no idea how the custom tabs are 
filled with contents

The patch to this enhancement would allow to create custom tabs for 
document searches across projects:
http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1921
here everything is working.

The code may not be perfect, but if anybody could try these patches, and 
give some feedback, would be nice. Especially, I have no idea how to fix 
problem described for bug 1919. I spent hours to get contents into the 
tabs but noting worked so far.

kind regards
Sebastian

--

-- 
OpenGroupware.org Developer
(Continue reading)

Adam Tauno Williams | 14 Nov 14:53 2007

Re: bugfixes and enhancements for advanced document and contact/company searches

> I uploaded some patches a while ago to the bugzilla, one bug report, and two 
> enhancements. 
> The patch to this bug report would fix the save of AND/OR selector for
> contacts and company searches:
> http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1920
> The patch to this enhancement request would allow to create custom
> tabs for document searches within a project:
> http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1919
> everything is working here, but I have no idea how the custom tabs are 
> filled with contents
> The patch to this enhancement would allow to create custom tabs for 
> document searches across projects:
> http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1921
> here everything is working.

I'll take a look and test; although my knowledge is limited.

> The code may not be perfect, but if anybody could try these patches, and 
> give some feedback, would be nice. Especially, I have no idea how to fix 
> problem described for bug 1919. I spent hours to get contents into the 
> tabs but noting worked so far.

Hey, same boat.  I can't tell you how many hours I've spent trying to
get contents to appear in a ZideStore folder.  Ugh.

Adam Tauno Williams | 14 Nov 15:04 2007

Re: bugfixes and enhancements for advanced document and contact/company searches


On Wed, 2007-11-14 at 08:53 -0500, Adam Tauno Williams wrote:
> > I uploaded some patches a while ago to the bugzilla, one bug report, and two 
> > enhancements. 
> > The patch to this bug report would fix the save of AND/OR selector for
> > contacts and company searches:
> > http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1920
> > The patch to this enhancement request would allow to create custom
> > tabs for document searches within a project:
> > http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1919
> > everything is working here, but I have no idea how the custom tabs are 
> > filled with contents
> > The patch to this enhancement would allow to create custom tabs for 
> > document searches across projects:
> > http://bugzilla.opengroupware.org/bugzilla/show_bug.cgi?id=1921
> > here everything is working.
> I'll take a look and test; although my knowledge is limited.

As an aside,  if you could find the time to write up a short document
about developing in the webui - perhaps a short
how-to-add-a-hello-world-module - I'd love to include something like
that in WMOGAG,  either as an addendum or I'd work it into a new
chapter.  Something like a step-by-step explanation of the stuff at
http://www.opengroupware.org/en/devs/docs/snippets/WebUI/activation.html
Since you create the Asterisk stuff, you've obviously figured some of it
out. :)

> > The code may not be perfect, but if anybody could try these patches, and 
> > give some feedback, would be nice. Especially, I have no idea how to fix 
> > problem described for bug 1919. I spent hours to get contents into the 
(Continue reading)


Gmane