OMG - it is embarrassing to learn that clicking the column header sorts the whole table. I should have tried that first.
Thank you Mohammad for creating this great solution. Is there a way to export to spreadsheet format (or CSV) for others (non TW5 users) to add to? JWHoneycutt On Saturday, January 23, 2021 at 9:58:07 PM UTC-5 Mohammad wrote: > Note, the table is created from a filter. It i s the main input parameter. > It makes the rows. After creating the table, you can click on the sort > (field) column you made to sort the table based on that field. > By the way, dynamic tables have the feature to sort by each column > (field), so it does not make sense to use the sort filter operator with > input filter. > > Hope this helps > > > > Best wishes > Mohammad > > > On Sun, Jan 24, 2021 at 1:05 AM 'JWHoneycutt' via TiddlyWiki < > [email protected]> wrote: > >> Now my macro is: >> >> <<table-dynamic filter:"[tag[Ayacucho]tag[Owner]tag[Person]]" >> fields:"tbl-expand sort title lot name corp_name corp_number email phone" >> caption:"''Ayacucho Lot Owners''" sortOp:"nsort" class:"w-100 >> table-hover-cyan table-center thead-dark" footerRows:"0" stateTiddler:"" >> editButton:"yes">> >> >> It is still sorting the filtered records by tiddler title (but I want it >> sorted by sort field), because there is no place where I have told it to >> "nsort[sort]" - right? >> On Saturday, January 23, 2021 at 3:00:09 PM UTC-5 Mohammad wrote: >> >>> See https://kookma.github.io/TW-Shiraz/#demo%2Fdynamic-table-macro >>> >>> and study the sortOp. >>> >>> >>> Best wishes >>> Mohammad >>> >>> >>> On Sat, Jan 23, 2021 at 9:47 PM 'JWHoneycutt' via TiddlyWiki < >>> [email protected]> wrote: >>> >>>> I love Mohammad's solution for dynamic-tables, (Shiraz plugin version >>>> 2.1.2) but... >>>> >>>> I need a little more help making a dynamic table sort correctly. >>>> >>>> I created a numeric "sort" field. Entries are (in order) 01, 021, 022, >>>> 03, 071, 101, 102, 11, etc. >>>> >>>> My current best guess still does not work: >>>> ``` >>>> <<table-dynamic filter:"[tag[Ayacucho]tag[Owner]tag[Person]]" >>>> fields:"tbl-expand title lot name corp_name corp_number email phone" >>>> caption:"''Ayacucho Lot Owners''" class:"w-100 table-hover-cyan >>>> table-center thead-dark" footerRows:"0" >>>> stateTiddler:"$:/keepstate/dynamictables/$(sort)$" editButton:"yes">> >>>> >>>> ``` >>>> >>>> I first assumed I could just make my filter: >>>> "[tag[Ayacucho]tag[Owner]tag[Person]sort[sort]]" and leave >>>> stateTiddler:"" (blank), but it does not sort by the "sort" field. >>>> >>>> Next try is filter:"[tag[Ayacucho]tag[Owner]tag[Person]" and >>>> stateTiddler:"sort", still fails. >>>> How do I get the table to sort by the "sort" field? >>>> >>>> (The sort order can be permanent.) - Do I insert this lingo here? >>>> $:/keepstate/dynamictables/$(currentTable)$ >>>> >>>> JWHoneycutt >>>> >>>> -- >>>> >>> 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/79389ea1-4cff-45b1-b8bf-d50d016c4ac2n%40googlegroups.com >>>> >>>> <https://groups.google.com/d/msgid/tiddlywiki/79389ea1-4cff-45b1-b8bf-d50d016c4ac2n%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/be262d4b-3b07-4717-8d3d-bc0160fdd165n%40googlegroups.com >> >> <https://groups.google.com/d/msgid/tiddlywiki/be262d4b-3b07-4717-8d3d-bc0160fdd165n%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/4ce751df-cdc3-4073-9807-4061cc3831b2n%40googlegroups.com.
