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/9b806e24-963a-4c09-a8ea-131198da9667n%40googlegroups.com.
