From mboxrd@z Thu Jan 1 00:00:00 1970 From: Alexander Baier Subject: Re: how to group together fields Date: Sat, 01 Feb 2014 13:33:25 +0100 Message-ID: <87wqhf9fmy.fsf@gmail.com> References: <87fvo5tqvo.fsf@mars.lan> <87fvo4bcjw.fsf@gmail.com> <87r47nshuh.fsf@mars.lan> <87bnyrayda.fsf@gmail.com> <87ioszrr6l.fsf@mars.lan> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:40894) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1W9Zlo-0002gC-Uu for emacs-orgmode@gnu.org; Sat, 01 Feb 2014 07:34:09 -0500 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1W9Zlg-0002yQ-H9 for emacs-orgmode@gnu.org; Sat, 01 Feb 2014 07:34:00 -0500 Received: from mail-qa0-x236.google.com ([2607:f8b0:400d:c00::236]:55344) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1W9Zlg-0002yM-Cp for emacs-orgmode@gnu.org; Sat, 01 Feb 2014 07:33:52 -0500 Received: by mail-qa0-f54.google.com with SMTP id i13so7778393qae.27 for ; Sat, 01 Feb 2014 04:33:51 -0800 (PST) In-Reply-To: <87ioszrr6l.fsf@mars.lan> (Stefan Huchler's message of "Sat, 01 Feb 2014 12:46:42 +0100") List-Id: "General discussions about Org-mode." List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org Sender: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org To: Stefan Huchler Cc: emacs-orgmode@gnu.org Hello Stefan, I say it again: _Please_ Cc the org-mode mailing list, when replying, so everyone can read our correspondence. On 2014-02-01 12:46 Stefan Huchler wrote: > sry I maybe miss readed you. I have no problem in a different > structure. If you could "join" 2 different org trees by linking in the > data or something, like a tee table and a vendor table but have no > redundant data, I would be ok. clearly my way would be even better but > I would be ok with a other structure. Linking to another org-header is possible, but you cannot use this to feed information to the aggregate functions of Column View. Regarding normal tables, I have no idea. > This tree is not fixed, its only a demonstration what I want to do. I > want to manage data somehow that is not redundant where I can type in > data once and get this 2 tables when I need them generated. > > And if possible it should not be that I every time I want to use > something similar I have to write a big special function for it. One could try write it general enough to be applicable to similar situations I think. > I am not shure If I do always the most obious only good way (as a > pythoneer would say ^^) to reach my goal. > > But in general in my oppinion emacs is not only a editor not only a operation system > (package manager...) but also a office suite ( authoring, spreadsheet ) > so why not have a somewhat full personal database system. > > The alternative would be for me to use for such small things sqlite and > write some code for representation and sql statements. > > so the effort to do this and the big problems with backups with real > databases would be enorm. > > Sorry hope that sounds not like whinig, but I saw 2 days ago a > presentation (video) from one of or the author from org-mode, and he > said that some people use it as database. So a database should be able > to do such basic operation like group by in my oppinion. And you can > express the logik like I did, its only a question if the org-columns > function can use it. I think a lot of people either use it as a more or less flat listing (with the structure beeing strongly influenced by the aggregate functions they want to run over it) or they write a bunch of elisp to help them extract information. > maybe I have to hack it myself even if I wrote 10 lines of lisp in my > live ;) Maybe Bastien (author of Column View I think) can say something to this, with regard to supplying custom elisp as an aggregate function. Regards, -- Alexander Baier