From mboxrd@z Thu Jan  1 00:00:00 1970
From: Adam Porter <adam@alphapapa.net>
Subject: Re: ANN: org-ql agenda block support
Date: Fri, 30 Aug 2019 05:44:45 -0500
Message-ID: <87o907kk4i.fsf@alphapapa.net>
References: <87ftmb7l27.fsf@alphapapa.net> <875zml5enu.fsf@zamazal.org>
 <CAJcAo8u-Sr9rOuqDThBga+97wT6EG2XcJmZbxSdEeGYwqXSuSw@mail.gmail.com>
Mime-Version: 1.0
Content-Type: text/plain
Return-path: <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
Received: from eggs.gnu.org ([2001:470:142:3::10]:34411)
 by lists.gnu.org with esmtp (Exim 4.90_1)
 (envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1i3eOx-00085P-A3
 for emacs-orgmode@gnu.org; Fri, 30 Aug 2019 06:45:09 -0400
Received: from Debian-exim by eggs.gnu.org with spam-scanned (Exim 4.71)
 (envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1i3eOs-0003N1-WB
 for emacs-orgmode@gnu.org; Fri, 30 Aug 2019 06:45:05 -0400
Received: from 195-159-176-226.customer.powertech.no ([195.159.176.226]:42624
 helo=blaine.gmane.org)
 by eggs.gnu.org with esmtps (TLS1.0:RSA_AES_256_CBC_SHA1:32)
 (Exim 4.71) (envelope-from <geo-emacs-orgmode@m.gmane.org>)
 id 1i3eOs-00036d-Jt
 for emacs-orgmode@gnu.org; Fri, 30 Aug 2019 06:45:02 -0400
Received: from list by blaine.gmane.org with local (Exim 4.89)
 (envelope-from <geo-emacs-orgmode@m.gmane.org>) id 1i3eOo-0012uK-2t
 for emacs-orgmode@gnu.org; Fri, 30 Aug 2019 12:44:58 +0200
List-Id: "General discussions about Org-mode." <emacs-orgmode.gnu.org>
List-Unsubscribe: <https://lists.gnu.org/mailman/options/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=unsubscribe>
List-Archive: <https://lists.gnu.org/archive/html/emacs-orgmode>
List-Post: <mailto:emacs-orgmode@gnu.org>
List-Help: <mailto:emacs-orgmode-request@gnu.org?subject=help>
List-Subscribe: <https://lists.gnu.org/mailman/listinfo/emacs-orgmode>,
 <mailto:emacs-orgmode-request@gnu.org?subject=subscribe>
Errors-To: emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org
Sender: "Emacs-orgmode"
 <emacs-orgmode-bounces+geo-emacs-orgmode=m.gmane.org@gnu.org>
To: emacs-orgmode@gnu.org

Samuel Wales <samologist@gmail.com> writes:

> i have been watching these developments with interest.  i want a
> faster 2-day agenda, and really like the idea of a lisp syntax for
> querying, perhaps one that can combine text search with structured.
>
> so just so it's known that there is otherwise silent interest.
> limited in computer use so cannot switch but following.

I appreciate the feedback nonetheless.

A two-day agenda could be done something like this:

    (org-ql-agenda (org-agenda-files)
      (and (or (deadline :from today :to +1)
               (scheduled :from today :to +1)
               (ts-active :from today :to +1))
           (not (done)))
      :sort (date priority todo)
      :super-groups ((:auto-planning t)))

To show deadlined entries taking org-deadline-warning-days into account,
more like the traditional Org Agenda, use (deadline auto), like:

    (org-ql-agenda (org-agenda-files)
      (and (or (deadline auto)
               (scheduled :from today :to +1)
               (ts-active :from today :to +1))
           (not (done)))
      :sort (date priority todo)
      :super-groups ((:auto-planning t)))

Grouping by date in this example is done with the org-super-agenda
:auto-planning selector, which uses the earliest planning timestamp in
an entry.  So it's not exactly like Org Agenda, but it approximates what
you're asking for, and org-ql's built-in caching may provide a speedup
for subsequent calls.

Here's an example that's similar to the Org Agenda's Log Mode:

    (org-ql-agenda
      (or (and (not (done))
               (or (habit)
                   (deadline auto)
                   (scheduled :to today)
                   (ts-active :on today)))
          (closed :on today))
      :sort (date priority todo))