Re: help: howto aggregate several properties in one column

[Pedro <pinmacs@cas.cat>]

[-- Attachment #1.1.1: Type: text/plain, Size: 6442 bytes --]

Thank you Thierry!

Even better, just initializing it the empty properties with an empty 
string works great and then I don't need the valof macro.

I updated the aggregate-props.org file and find it attached

Here is the result I am getting with just ~(progn(setq TEST_A "") (setq 
TEST_B ""))~

#+BEGIN: propview :scope tree :match "+test" :noquote all :cols (ITEM 
CREATED TEST_A TEST_B (concat TEST_A TEST_B) (concat TEST_C TEST_D))
| ITEM    | CREATED                | TEST_A | TEST_B | (concat TEST_A 
TEST_B) | (concat TEST_C TEST_D) |
|---------+------------------------+--------+--------+------------------------+------------------------|
| mytest  | [2024-08-09 Fri 23:53] | a      |        | 
a                      | cd                     |
| mytest2 | [2024-08-09 Fri 23:53] |        | b      | 
b                      | cd                     |
| mytest3 | [2024-08-09 Fri 23:53] |        | |                        | 
0                      |
|---------+------------------------+--------+--------+------------------------+------------------------|
|         |                        |        | |                        
|                        |
#+END:

Oooh, I am so happy, thank you again!

Cheers,
Pedro

