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/e445e847-03b4-4341-b781-912acdadb190n%40googlegroups.com.
