The information you are after is in my earlier post
*<<currentTiddler>> {{!!field}} *is the display replace this with *{{{
[all[current]get[field]format:date[]] }}}*
It is what is inside the span that gets coloured using style attribute,
thus what is inside the span is what is displayed,
<li><span style={{{
[all[]prefix[New]!title<currentTiddler>get[field]match{!!field}then[color:
red;]] }}}>* this is displayed inside the list*</span></li>
So basically we replace the display of *{{!!field}} *
With *{{{ [all[current]get[field]format:date[]] }}}*
(change "field" to your date field)
So the following will be inside the span because you want the title and its
date.
*<<currentTiddler>> **{{{ [all[current]get[field]format:date[]] }}}*
The format operator requires tiddlywiki 5.1.23 or greater
Tones
On Saturday, 28 August 2021 at 02:13:48 UTC+10 [email protected] wrote:
> Hi tones,
>
> have you had the chance to look at my last post?
>
> On Saturday, August 21, 2021 at 5:14:38 AM UTC+2 paulgilbert2000 wrote:
>
>> Hi Tones,
>>
>> I am not sure which line of code you are referring too , the line that
>> does the coloring is
>> <$list filter="[all[current]get[field_example]]
>> [all[current]get[field_example2]] [all[current]get[field_example3]]"
>> variable=field-value><!-- for each example field get the value on the
>> current tiddler-->
>> <span style={{{ [enlist<other-values>match<field-value>then[color:
>> red;]] }}}><<field-value>></span>
>>
>> It does not have <<currentTiddler>> {{!!field}}
>>
>> instead there is <<field-value>> ,so is this the bit that should be
>> replaced *?*
>>
>> i tried this with no luck..
>>
>>
>> *[image: Capture.PNG]*
>> On Monday, August 16, 2021 at 6:29:52 AM UTC+2 TW Tones wrote:
>>
>>> Hio,
>>>
>>> Back in my code
>>> <ul>
>>> <$list filter="[all[]prefix[New]has[field]]">
>>> <li><span style={{{
>>> [all[]prefix[New]!title<currentTiddler>get[field]match{!!field}then[color:
>>> red;]] }}}>* <<currentTiddler>> {{!!field}}*</span></li>
>>> </$list>
>>> </ul>
>>>
>>>
>>> *<<currentTiddler>> {{!!field}} *is the display
>>> replace this with
>>> *{{{ [all[current]get[field]format:date[]] }}}*
>>> Not tested by me on this occasion
>>>
>>> where field is the chosen fieldname.
>>>
>>> Regards
>>> Tones
>>>
>>> On Monday, 16 August 2021 at 12:14:51 UTC+10 [email protected]
>>> wrote:
>>>
>>>> Thank you tones
>>>>
>>>> The real life example is to evaluate duplicate dates, so the actual
>>>> real values populating the fields are not 1 ,2 , etc.. they are actual
>>>> dates , IE . 20210625062959999, 20210811055859000,etc.
>>>> and so what i was trying is to do is have the highlighted duplicate
>>>> values converted from the tiddly wiki format they are stored in in their
>>>> respective fields , to a normal readable format when displayed in the
>>>> filter
>>>>
>>>> the
>>>> On Monday, August 16, 2021 at 2:34:07 AM UTC+2 TW Tones wrote:
>>>>
>>>>> Mohammad,
>>>>>
>>>>> I am confused, until now the fields field_example, field_example1,
>>>>> field_example2 did not contain dates.
>>>>>
>>>>> - Are you trying to convert these to dates?
>>>>> - the view widget format=date only works on tiddlywiki full serial
>>>>> number dates!
>>>>>
>>>>> Perhaps step back and describe what you want to do in the real world,
>>>>> not with tiddlywiki code that may or may not be correct.
>>>>>
>>>>> Regards
>>>>> Tones
>>>>>
>>>>> On Monday, 16 August 2021 at 01:46:55 UTC+10 [email protected]
>>>>> wrote:
>>>>>
>>>>>> HI tones,
>>>>>>
>>>>>> sorry i guess i asked the wrong question, what i wanted to know is
>>>>>> where to place the widget in the code , if i do it that way , it no
>>>>>> longer
>>>>>> highlights duplicates
>>>>>>
>>>>>> <li><<currentTiddler>>: |
>>>>>> <$list filter="[all[current]get[field_example]]
>>>>>> [all[current]get[field_example2]] [all[current]get[field_example3]]"
>>>>>> variable=field-value><!-- for each example field get the value on the
>>>>>> current tiddler-->
>>>>>> <$view field="field_example "format=date template="YYYY"/>
>>>>>> <$view field="field_example1"format=date template="YYYY"/>
>>>>>> <$view field="field_example2"format=date template="YYYY"/>
>>>>>>
>>>>>> <span style={{{ [enlist<other-values>match<field-value>then[color:
>>>>>> red;]] }}}><<field-value>></span><!-- change the style to color red if
>>>>>> any
>>>>>> other-values match the current value -->
>>>>>>
>>>>>> </$list></li>
>>>>>>
>>>>>> i also tried adding format:date[DDD]] , which didn't yield any
>>>>>> results
>>>>>>
>>>>>> <$list filter="[all[current]get[field_example]]
>>>>>> [all[current]get[field_example2]] [all[current]get[field_example3]]"
>>>>>> format:date[DDD]] variable=field-value>
>>>>>> On Sunday, August 15, 2021 at 10:12:57 AM UTC+2 TW Tones wrote:
>>>>>>
>>>>>>> Look for and use the viewWidget and use the format date with a
>>>>>>> template, or the format relativedate
>>>>>>>
>>>>>>> Get into the habit also of searching in tiddlywiki.com to learn how
>>>>>>> to do things.
>>>>>>> [image: Snag_c8a06a9.png]
>>>>>>>
>>>>>>> eg;
>>>>>>>
>>>>>>> <$view field=created format=date template="YYYY"/>
>>>>>>>
>>>>>>> <$view field=created format=relativedate/>
>>>>>>>
>>>>>>> 5.1.23 now allows this inside filters.
>>>>>>> <https://tiddlywiki.com/#format%20Operator%20(Examples)>
>>>>>>>
>>>>>>> Regards
>>>>>>> Tones
>>>>>>>
>>>>>>> On Sunday, 15 August 2021 at 10:26:32 UTC+10 [email protected]
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Sorry one more questions
>>>>>>>>
>>>>>>>> if the values are dates, how can they be displayed in normal format
>>>>>>>> ,and not the tiddly wiki format
>>>>>>>>
>>>>>>>> On Monday, August 9, 2021 at 1:10:18 AM UTC+2 paulgilbert2000 wrote:
>>>>>>>>
>>>>>>>>> Thank you tones
>>>>>>>>>
>>>>>>>>> Will take me a while to understand all that . but it works like a
>>>>>>>>> charm , and its even more than what i have asked for
>>>>>>>>>
>>>>>>>>> thanks again:)
>>>>>>>>>
>>>>>>>>> On Sunday, August 8, 2021 at 7:31:10 AM UTC+2 TW Tones wrote:
>>>>>>>>>
>>>>>>>>>> Mohamad,
>>>>>>>>>>
>>>>>>>>>> I am happy to look at solving the problem presented but my
>>>>>>>>>> suspicion remains that there may be a different way to put the
>>>>>>>>>> question in
>>>>>>>>>> the first place.
>>>>>>>>>>
>>>>>>>>>> Sometimes a question can be rephrased such that the answer is
>>>>>>>>>> simpler to find.
>>>>>>>>>>
>>>>>>>>>> - In this we have multiple tiddlers, with multiple fields,
>>>>>>>>>> with *values* that may be duplicated across these
>>>>>>>>>> tiddlers/fields.
>>>>>>>>>> - in effect you want to list all tiddlers using the select
>>>>>>>>>> fields, list these for each tiddler then for each found value
>>>>>>>>>> - detect when that value occurs in any other tiddler (not
>>>>>>>>>> self?) or select fields, if it does highlight it.
>>>>>>>>>> - I am not sure why you want to do this and can think of many
>>>>>>>>>> ways to list/interpret the data!
>>>>>>>>>> - What about triplicates?
>>>>>>>>>> - What about duplicates in the same tiddler?
>>>>>>>>>>
>>>>>>>>>> I think using your test data this is what you wanted?
>>>>>>>>>>
>>>>>>>>>> <ul>
>>>>>>>>>> <$list filter="[all[]has[field_example]]"><!-- each tiddler
>>>>>>>>>> meeting condition -->
>>>>>>>>>> <$set name=other-values
>>>>>>>>>> filter="[all[]!<currentTiddler>get[field_example]]
>>>>>>>>>> [all[]!title<currentTiddler>get[field_example2]]
>>>>>>>>>> [all[]!title<currentTiddler>get[field_example3]] +[sort[]]"><!-- for
>>>>>>>>>> this
>>>>>>>>>> tiddler build a list of all values in the three fields except this
>>>>>>>>>> tiddlers
>>>>>>>>>> -->
>>>>>>>>>> <li><<currentTiddler>>: |
>>>>>>>>>> <$list filter="[all[current]get[field_example]]
>>>>>>>>>> [all[current]get[field_example2]] [all[current]get[field_example3]]"
>>>>>>>>>> variable=field-value><!-- for each example field get the value on
>>>>>>>>>> the
>>>>>>>>>> current tiddler-->
>>>>>>>>>> <span style={{{
>>>>>>>>>> [enlist<other-values>match<field-value>then[color: red;]]
>>>>>>>>>> }}}><<field-value>></span><!-- change the style to color red if any
>>>>>>>>>> other-values match the current value -->
>>>>>>>>>> </$list></li>
>>>>>>>>>> </$set>
>>>>>>>>>> </$list>
>>>>>>>>>> </ul>
>>>>>>>>>>
>>>>>>>>>> It will also highlight triplicates...
>>>>>>>>>>
>>>>>>>>>> A slightly more efficient method is available that could actually
>>>>>>>>>> could the number of repeats and color red if > 1
>>>>>>>>>>
>>>>>>>>>> <$set name=all-values filter="=[all[]get[field_example]]
>>>>>>>>>> =[all[]get[field_example2]] =[all[]get[field_example3]]"><!-- get
>>>>>>>>>> all
>>>>>>>>>> values in all three fields using = so duplicates are not removed -->
>>>>>>>>>> "<<all-values>>" {{{ [<all-values>split[ ]count[]] }}}
>>>>>>>>>> <ul>
>>>>>>>>>> <$list filter="[all[]has[field_example]]"><!-- each tiddler
>>>>>>>>>> meeting given condition -->
>>>>>>>>>> <li><<currentTiddler>>: |
>>>>>>>>>> <$list filter="[all[current]get[field_example]]
>>>>>>>>>> [all[current]get[field_example2]] [all[current]get[field_example3]]"
>>>>>>>>>> variable=field-value><!-- for each example field get the value on
>>>>>>>>>> the
>>>>>>>>>> current tiddler-->
>>>>>>>>>> <$set name=value-count filter="[<all-values>split[
>>>>>>>>>> ]match<field-value>count[]]">
>>>>>>>>>> <span style={{{
>>>>>>>>>> [<value-count>compare:number:gt[1]then[color: Red;]] }}}
>>>>>>>>>> ><<field-value>>
>>>>>>>>>> (<<value-count>>)</span><!-- change the style to color red if any
>>>>>>>>>> other-values match the current value -->
>>>>>>>>>> </$set>
>>>>>>>>>> </$list></li>
>>>>>>>>>> </$list>
>>>>>>>>>> </ul>
>>>>>>>>>> </$set>
>>>>>>>>>>
>>>>>>>>>> Of course in the above you can choose not to show the count of
>>>>>>>>>> the same value delete "(<<value-count>>)"
>>>>>>>>>>
>>>>>>>>>> Regards
>>>>>>>>>> Tones
>>>>>>>>>>
>>>>>>>>>> On Sunday, 8 August 2021 at 02:05:57 UTC+10
>>>>>>>>>> [email protected] wrote:
>>>>>>>>>>
>>>>>>>>>>> Hi Tones,
>>>>>>>>>>>
>>>>>>>>>>> sorry for the late reply , i wasn't clear at all in my last
>>>>>>>>>>> question actually
>>>>>>>>>>>
>>>>>>>>>>> So for example ,if every tiddler has three fields , field_example
>>>>>>>>>>> , field_example2 and field_example3
>>>>>>>>>>>
>>>>>>>>>>> [image: Capture.PNG]
>>>>>>>>>>>
>>>>>>>>>>> and they are populated with values as such
>>>>>>>>>>>
>>>>>>>>>>> * tiddler 1* has in field_example "3" And in
>>>>>>>>>>> field_example2
>>>>>>>>>>> "2" And in field_example3 "6"
>>>>>>>>>>> and
>>>>>>>>>>> *tiddler 2 * has in field_example "4" And in
>>>>>>>>>>> field_example2
>>>>>>>>>>> "9" And in field_example3 "8"
>>>>>>>>>>> and
>>>>>>>>>>> *tiddler 3 *has in field_example "2" And in
>>>>>>>>>>> field_example2 "7" And in field_example3 "5"
>>>>>>>>>>> and
>>>>>>>>>>> *tiddler 4 *has in field_example "1" And in
>>>>>>>>>>> field_example2 "2" And in field_example3 "4"
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> as you can see, the number 2 is reoccurring in different
>>>>>>>>>>> fields in different tiddlers , so when doing a list, can all these
>>>>>>>>>>> tiddlers which has a 2 be highlighted
>>>>>>>>>>>
>>>>>>>>>>> [image: Capture2.PNG]
>>>>>>>>>>>
>>>>>>>>>>> even better can the transcluded values only be highlighted and
>>>>>>>>>>> not the whole line
>>>>>>>>>>> [image: Capture3.PNG]
>>>>>>>>>>>
>>>>>>>>>>> i have attached a sample file with with the test data i am
>>>>>>>>>>> working with
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> Thanks again for your help
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>> On Monday, August 2, 2021 at 2:33:26 AM UTC+2 TW Tones wrote:
>>>>>>>>>>>
>>>>>>>>>>>> Mohamad,
>>>>>>>>>>>>
>>>>>>>>>>>> My solution above can be used to do this for multiple
>>>>>>>>>>>> fields/criteria because it re-examines the whole list every time.
>>>>>>>>>>>> This
>>>>>>>>>>>> makes it logically very flexible but revisiting the whole list for
>>>>>>>>>>>> every
>>>>>>>>>>>> special field for each tiddler is not very high performance. There
>>>>>>>>>>>> are
>>>>>>>>>>>> other "algorithms you can deploy" if you describe the full
>>>>>>>>>>>> problem,
>>>>>>>>>>>> especially if you can share test data.
>>>>>>>>>>>>
>>>>>>>>>>>> The thing is, what you want to achieve could be addressed more
>>>>>>>>>>>> efficiently with better knowledge of the input data(set), and
>>>>>>>>>>>> ensuring that
>>>>>>>>>>>> data is arranged appropriately. Over in the aforementioned github
>>>>>>>>>>>> item
>>>>>>>>>>>> https://github.com/Jermolene/TiddlyWiki5/discussions/5925 I
>>>>>>>>>>>> think a solution may be a *report widget* designed for most
>>>>>>>>>>>> reporting requirements ie beyond the list widget features. However
>>>>>>>>>>>> even in
>>>>>>>>>>>> this case you will need to give further thought on your input data
>>>>>>>>>>>> and its
>>>>>>>>>>>> structure.
>>>>>>>>>>>>
>>>>>>>>>>>> Mohamad - you could generate a list of tiddlers with duplicate
>>>>>>>>>>>> *A* fields and another with a list of duplicate *B* fields
>>>>>>>>>>>> then in the list test if each title exists in these lists.
>>>>>>>>>>>>
>>>>>>>>>>>> Regards
>>>>>>>>>>>> Tones
>>>>>>>>>>>> On Monday, 2 August 2021 at 09:23:23 UTC+10
>>>>>>>>>>>> [email protected] wrote:
>>>>>>>>>>>>
>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>
>>>>>>>>>>>>> is it possible to use the same code for multiple criteria, so
>>>>>>>>>>>>> highlight in red all occurrences of duplicates in field A and
>>>>>>>>>>>>> also field B
>>>>>>>>>>>>> within the same list of tiddlers?
>>>>>>>>>>>>>
>>>>>>>>>>>>> i guess my question is can a Get / then be used within the
>>>>>>>>>>>>> same filter multiple times for multiple fields/criteria
>>>>>>>>>>>>>
>>>>>>>>>>>>> thanks
>>>>>>>>>>>>>
>>>>>>>>>>>>> On Sunday, August 1, 2021 at 6:17:44 PM UTC+2 PMario wrote:
>>>>>>>>>>>>>
>>>>>>>>>>>>>> Hi,
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> Since Tony did present a workable solution, the issue was
>>>>>>>>>>>>>> moved to the discussions section at github.
>>>>>>>>>>>>>> https://github.com/Jermolene/TiddlyWiki5/discussions/5925
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> I still think, that a <<duplicates>> macro may reduce the
>>>>>>>>>>>>>> complexity of the solution.
>>>>>>>>>>>>>>
>>>>>>>>>>>>>> -mario
>>>>>>>>>>>>>>
>>>>>>>>>>>>>
--
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/8dfaa45d-e522-4414-8131-9fdca42944f7n%40googlegroups.com.
