From mboxrd@z Thu Jan  1 00:00:00 1970
From: Bernt Hansen <bernt@norang.ca>
Subject: Re: Org mode as an helper tool for my job position (DBA)
Date: Mon, 17 Mar 2008 08:54:27 -0400
Message-ID: <871w69cxz0.fsf@gollum.intra.norang.ca>
References: <loom.20080315T093543-641@post.gmane.org>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from mailman by lists.gnu.org with tmda-scanned (Exim 4.43)
	id 1JbErM-0002RI-MS
	for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:54:36 -0400
Received: from exim by lists.gnu.org with spam-scanned (Exim 4.43)
	id 1JbErM-0002Qe-3j
	for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:54:36 -0400
Received: from [199.232.76.173] (helo=monty-python.gnu.org)
	by lists.gnu.org with esmtp (Exim 4.43) id 1JbErM-0002QV-1F
	for emacs-orgmode@gnu.org; Mon, 17 Mar 2008 08:54:36 -0400
In-Reply-To: <loom.20080315T093543-641@post.gmane.org> (Xavier Maillard's
	message of "Sat\, 15 Mar 2008 09\:49\:30 +0000 \(UTC\)")
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <http://lists.gnu.org/pipermail/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <http://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
	<mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
To: Xavier Maillard <xma@gnu.org>
Cc: emacs-orgmode@gnu.org

Xavier Maillard <xma@gnu.org> writes:

> Hi,
>

Hi!

> Producing the right org-mode file structure from any script/c code is rather
> simple, in fact, I have done this as a quick and dirty hack for one tool.
>
> Where I am failing is in having a column view of the document (I want to be able
> to only view time spent for each object name to measure the performance of the
> last update statistics run).
>
> What would I need to add for each of the table/index "todo" entry to have this
> information at hand ?
>
> As an example, updating index statistics will present an org file like this one:
>
> #title Update statistics of sql server
>
> * General information
> - start date
> - end date
> - return code
>
> * Index statistics (I want column view from here for each object name)
> ** Index name 1
> informations for index name 1 go here (time spent, etc...)
> ** Index name 2
> * Index name <n>
> ...
>

Here's a sample org file.  Just add properties to the tasks (objects)
you need in the column view and a #+COLUMNS: line describing what fields
to include in the columns.

,----[ Sample org file ]
| #+STARTUP:
| #+COLUMNS: %40ITEM(Task) %30Status(Status) %30TimeSpent(Time Spent){:}
| * General information
| - start date
| - end date
| - return code
| 
| * Index statistics (I want column view from here for each object name)
| ** Index name 1
| informations for index name 1 go here (time spent, etc...)
| :PROPERTIES:
| :TimeSpent: 00:30
| :Status: S42
| :END:
| ** Index name 2
| :PROPERTIES:
| :TimeSpent: 00:17
| :Status: R19
| :END:
| * Index name <n>
| :PROPERTIES:
| :TimeSpent: 02:16
| :Status: 42
| :END:
`----

Hope that helps,

Bernt