BTW, currently only works with tags that have no spaces in them. On Friday, November 25, 2022 at 11:15:46 AM UTC-4 Charlie Veniot wrote:
> The "code" in the macro is not pretty to look at. I don't do pretty code > until I've got proof of concept working. > > Proof of concept works (I think, proof in the pudding), so now I can > consider making pretty code. > > If you want to play with the working "select * from *tag*" (a *tag* is a > virtual, distributed, and dynamic *table*), download the attached and > drag into whatever TiddlyWiki instance (TiddlyWiki.com !) > > Two tiddlers: > > - *SQL Macros* > - *select * from Examples* > > > > > On Friday, November 25, 2022 at 11:09:55 AM UTC-4 Charlie Veniot wrote: > >> It would be some nice if a search of "duplicates" in tiddlywiki.com's >> documentation lead to the "de-duplication" line in the "Filter Expressions" >> tiddler. >> >> Better if it lead to a tiddler that discussed the broader topic of >> allowing/disallowing duplicates, with info about the de-duplication filter >> run prefix and the unique operator. All very good and related stuff. >> >> Anyway, that last bug was related to uniqueness being automagically >> applied, and having to add a "=" prefix to eliminate de-duplication. >> >> >> >> On Friday, November 25, 2022 at 10:49:48 AM UTC-4 Charlie Veniot wrote: >> >>> Oops, still have a bug in there. On it. >>> >>> On Friday, November 25, 2022 at 10:39:46 AM UTC-4 Charlie Veniot wrote: >>> >>>> Okay, "nulls" handled, for this sample query, anyhoo. >>>> >>>> Must test with different "tables" (in what I'm doing, I'm using tags as >>>> the way to define virtual tables; a bit different, yet oh-so-cool, from >>>> dbms': the tables are dynamic in regards to columns, as the columns are >>>> whatever existing fields in tiddlers that have the tag.) >>>> >>>> New version of PDF attached. >>>> >>>> On Friday, November 25, 2022 at 12:44:42 AM UTC-4 Charlie Veniot wrote: >>>> >>>>> Arg! You are absolutely right. I skipped handling empty fields. >>>>> >>>>> I had imposed on myself a hard 10:30 PM cutoff time on that first >>>>> crack at it, and had not gotten around to validating the result set. >>>>> >>>>> First thing to fix when I get back at it tomorrow. >>>>> >>>>> Thanks ! >>>>> >>>>> On Thu, Nov 24, 2022 at 11:39 PM Eric Shulman <[email protected]> >>>>> wrote: >>>>> >>>>>> This is some interesting stuff! >>>>>> >>>>>> I notice that in the PDF output, if a tiddler listed in "The record >>>>>> set" table doesn't have some fields (or the field value is blank, or two >>>>>> fields have exactly the same value), that row of the table omits the >>>>>> corresponding cell, rather than showing a blank placeholder cell (or a >>>>>> repeated value if two fields have matching values). The result is that >>>>>> the >>>>>> cells for that tiddler don't align with the corresponding field name >>>>>> headings. >>>>>> >>>>>> Example 1: >>>>>> "Interactive Git Documentation by Devin Weaver" has a blank "type" >>>>>> field. >>>>>> The result is that the "url" field value is displayed under the >>>>>> "type" column heading >>>>>> >>>>>> Example 2: >>>>>> "Simple Zork-like Game by Jed Carty" has the same timestamp for >>>>>> "created" and "modified" (20141118143636664). >>>>>> The result is that the "modified" field value is omitted from the >>>>>> table, and the "text" field value is displayed under the "tags" column >>>>>> heading. >>>>>> >>>>>> Since I can't look at your code to see what you are doing, I can only >>>>>> guess at some possible workarounds for these issues. >>>>>> >>>>>> I assume you are using some filter syntax to iterate over the fields >>>>>> of a tiddler and using something like "get<fieldname>" to retrieve the >>>>>> values that are shown in the table cells. If this is the case, you >>>>>> might >>>>>> try using something like "get<fieldname>else[]", which would ensure that >>>>>> empty/missing fields are converted to blank text rather than being >>>>>> omitted. For the duplicate value problem, you might try preceding the >>>>>> relevant filter run syntax with "=" to preserve duplicate values in the >>>>>> results. >>>>>> >>>>>> Hope this helps, >>>>>> -e >>>>>> On Thursday, November 24, 2022 at 6:29:38 PM UTC-8 [email protected] >>>>>> wrote: >>>>>> >>>>>>> select * from Examples >>>>>>> >>>>>>> Results (preceded by sanity-checks of steps towards result set) in >>>>>>> attached PDF. >>>>>>> >>>>>>> On Thursday, November 24, 2022 at 8:39:39 PM UTC-4 Charlie Veniot >>>>>>> wrote: >>>>>>> >>>>>>>> Working on: select * from Examples >>>>>>>> >>>>>>>> Using TiddlyWiki.com >>>>>>>> >>>>>>>> The tag "Examples" being the table. >>>>>>>> >>>>>>>> On Thursday, November 24, 2022 at 4:46:34 PM UTC-4 Charlie Veniot >>>>>>>> wrote: >>>>>>>> >>>>>>>>> As always, the question of "how would I do that/this in >>>>>>>>> TiddlyWiki" just grabs me by the jugular (i.e. it gets all of my >>>>>>>>> attention.) >>>>>>>>> >>>>>>>>> Proof of concept prototype pending ... >>>>>>>>> >>>>>>>> -- >>>>>> You received this message because you are subscribed to a topic in >>>>>> the Google Groups "TiddlyWiki" group. >>>>>> To unsubscribe from this topic, visit >>>>>> https://groups.google.com/d/topic/tiddlywiki/GWxH8tPzDn4/unsubscribe. >>>>>> To unsubscribe from this group and all its topics, send an email to >>>>>> [email protected]. >>>>>> To view this discussion on the web visit >>>>>> https://groups.google.com/d/msgid/tiddlywiki/0c91473e-d7eb-46a5-b888-91a0e34b7d24n%40googlegroups.com >>>>>> >>>>>> <https://groups.google.com/d/msgid/tiddlywiki/0c91473e-d7eb-46a5-b888-91a0e34b7d24n%40googlegroups.com?utm_medium=email&utm_source=footer> >>>>>> . >>>>>> >>>>> -- 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/5feef6bd-fe31-4dff-917f-099e12b5658dn%40googlegroups.com.
