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 mohamed...@hotmail.com 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 mohamed...@hotmail.com >>> 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 mohamed...@hotmail.com >>>>> 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 mohamed...@hotmail.com >>>>>>> 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 >>>>>>>>>> mohamed...@hotmail.com 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 >>>>>>>>>>>> mohamed...@hotmail.com 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 tiddlywiki+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/tiddlywiki/8dfaa45d-e522-4414-8131-9fdca42944f7n%40googlegroups.com.