Re: lisp/org-clock.el: Add param :properties to list properties in clocktable

[Bernt Hansen <bernt@norang.ca>]

Niels Giesen <niels.giesen@gmail.com> writes:

> Bernt Hansen <bernt@norang.ca> writes:
>
> [...]
>
>> Could you provide a sample clock report using this patch to get a
>> better idea of why you find this useful?
>
> Yes, here you are, along with the contents of a sample file, so that you
> may get a gist of my need for inheritance.
>
> * Clocktables
>   #+BEGIN: clocktable :maxlevel 2 :scope file :properties ("Costcenter" "Billable") :inherit-props t
>   Clock summary at [2011-03-27 Sun 12:04]
>   
>   | Costcenter                        | Billable | Headline                        |   Time |      |
>   |-----------------------------------+----------+---------------------------------+--------+------|
>   |                                   |          | *Total time*                    | *3:08* |      |
>   |-----------------------------------+----------+---------------------------------+--------+------|
>   | A-102: General Administration     |          | TODO Travel cost declaration    |   0:42 |      |
>   | A-102: General Administration     |          | TODO December 2007-2009         |        | 0:37 |
>   | O-100: General overhead           |          | Making coffee for the lot of us |   0:06 |      |
>   | C-100: Customer relations general |          | Helpdesk                        |   1:10 |      |
>   | C-100: Customer relations general |          | Categorize our helpdesk e-mails |        | 0:20 |
>   | C-101: Customer A                 | [X]      | Help out customer a             |        | 0:10 |
>   | C-102: Customer B                 | [?]      | Help out customer b on issue x  |        | 0:20 |
>   | C-100: Customer relations general |          | Help out potential customer c   |        | 0:20 |
>   | W-100: Web Development            |          | Develop our main web app        |   1:10 |      |
>   | W-100: Web Development            |          | that                            |        | 0:41 |
>   | C-102: Customer B                 | [?]      | something only customer b wants |        | 0:29 |
>   #+END:
>
> Actually, my boss needs something more like the table below, which I
> can export to something that Outlook Times also spits out (some
> clocking plugin for MS Outlook that the rest of us uses, and I was
> supposed to use too, you may understand that that is just a silly idea
> for someone used to org-mode).
>
> Patches 1 and 3 allowed me to get this specific output using a custom
> formatter and a #+TBLFM: line, which I may post to Worg if people are
> interested.
>
> #+BEGIN: clocktable :formatter org-clocktable-write-outlook-times-style :maxlevel 2 :scope file :inherit-props t :properties ("Costcenter" "Billable") :date t :block day
> Clock summary at [2011-03-27 Sun 12:04], for Sunday, March 27, 2011.
>
> |       Date | Headline                                                  |   Time | Costcenter                        | Billable |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> |            | *Total time*                                              | *3.05* |                                   |          |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | TODO Travel cost declaration                              |   0.00 | A-102: General Administration     |          |
> | 27-03-2011 | TODO Travel cost declaration, TODO December 2007-2009     |   0.62 | A-102: General Administration     |          |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | Making coffee for the lot of us                           |   0.10 | O-100: General overhead           |          |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | Helpdesk                                                  |   0.00 | C-100: Customer relations general |          |
> | 27-03-2011 | Helpdesk, Categorize our helpdesk e-mails                 |   0.33 | C-100: Customer relations general |          |
> | 27-03-2011 | Helpdesk, Help out customer a                             |   0.17 | C-101: Customer A                 | [X]      |
> | 27-03-2011 | Helpdesk, Help out customer b on issue x                  |   0.33 | C-102: Customer B                 | [?]      |
> | 27-03-2011 | Helpdesk, Help out potential customer c                   |   0.33 | C-100: Customer relations general |          |
> |------------+-----------------------------------------------------------+--------+-----------------------------------+----------|
> | 27-03-2011 | Develop our main web app                                  |   0.00 | W-100: Web Development            |          |
> | 27-03-2011 | Develop our main web app, that                            |   0.68 | W-100: Web Development            |          |
> | 27-03-2011 | Develop our main web app, something only customer b wants |   0.48 | C-102: Customer B                 | [?]      |
> #+TBLFM: $2='(if (string= "$0" "@-I") "$0" (concat "@-I" ", " "$0"));L::$4='(if (string= "$0" "") "@-I" "$0");L
> #+END:
> * TODO Travel cost declaration
>   DEADLINE: <2011-04-01 vr .+1m>
>   - State "DONE"       from "TESTING"    [2011-02-01 di 10:02]
>   :LOGBOOK:
>   CLOCK: [2011-03-02 wo 09:17]--[2011-03-02 wo 09:22] =>  0:05
>   :END:
>   - State "DONE"       from "TESTING"    [2011-01-04 di 09:40]
>   :PROPERTIES:
>   :COSTCENTER: A-102: General Administration
>   :END:
> ** TODO December 2007-2009
>    :CLOCK:
>    CLOCK: [2011-03-27 Sun 09:28]--[2011-03-27 Sun 10:05] =>  0:37
>    :END:
>    Find out what were my costs during this hazy period of my life.

Hi Niels,

Thanks for the example.  That helps a lot.  I think posting this to Worg
would be very useful.

Thanks for sharing this!

Regards,
-- 
Bernt