From mboxrd@z Thu Jan 1 00:00:00 1970 From: jemarch@gnu.org (Jose E. Marchesi) Subject: Re: orgmode and a database Date: Tue, 05 Apr 2016 19:03:20 +0200 Message-ID: <87zit8vvhj.fsf@gnu.org> References: <87shz1f97s.fsf@mat.ucm.es> <5702CE16.8020704@verizon.net> <871t6kl50k.fsf@mat.ucm.es> <87r3ek8aj7.fsf@gnu.org> <87zit8t3j4.fsf@mat.ucm.es> Mime-Version: 1.0 Content-Type: text/plain Return-path: Received: from eggs.gnu.org ([2001:4830:134:3::10]:51210) by lists.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1anUGH-0006uw-An for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:55:30 -0400 Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71) (envelope-from ) id 1anUGD-0005jk-SF for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:55:29 -0400 Received: from fencepost.gnu.org ([2001:4830:134:3::e]:52237) by eggs.gnu.org with esmtp (Exim 4.71) (envelope-from ) id 1anUGD-0005ja-P7 for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:55:25 -0400 Received: from ukc1-proxy-mwg03-o.oracle.com ([141.143.212.228]:42391 helo=termi.gnu.org) by fencepost.gnu.org with esmtpsa (TLS1.2:DHE_RSA_AES_128_CBC_SHA1:128) (Exim 4.82) (envelope-from ) id 1anUGD-0003tC-0j for emacs-orgmode@gnu.org; Tue, 05 Apr 2016 12:55:25 -0400 In-Reply-To: <87zit8t3j4.fsf@mat.ucm.es> (Uwe Brauer's message of "Tue, 05 Apr 2016 16:37:51 +0000") 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: emacs-orgmode@gnu.org > 1) Using ob-rec.el (part of recutils) > #+begin_src rec :data mydata.rec :type milestone :fields ProjectID,Name > Year == 2014 > #+end_src Thanks. Could you please send me the mydate file otherwise that will not work (and I don't know enough recfiles syntax to cook up my own. Sure. This could be an example of a recfile: -- mydata.rec -- %rec: milestone ProjectID: 1 Name: GNU Recutils Year: 2012 ProjectID: 2 Name: Another Year: 2014 ProjectID: 3 Name: GNU Emacs Year: 1985 ProjectID: 4 Name: Foo Year: 2014 -- end of mydata.rec -- Evaluating this block from an org file (note the 's around 2014 that I forgot to use in the example above): #+begin_src rec :data mydata.rec :type milestone :fields ProjectID,Name Year == '2014' #+end_src It produces: #+RESULTS: | ProjectID | Name | |-----------+---------| | 2 | Another | | 4 | Foo |