Sort by custom property

Questions & Help Queries
1

Hello,
I want to follow a gamified approach for task management. For that I assign my tasks the property xp:: with a number.
Next I created a query that gives me all the tasks that are finished. That also worked well so far, even though I still don’t fully understand the clojure-stuff.
However what I did not get to work was sorting queried tasks by xp. The following query is the best I’ve got so far and seems to be in line with the answer to this post I found, but it does not sort the results by xp:: property.

#+BEGIN_QUERY
{
:title ["tasks"]
:query [
:find (pull ?b [*])
:where
[?b :block/marker ?marker]
[(contains? #{"TODO", "DOING"} ?marker)]
[?b :block/properties ?props]
[(get ?props :xp) ?xp]]
}
:result-transform (fn [result]
        (sort-by (fn [h]
                (get-in h [:block/properties :xp])) result))
#+END_QUERY

This yields query results like so:

grafik
grafik388×370 19.7 KB

which are not ordered.

I am mainly from a c++ background so it immensely confuses me that in :result-transform suddenly result and h pop up. Also the data flow is not clear to me and what those variables actually represent.

Any help is appreciated, thanks a lot in advance !

1 Like
2
  • Currently :result-transform is simply ignored.
    • Move it inside the curly braces { } , so as to apply.
  • :result-transform applies after :query and before rendering.
    • result and h are function parameters, so they can be renamed to anything.
      • result holds the full array-like output of the query, before it gets rendered.
      • h iterates each one item of that array.
      • sort-by returns a new array, but with its items sorted.
4 Likes
3

It was really that simple, I did not notice that the result-transform was outside the curly braces. Thanks for the clarification of how the result-transform actually operates. Query works now.

1 Like