| 3 Jun 2024 |
 .paul1st | Hey all, i have a qustion about display advanced queries result. my query like below, i want it display like a table, but it is not.
{
:title "On/Developing"
:query [
:find (pull ?b [*])
:where
[?b :block/content ?content]
[?b :block/properties ?props]
[(get ?props :novelty) ?novelty]
[(get ?props :category) ?category]
]
:result-transform (fn [result]
(map (fn [{:keys [block/properties block/page block/content]}]
{
:block (subs content 0 50) ;; Display the first 50 characters of the block content
:page (get-in block [:block/page :db/id]) ;; Get page id
:novelty (get properties :novelty) ;; Display the novelty property
:category (get properties :category) ;; Display the category property
}) result))
:table-view [:block :page :novelty :category]
} | 08:52:15 |
 autokludge | .stvnsmth [for reference](https://docs.logseq.com/#/page/advanced%20queries). your input area had too much wrapping going on around values | 08:52:23 |
|  argo_navis joined the room. | 09:18:00 |
 Tim | Hello together
Can anyone help me create a query in Logseq?
I would like to get a list of all tasks I have worked on in the last 7 days (alternatively: last week). But only tasks with tracked times. Unfortunately, I'm not (yet) very familiar with it...
I have already tried ChatGPT, but unfortunately nothing useful came out :)
Thank you very much
Tim | 12:43:37 |
| Tim | * Hello together
Can anyone help me create a query in Logseq?
I would like to get a list of all tasks I have worked on in the last 7 days (alternatively: last week). But only tasks with recorded times and from everywhere (pages, journal). Unfortunately, I'm not (yet) very familiar with it...
I have already tried ChatGPT, but unfortunately nothing useful came out :)
Thank you very much
Tim | 12:48:39 |
|  faaafu joined the room. | 15:45:18 |
| 7 Jun 2024 |
|  johnstone joined the room. | 03:30:29 |
|  @marvindewald:matrix.org joined the room. | 09:28:03 |
| @marvindewald:matrix.org left the room. | 10:20:16 |
| 15 Jun 2024 |
|  martin-f joined the room. | 15:41:27 |
| 16 Jun 2024 |
|  Me set a profile picture. | 16:24:50 |
| Me removed their profile picture. | 16:25:14 |
| Me changed their display name from me to Ypu. | 16:25:40 |
| Me changed their display name from Ypu to Me. | 16:26:07 |
| 17 Jun 2024 |
|  @memefi:matrix.org joined the room. | 22:00:53 |
| 19 Jun 2024 |
| @memefi:matrix.org | 05:26:12 |
| 22 Jun 2024 |
|  @tommyzjones_20:matrix.org joined the room. | 16:48:51 |
|  iath banned @tommyzjones_20:matrix.org (spam). | 16:48:54 |
|  @tsc67:matrix.org joined the room. | 18:32:45 |
| 25 Jun 2024 |
| @tsc67:matrix.org left the room. | 16:45:28 |
|  buerobert joined the room. | 18:32:00 |
| 30 Jun 2024 |
| @memefi:matrix.org | 21:43:22 |
| iath banned @memefi:matrix.org (spam). | 22:15:34 |
| 1 Jul 2024 |
|  @s4kun4:matrix.org joined the room. | 20:26:38 |
| 2 Jul 2024 |
| @s4kun4:matrix.org left the room. | 07:04:49 |
|  Jhon Honce joined the room. | 16:30:07 |
| 11 Jul 2024 |
|  @66tzw5hbhr:matrix.org joined the room. | 22:00:52 |
| @66tzw5hbhr:matrix.org left the room. | 22:01:11 |
| 23 Jul 2024 |
|  djprogen joined the room. | 03:14:10 |
|  sandeep.sagar joined the room. | 09:29:59 |
