In your example there is a field with the value "name" for every entry,
they do not need to be sorted.
If on the other hand you are referring to values in the second field like
"pleiade", now that is a different story.
Another approach without the JSON mangler is to parse each line, then parse
each value;
Here is a hint at how it can be done. Note no json handling, just text
handling.
\define open-curly() {
\define open-square() [
\define close-square() ]
\define dbl-quote() "
\define comma() ,
\define colon() :
<$list
filter="[{Data}splitregexp[\n]!prefix<open-square>!prefix<close-square>]"
variable=each-line>
;<<each-line>><br>
<$list filter="[<each-line>split<dbl-quote>nth[4]]">
</$list>
</$list>
Regards
Tones
On Tuesday, 20 April 2021 at 08:17:02 UTC+10 [email protected] wrote:
> Thank you Mark. The macro is a nice thing, but it is not a filter. This
> allow to build the html for a sorted table.
>
> But there might be some case where I would need to refine the filter to
> get a whole list of more complex data out of my filter. BUT this is not
> true as of now.
>
> With your help, I can achieve what I want in a reasonable amount of code,
> and clear code. That's great!
>
> Le lundi 19 avril 2021 à 20:34:39 UTC+2, Mark S. a écrit :
>
>> This is a slightly different approach that I've used before. The names
>> are all fetched in a form where they can be wikified, turned back into a
>> list, and then sorted. Then a lookup is done by name for each item and the
>> project is extracted. I think from this you can see how you would proceed
>> with extracting the URL as well. For this to work of course, the names have
>> to be unique. I called the data tiddler "data" here.
>>
>> \define getnames() <$vars lb=" [[" rb="]]" sep="$$"><$list
>> filter="[[data]indexes[]addsuffix[/name]]" variable="fetch">{{{
>> [[data]getindex<fetch>addprefix<lb>addsuffix<rb>] }}}</$list></$vars>
>>
>> \define getprojectbyname(name)
>> <$list filter="[[data]indexes[]]" variable="index">
>> <$list filter="[<index>addsuffix[/name]]" variable=namepath>
>> <$list filter="[[data]getindex<namepath>compare:string:eq<__name__>]">
>> <$list filter="[<index>addsuffix[/project]]" variable=projectpath>
>> {{{ [[data]getindex<projectpath>] }}}
>> </$list></$list></$list></$list>
>> \end
>>
>> <$wikify text="""<<getnames>>""" name="names">
>> <$list filter="[enlist<names>sort[]]" variable="name">
>> Name: <<name>> <br/>
>> Project: <$macrocall $name="getprojectbyname" name=<<name>> /> <br/><br/>
>>
>> </$list>
>> </$wikify>
>>
>> I've often thought how handy it would be if you could get two outputs
>> from a list instead of just one. e.g. both and index and the index/name
>> value.
>>
>>
>> On Monday, April 19, 2021 at 8:56:23 AM UTC-7 [email protected]
>> wrote:
>>
>>> I have a structured json data tiddler name "projects", which looks like
>>> this:
>>>
>>> [
>>> { "project": "pleiade", "name": "Pléiade v5", "url": "http:
>>> pleiade.test.acmeserver.com" },
>>> { "project": "rnvp", "name": "RNVP preprod", "url": "
>>> https://rnvp.preprod.acmeserver.com"; },
>>> { "project": "ars", "name": "application de réservation de salles",
>>> "url": "http://ars.test.acmeserver.com"; }
>>> ]
>>>
>>> I want to show this a list sorted on the "name" field. This is the
>>> sorting part which I struggle to get, unsuccessfully.
>>>
>>> I have installed the jsonmangler plugin. I can't find a reherence doc
>>> though. With numerous tries, I've been able to get my list, but not sorted.
>>>
>>> I have this idea to constitute a list of tiddlers where each item is
>>> "name^index" where name is the name and index the index of each record.
>>> Then I wold sort the list and reduce it to the index part to get the sorted
>>> list of index which would enable me to achieve the display I want.
>>>
>>> But I cannot build this name-index list. I have the list of the names in
>>> the natural order and the list of numbers which are the natural indexes of
>>> the items. I can then get a list list like "t0 t1 t2 0 1 2". I can in fact
>>> be a little clever and build "t0 t1 t2 ^0; ^1; ^2;" instead and then what
>>> I need is getting "t0 ^0; t1 ^1; t2 ^2;". This is the critical step I don't
>>> know how to do.
>>>
>>> (because from there I would join it in "t0^0;t1^1;t2^2;", split that
>>> along the ";" character and get the list of name^index I wish.)
>>>
>>> I know how to do it manually in the case of three records, like this:
>>>
>>> <ol>
>>> <$list variable="demo" filter="[enlist[t0 t1 t2]append[^0; ^1;
>>> ^2;]move:-2[^0;]move:-1[^1;]join[]split[;]!is[blank]]">
>>> <li><<demo>></li>
>>> </$list>
>>> </ol>
>>>
>>> So the general idea would be to generate the part like
>>> "move:-2[^0;]move:-1[^1;]" from the number of records. That is beginning to
>>> be very complex for what that is, how common this seems to be to me. So
>>> surely there is a nicer way to do it.
>>>
>>> thanks in advance,
>>>
>>>
--
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/d285c16d-b423-42d9-a1bc-1cf7b98f2175n%40googlegroups.com.