On 2024-08-11 22:27, tbanelwebmin wrote:
> Two quick-and-dirty workarounds:
>
> 1. Eval that prior to using propview:
>
> (setq
>  TEST_A "<>"
>  TEST_B "<>"
>  TEST_C "<>"
>  TEST_D "<>")
>
> 2. Define this helper macro:
>
> (defmacro valof (symbol)
>   `(if (boundp ',symbol)
>       ,symbol
>     "()"))
>
> Then specify columns like that:
>
> (concat (valof TEST_A) (valof TEST_B))
>
>
> Have fun
> Thierry
>
>
> On 24-08-11 10:49, Pedro wrote:
>> Hi,
>>
>> I am a heavy user of propview [1] and I am very happy with it, but 
>> looks like now I reached a limitation, or maybe someone founds a 
>> magical workaround. I am open to use another solution outside of 
>> propview.
>>
>> Find attached in file aggregate-props.org that serves as a playground 
>> environment and as an example of what I am struggling with, it is 
>> posed as a generic example: I want to "merge" two properties into 
>> one, no matter if the property exists or no. I am trying to use 
>> concat, concat works only when the properties on an item exist, if 
>> one of them does not exist, fails, which is unfortunate to what I am 
>> trying to achieve, because on one side, I would like to report (with 
>> a propview table) the frequency of appearance of each test_a, test_b, 
>> test_c, etc. on all nodes with tag :test:, and with another propview 
>> table, a summary of all test properties.
>>
>> There is a workaround based on a precalculation strategy that I kind 
>> of hate: do an org-map-entries of all targeted items with tag "test", 
>> and update SUMMARY property through an adhoc elisp function all the 
>> properties related to test (I am happy with just enumerating all of 
>> the involved subproperties, but I recognize, having a regex on 
>> property such as test_* or that "starts with" test, would be 
>> amazing), then, it is just as easy as adding the new column SUMMARY, 
>> but I would like to avoid this solution
>>
>> Extra note: related to propview, it is not a problem to concat 100 
>> elements, because you can do it in an extra shortnamed function, so 
>> the column name can be short
>>
>> So this is what happens, concat of TEST_A and TEST_B is 0
>>
>> #+BEGIN: propview :scope tree :match "+test" :noquote all :cols (ITEM 
>> CREATED TEST_A TEST_B (concat TEST_A TEST_B) (concat TEST_C TEST_D))
>> | ITEM    | CREATED                | TEST_A | TEST_B | (concat TEST_A 
>> TEST_B) | (concat TEST_C TEST_D) |
>> |---------+------------------------+--------+--------+------------------------+------------------------| 
>>
>> | mytest  | [2024-08-09 Fri 23:53] |      a |      0 
>> |                      0 | cd                     |
>> | mytest2 | [2024-08-09 Fri 23:53] |      0 |      b 
>> |                      0 | cd                     |
>> | mytest3 | [2024-08-09 Fri 23:53] |      0 |      0 
>> |                      0 | 0                      |
>> |---------+------------------------+--------+--------+------------------------+------------------------| 
>>
>> |         |                        |        | 
>> |                        |                        |
>> #+END:
>>
>> What I would expect to happen is that in the concat result of TEST_A 
>> and TEST_B would appear a or b, maybe that could be done with another 
>> function?
>>
>> #+BEGIN: propview :scope tree :match "+test" :noquote all :cols (ITEM 
>> CREATED TEST_A TEST_B (concat TEST_A TEST_B) (concat TEST_C TEST_D))
>> | ITEM    | CREATED                | TEST_A | TEST_B | (concat TEST_A 
>> TEST_B) | (concat TEST_C TEST_D) |
>> |---------+------------------------+--------+--------+------------------------+------------------------| 
>>
>> | mytest  | [2024-08-09 Fri 23:53] |      a |      0 
>> |                      a | cd                     |
>> | mytest2 | [2024-08-09 Fri 23:53] |      0 |      b 
>> |                      b | cd                     |
>> | mytest3 | [2024-08-09 Fri 23:53] |      0 |      0 
>> |                      0 | 0                      |
>> |---------+------------------------+--------+--------+------------------------+------------------------| 
>>
>> |         |                        |        | 
>> |                        |                        |
>> #+END:
>>
>> Cheers,
>> pedeb
>>
>> [1] https://orgmode.org/worg/org-contrib/org-collector.html
>>
>
>


[-- Attachment #1.1.2: aggregate-props.org --]
[-- Type: text/org, Size: 1787 bytes --]

* my test
:PROPERTIES:
:CREATED:  [2024-08-10 Sat 13:48]
:END:

#+name: sourceblock_created_2024-08-12_10-36-52
#+begin_src emacs-lisp
;; eval this before executing propview
;;   so that aggregating columns with concat works
(setq TEST_A "")
(setq TEST_B "")
#+end_src

#+RESULTS: sourceblock_created_2024-08-12_10-36-52

#+BEGIN: propview :scope tree :match "+test" :noquote all :cols (ITEM CREATED TEST_A TEST_B (concat TEST_A TEST_B) (concat TEST_C TEST_D))
| ITEM    | CREATED                | TEST_A | TEST_B | (concat TEST_A TEST_B) | (concat TEST_C TEST_D) |
|---------+------------------------+--------+--------+------------------------+------------------------|
| mytest  | [2024-08-09 Fri 23:53] | a      |        | a                      | cd                     |
| mytest2 | [2024-08-09 Fri 23:53] |        | b      | b                      | cd                     |
| mytest3 | [2024-08-09 Fri 23:53] |        |        |                        | 0                      |
|---------+------------------------+--------+--------+------------------------+------------------------|
|         |                        |        |        |                        |                        |
#+END:

** mytest                                                                      :test:
:PROPERTIES:
:CREATED:  [2024-08-09 Fri 23:53]
:CUSTOM_ID: board_157
:test_a:    a
:test_c:    c
:test_d:    d
:END:

** mytest2                                                                     :test:
:PROPERTIES:
:CREATED:  [2024-08-09 Fri 23:53]
:CUSTOM_ID: board_158
:test_b:    b
:test_c:    c
:test_d:    d
:END:

** mytest3                                                                     :test:
:PROPERTIES:
:CREATED:  [2024-08-09 Fri 23:53]
:CUSTOM_ID: board_158
:test_c:    c
:END:

[-- Attachment #1.1.3: OpenPGP public key --]
[-- Type: application/pgp-keys, Size: 3323 bytes --]

[-- Attachment #2: OpenPGP digital signature --]
[-- Type: application/pgp-signature, Size: 495 bytes --]