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/7f572ee2-f56b-4402-9b59-e91de1c9ed0bn%40googlegroups.com.
