emacs-orgmode@gnu.org archives
 help / color / mirror / code / Atom feed
From: jemarch@gnu.org (Jose E. Marchesi)
To: emacs-orgmode@gnu.org
Subject: Re: orgmode and a database
Date: Tue, 05 Apr 2016 19:03:20 +0200	[thread overview]
Message-ID: <87zit8vvhj.fsf@gnu.org> (raw)
In-Reply-To: <87zit8t3j4.fsf@mat.ucm.es> (Uwe Brauer's message of "Tue, 05 Apr 2016 16:37:51 +0000")

    
       > 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     |

  reply	other threads:[~2016-04-05 16:55 UTC|newest]

Thread overview: 24+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2016-04-04 19:46 orgmode and a database Uwe Brauer
2016-04-04 20:19 ` Ken Mankoff
2016-04-05 10:31   ` Uwe Brauer
2016-04-05 13:01     ` Russell Adams
2016-04-04 20:27 ` Charles Millar
2016-04-05 10:32   ` Uwe Brauer
2016-04-05 13:12     ` Jose E. Marchesi
2016-04-05 16:37       ` Uwe Brauer
2016-04-05 17:03         ` Jose E. Marchesi [this message]
2016-04-05 17:36           ` Uwe Brauer
2016-04-05 21:27           ` Uwe Brauer
2016-04-05 20:01     ` Charles Millar
2016-04-05 20:32   ` Charles Millar
2016-04-05 10:43 ` Colin Baxter
2016-04-05 11:41   ` Charles Millar
2016-04-05 13:04     ` Colin Baxter
2016-04-05 14:02       ` Charles Millar
2016-04-05 14:03       ` Eric S Fraga
2016-04-05 14:40         ` Jose E. Marchesi
2016-04-05 16:18           ` Eric S Fraga
2016-04-05 13:02   ` Jose E. Marchesi
2016-04-05 13:49     ` Colin Baxter
2016-04-05 13:49     ` Colin Baxter
2016-04-05 14:04       ` Jose E. Marchesi

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

  Avoid top-posting and favor interleaved quoting:
  https://en.wikipedia.org/wiki/Posting_style#Interleaved_style

  List information: https://www.orgmode.org/

* Reply using the --to, --cc, and --in-reply-to
  switches of git-send-email(1):

  git send-email \
    --in-reply-to=87zit8vvhj.fsf@gnu.org \
    --to=jemarch@gnu.org \
    --cc=emacs-orgmode@gnu.org \
    /path/to/YOUR_REPLY

  https://kernel.org/pub/software/scm/git/docs/git-send-email.html

* If your mail client supports setting the In-Reply-To header
  via mailto: links, try the mailto: link
Be sure your reply has a Subject: header at the top and a blank line before the message body. 
Code repositories for project(s) associated with this public inbox

	https://git.savannah.gnu.org/cgit/emacs/org-mode.git

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox;
as well as URLs for read-only IMAP folder(s) and NNTP newsgroup(s).