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 attachedHere 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 solutionExtra 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 shortSo 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
* 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:
OpenPGP_0x9D64597C3A982DCA.asc
Description: OpenPGP public key
OpenPGP_signature.asc
Description: OpenPGP digital signature
