Well, do love, LOVE, filtering in TiddlyWiki. That, I think, comes from my love for SQL (in particular Oracle SQL), ever since being taught "relational algebra" at university many many many moons ago.
One would think I would be as passionate about APL, but I could not stand all of the glyphs (I have a hard time figuring out elevator open/close door buttons.) The beauty of filtering in TiddlyWiki, just like writing SQL, is the idea of transformations from start to finish: tweak tweak tweak tweak. Sometimes, the transformations are helped by adding more bulk. So much fun. BTW, I'm some glad you started this thread. I was not aware of that {tiddler!!field} beauty in filtering. Or saw it before and just did not clue in. That is good stuff. Thanks for showing that and your use case ! On Monday, September 13, 2021 at 10:49:15 PM UTC-3 0 0 wrote: > Thank you CJ, this solution indeed works as well! I enjoyed following > along step by step the construction of the final filter and feel that your > idea of "duplicating" each title at the beginning will be another useful > technique that I can utilize when needed. > 0 > tiistai 14. syyskuuta 2021 klo 3.47.40 UTC+3 cj.v...@gmail.com kirjoitti: > >> Arg. Please ignore the macro "theCount". That was part of an initial >> plan that I tossed aside. >> >> On Monday, September 13, 2021 at 9:44:38 PM UTC-3 Charlie Veniot wrote: >> >>> Oh yeah, forgot to attach sample related tiddlers in case anybody wants >>> to dive into that and play. >>> >>> >>> >>> On Monday, September 13, 2021 at 9:40:32 PM UTC-3 Charlie Veniot wrote: >>> >>>> Although I figure most folk will understand Eric's nice solution, I'll >>>> throw mine here anyway, for the giggles. >>>> >>>> If anything, you'll see clues that this old sponge of mine operates >>>> pretty much way out in left field, or the far side ... >>>> >>>> Assuming that the negative sign is included with the number in every >>>> frequency field ... >>>> >>>> What we have here, folks, is a dynamically created filter, which >>>> totally gets my geek mojo going: >>>> >>>> \define bL2() [[ >>>> \define midPart() ]!days:last-contact{ >>>> \define lastPart() !!frequency}] >>>> \define theCount() +[count[] >>>> >>>> ! The result >>>> >>>> <$vars thisFilter={{{ [has[frequency]sort[]addsuffix[::]] >>>> [has[frequency]sort[]addsuffix[,]] +[sort[]] +[join[]] +[split[::]] >>>> +[butlast[]] +[addprefix<bL2>] +[search-replace[,],<midPart>] >>>> +[addsuffix<lastPart>] +[join[ ]] }}}> >>>> >>>> Count of items: <$count filter=<<thisFilter>>/> >>>> >>>> <$list filter=<<thisFilter>>> >>>> >>>> </$list> >>>> >>>> </$vars> >>>> >>>>> >>>>>> -- You received this message because you are subscribed to the Google Groups "TiddlyWiki" group. To unsubscribe from this group and stop receiving emails from it, send an email to tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/ffe55d36-3194-4d9b-a7cb-53df09cbf0f9n%40googlegroups.com.