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/ee32b357-1f2b-4853-805b-2ce5cf714e4dn%40googlegroups.com.
