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 [email protected] 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 [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/tiddlywiki/ffe55d36-3194-4d9b-a7cb-53df09cbf0f9n%40googlegroups.com.
