[tw5] Re: Highlighting duplicates in lists

2021-08-30 Thread TW Tones
Mohamad,

Sorry, I did not mean to imply you were not putting in the effort, more 
that you needed to direct it elsewhere first.

Although it is great to see you are keen and jumping into it, it can just 
make it a little hard to support you. Don't be shy to keep asking, but 
trust in your ability to learn yourself as well.

Tones

On Tuesday, 31 August 2021 at 07:42:21 UTC+10 mohamed...@hotmail.com wrote:

> Thanks tones 
>
> actually my problem is not lack of effort but  rather lack of knowledge  
> :( , i try many different things before coming back, its just like you said 
> i am guilty of trying to plug in the code rather than fully understanding it
>
> well then ..i guess its time for me to up my game with the filter syntax 
> first  before attempting anything else
>
> i guess for now the thread can be closed, but thanks again for you help :)
>
>
>
> On Monday, August 30, 2021 at 2:25:28 AM UTC+2 TW Tones wrote:
>
>> Mohamad,
>>
>> Part of the issue here is you have not yet learned the basic syntax of 
>> tiddlywiki yet, we all start somewhere, my instructions should have being 
>> self evident if you had just rudimentary tiddlywiki syntax, all of which I 
>> learned from TiddlyWiki.com 
>>
>> I did answer this latest question here 
>>  and 
>> you can put *{{{ [all[current]get[date-field]format:date[]] }}} *where 
>> you read *this is displayed inside the list*
>>
>> I am happy still to help, but you force me to revisit the whole thread 
>> again. I am not sure that when I gave previous answers, you tried to 
>> understand what I shared with you, it seems more like you just tried to 
>> "plugin my answers" to your code without trying to work it out. I may be 
>> wrong but please try a little harder to work through the carefully 
>> considered answers you get.
>>
>> Tones
>>
>> On Sunday, 29 August 2021 at 12:38:56 UTC+10 mohamed...@hotmail.com 
>> wrote:
>>
>>> thanks tones,
>>>
>>> back one step , the original code was ..
>>>
>>>   matchthen[color: 
>>> red;]] }}}><>
>>> 
>>>
>>> 
>>> 
>>> the modified code is as follows 
>>>
>>> >> [all[]prefix[New]!titleget[field]match*{!!field}*then[color:
>>>  
>>> red;]] }}}>* this is displayed inside the list* 
>>>
>>> the instruction is to replace 
>>>  *{{!!field}} *
>>> With *{{{ [all[current]get[field]format:date[]] }}}*
>>>
>>> *(change "field" to your date field)*
>>>
>>> making the code
>>>
>>> >> [all[]prefix[New]!titleget[field]match *{{{ 
>>> [all[current]get[field_example]format:date[]] }}} *then[color: red;]] 
>>> }}}> this is displayed inside the list 
>>>
>>> this does not work, prob because i have misinterpreted your instructions
>>>
>>> also there are several things missed out in the modified code , the 
>>> enlist operator, the   variable, is this intentional?
>>>
>>> if the date field is "field_example"  , can you please tell me what the 
>>> full line of code would be ..  
>>>
>>> thanks again
>>> On Saturday, August 28, 2021 at 1:44:23 AM UTC+2 TW Tones wrote:
>>>
 The information you are after is in my earlier post
 *<> {{!!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,

 >>> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
 red;]] }}}>* this is displayed inside the list*

 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.
 *<> **{{{ [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>
>> > [enlistmatchthen[color: 
>> red;]] }}}><>
>>
>> It does not have <> {{!!field}} 
>>
>> instead there is  <>  ,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
>>> 
>>> <$list filter="[all[]prefix[New]has[field]]">
>>>>> 

[tw5] Re: Highlighting duplicates in lists

2021-08-30 Thread paulgilbert2000
Thanks tones 

actually my problem is not lack of effort but  rather lack of knowledge  :( 
, i try many different things before coming back, its just like you said i 
am guilty of trying to plug in the code rather than fully understanding it

well then ..i guess its time for me to up my game with the filter syntax 
first  before attempting anything else

i guess for now the thread can be closed, but thanks again for you help :)



On Monday, August 30, 2021 at 2:25:28 AM UTC+2 TW Tones wrote:

> Mohamad,
>
> Part of the issue here is you have not yet learned the basic syntax of 
> tiddlywiki yet, we all start somewhere, my instructions should have being 
> self evident if you had just rudimentary tiddlywiki syntax, all of which I 
> learned from TiddlyWiki.com 
>
> I did answer this latest question here 
>  and 
> you can put *{{{ [all[current]get[date-field]format:date[]] }}} *where 
> you read *this is displayed inside the list*
>
> I am happy still to help, but you force me to revisit the whole thread 
> again. I am not sure that when I gave previous answers, you tried to 
> understand what I shared with you, it seems more like you just tried to 
> "plugin my answers" to your code without trying to work it out. I may be 
> wrong but please try a little harder to work through the carefully 
> considered answers you get.
>
> Tones
>
> On Sunday, 29 August 2021 at 12:38:56 UTC+10 mohamed...@hotmail.com wrote:
>
>> thanks tones,
>>
>> back one step , the original code was ..
>>
>>   matchthen[color: 
>> red;]] }}}><>
>> 
>>
>> 
>> 
>> the modified code is as follows 
>>
>> get[field]match
>> *{!!field}*then[color: red;]] }}}>* this is displayed inside the 
>> list* 
>>
>>
>> the instruction is to replace 
>>  *{{!!field}} *
>> With *{{{ [all[current]get[field]format:date[]] }}}*
>>
>> *(change "field" to your date field)*
>>
>> making the code
>>
>> get[field]match 
>> *{{{ 
>> [all[current]get[field_example]format:date[]] }}} *then[color: red;]] 
>> }}}> this is displayed inside the list 
>>
>> this does not work, prob because i have misinterpreted your instructions
>>
>> also there are several things missed out in the modified code , the 
>> enlist operator, the   variable, is this intentional?
>>
>> if the date field is "field_example"  , can you please tell me what the 
>> full line of code would be ..  
>>
>> thanks again
>> On Saturday, August 28, 2021 at 1:44:23 AM UTC+2 TW Tones wrote:
>>
>>> The information you are after is in my earlier post
>>> *<> {{!!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,
>>>
>>> >> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
>>> red;]] }}}>* this is displayed inside the list*
>>>
>>> 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.
>>> *<> **{{{ [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>
>  [enlistmatchthen[color: 
> red;]] }}}><>
>
> It does not have <> {{!!field}} 
>
> instead there is  <>  ,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
>> 
>> <$list filter="[all[]prefix[New]has[field]]">
>>> [all[]prefix[New]!titleget[field]match{!!field}then[color:
>>  
>> red;]] }}}>* <> {{!!field}}*
>> 
>> 
>>
>>
>> *<> {{!!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 , 

[tw5] Re: Highlighting duplicates in lists

2021-08-29 Thread TW Tones
Mohamad,

Part of the issue here is you have not yet learned the basic syntax of 
tiddlywiki yet, we all start somewhere, my instructions should have being 
self evident if you had just rudimentary tiddlywiki syntax, all of which I 
learned from TiddlyWiki.com 

I did answer this latest question here 
 and 
you can put *{{{ [all[current]get[date-field]format:date[]] }}} *where you 
read *this is displayed inside the list*

I am happy still to help, but you force me to revisit the whole thread 
again. I am not sure that when I gave previous answers, you tried to 
understand what I shared with you, it seems more like you just tried to 
"plugin my answers" to your code without trying to work it out. I may be 
wrong but please try a little harder to work through the carefully 
considered answers you get.

Tones

On Sunday, 29 August 2021 at 12:38:56 UTC+10 mohamed...@hotmail.com wrote:

> thanks tones,
>
> back one step , the original code was ..
>
>   matchthen[color: 
> red;]] }}}><>
> 
>
> 
> 
> the modified code is as follows 
>
> get[field]match
> *{!!field}*then[color: red;]] }}}>* this is displayed inside the 
> list* 
>
>
> the instruction is to replace 
>  *{{!!field}} *
> With *{{{ [all[current]get[field]format:date[]] }}}*
>
> *(change "field" to your date field)*
>
> making the code
>
> get[field]match 
> *{{{ 
> [all[current]get[field_example]format:date[]] }}} *then[color: red;]] 
> }}}> this is displayed inside the list 
>
> this does not work, prob because i have misinterpreted your instructions
>
> also there are several things missed out in the modified code , the enlist 
> operator, the   variable, is this intentional?
>
> if the date field is "field_example"  , can you please tell me what the 
> full line of code would be ..  
>
> thanks again
> On Saturday, August 28, 2021 at 1:44:23 AM UTC+2 TW Tones wrote:
>
>> The information you are after is in my earlier post
>> *<> {{!!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,
>>
>> > [all[]prefix[New]!titleget[field]match{!!field}then[color: 
>> red;]] }}}>* this is displayed inside the list*
>>
>> 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.
>> *<> **{{{ [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>
 matchthen[color: 
 red;]] }}}><>

 It does not have <> {{!!field}} 

 instead there is  <>  ,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
> 
> <$list filter="[all[]prefix[New]has[field]]">
> [all[]prefix[New]!titleget[field]match{!!field}then[color:
>  
> red;]] }}}>* <> {{!!field}}*
> 
> 
>
>
> *<> {{!!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 . 2021062506295,   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 

[tw5] Re: Highlighting duplicates in lists

2021-08-28 Thread Charlie Veniot
This whole thread inspired me to get my geek on and play my kind of 
"BrainAge" game: see Some coding fun: A Word Occurrence Highlighter 
 just in case there's 
anything of use to you in there, even if just the entertainment value...

On Thursday, July 29, 2021 at 8:03:33 PM UTC-3 mohamed...@hotmail.com wrote:

> Hi ,
>
> is it possible to highlight duplicates in a list , or make them stand out 
> in a different format/color , you know similar to excel 
>
> so in the below example ,i have a list that returns tiddlers matching a 
> certain criteria , and then displays their title field value , and also the 
> value in a custom field i named "field_example"
>
> tiddler1 and tiddler4 have the same value in the custom field and the 
> value is "X"
>
> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>
> [image: duplicates.PNG]
>

-- 
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/14ed9af6-a8d0-4b59-98d2-a6c415ebcc53n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-08-28 Thread paulgilbert2000
thanks tones,

back one step , the original code was ..

  matchthen[color: red;]] 
}}}><>

   


the modified code is as follows 

get[field]match
*{!!field}*then[color: red;]] }}}>* this is displayed inside the 
list* 


the instruction is to replace 
 *{{!!field}} *
With *{{{ [all[current]get[field]format:date[]] }}}*

*(change "field" to your date field)*

making the code

get[field]match *{{{ 
[all[current]get[field_example]format:date[]] }}} *then[color: red;]] 
}}}> this is displayed inside the list 

this does not work, prob because i have misinterpreted your instructions

also there are several things missed out in the modified code , the enlist 
operator, the   variable, is this intentional?

if the date field is "field_example"  , can you please tell me what the 
full line of code would be ..  

thanks again
On Saturday, August 28, 2021 at 1:44:23 AM UTC+2 TW Tones wrote:

> The information you are after is in my earlier post
> *<> {{!!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,
>
>  [all[]prefix[New]!titleget[field]match{!!field}then[color: 
> red;]] }}}>* this is displayed inside the list*
>
> 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.
> *<> **{{{ [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>
>>> matchthen[color: 
>>> red;]] }}}><>
>>>
>>> It does not have <> {{!!field}} 
>>>
>>> instead there is  <>  ,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
 
 <$list filter="[all[]prefix[New]has[field]]">
>>> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
 red;]] }}}>* <> {{!!field}}*
 
 


 *<> {{!!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 . 2021062506295,   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
>>>
>>>  <>: |  
>>><$list filter="[all[current]get[field_example]] 
>>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>>> variable=field-value>
>>> <$view field="field_example "format=date template=""/>
>>> <$view field="field_example1"format=date template=""/>
>>> <$view field="field_example2"format=date template=""/>
>>>
>>>  matchthen[color: 
>>> red;]] }}}><>
>>>
>>> 
>>>
>>> i also tried  adding format:date[DDD]] , which didn't yield any 

[tw5] Re: Highlighting duplicates in lists

2021-08-27 Thread TW Tones
The information you are after is in my earlier post
*<> {{!!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,

get[field]match{!!field}then[color: 
red;]] }}}>* this is displayed inside the list*

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.
*<> **{{{ [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>
>> matchthen[color: 
>> red;]] }}}><>
>>
>> It does not have <> {{!!field}} 
>>
>> instead there is  <>  ,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
>>> 
>>> <$list filter="[all[]prefix[New]has[field]]">
>>>>> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
>>> red;]] }}}>* <> {{!!field}}*
>>> 
>>> 
>>>
>>>
>>> *<> {{!!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 . 2021062506295,   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
>>
>>  <>: |  
>><$list filter="[all[current]get[field_example]] 
>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>> variable=field-value>
>> <$view field="field_example "format=date template=""/>
>> <$view field="field_example1"format=date template=""/>
>> <$view field="field_example2"format=date template=""/>
>>
>>  matchthen[color: 
>> red;]] }}}><>
>>
>> 
>>
>> 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=""/>
>>>
>>> <$view field=created format=relativedate/>
>>>
>>>  5.1.23 now allows this inside filters. 
>>> 
>>>
>>> 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 

[tw5] Re: Highlighting duplicates in lists

2021-08-27 Thread paulgilbert2000
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>
> matchthen[color: 
> red;]] }}}><>
>
> It does not have <> {{!!field}} 
>
> instead there is  <>  ,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
>> 
>> <$list filter="[all[]prefix[New]has[field]]">
>>> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
>> red;]] }}}>* <> {{!!field}}*
>> 
>> 
>>
>>
>> *<> {{!!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 . 2021062506295,   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
>
>  <>: |  
><$list filter="[all[current]get[field_example]] 
> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
> variable=field-value>
> <$view field="field_example "format=date template=""/>
> <$view field="field_example1"format=date template=""/>
> <$view field="field_example2"format=date template=""/>
>
>  matchthen[color: 
> red;]] }}}><>
>
> 
>
> 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=""/>
>>
>> <$view field=created format=relativedate/>
>>
>>  5.1.23 now allows this inside filters. 
>> 
>>
>> 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 
>

[tw5] Re: Highlighting duplicates in lists

2021-08-20 Thread paulgilbert2000
 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>
matchthen[color: 
red;]] }}}><>

It does not have <> {{!!field}} 

instead there is  <>  ,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
> 
> <$list filter="[all[]prefix[New]has[field]]">
> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
> red;]] }}}>* <> {{!!field}}*
> 
> 
>
>
> *<> {{!!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 . 2021062506295,   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

  <>: |  
<$list filter="[all[current]get[field_example]] 
 [all[current]get[field_example2]] [all[current]get[field_example3]]" 
 variable=field-value>
 <$view field="field_example "format=date template=""/>
 <$view field="field_example1"format=date template=""/>
 <$view field="field_example2"format=date template=""/>

  matchthen[color: 
 red;]] }}}><>

 

 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=""/>
>
> <$view field=created format=relativedate/>
>
>  5.1.23 now allows this inside filters. 
> 
>
> 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 

[tw5] Re: Highlighting duplicates in lists

2021-08-15 Thread TW Tones
Hio,

Back in my code

<$list filter="[all[]prefix[New]has[field]]">
   get[field]match{!!field}then[color: 
red;]] }}}>* <> {{!!field}}*




*<> {{!!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 . 2021062506295,   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
>>>
>>>  <>: |  
>>><$list filter="[all[current]get[field_example]] 
>>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>>> variable=field-value>
>>> <$view field="field_example "format=date template=""/>
>>> <$view field="field_example1"format=date template=""/>
>>> <$view field="field_example2"format=date template=""/>
>>>
>>>  matchthen[color: 
>>> red;]] }}}><>
>>>
>>> 
>>>
>>> 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=""/>

 <$view field=created format=relativedate/>

  5.1.23 now allows this inside filters. 
 

 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?
>>>
>>> 
>>> <$list filter="[all[]has[field_example]]">
>>><$set name=other-values 
>>> filter="[all[]!get[field_example]] 
>>> [all[]!titleget[field_example2]] 
>>> [all[]!titleget[field_example3]] +[sort[]]">
>>><>: |  
>>><$list filter="[all[current]get[field_example]] 
>>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>>> variable=field-value>

[tw5] Re: Highlighting duplicates in lists

2021-08-15 Thread paulgilbert2000
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 . 2021062506295,   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
>>
>>  <>: |  
>><$list filter="[all[current]get[field_example]] 
>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>> variable=field-value>
>> <$view field="field_example "format=date template=""/>
>> <$view field="field_example1"format=date template=""/>
>> <$view field="field_example2"format=date template=""/>
>>
>>  matchthen[color: 
>> red;]] }}}><>
>>
>> 
>>
>> 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=""/>
>>>
>>> <$view field=created format=relativedate/>
>>>
>>>  5.1.23 now allows this inside filters. 
>>> 
>>>
>>> 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?
>>
>> 
>> <$list filter="[all[]has[field_example]]">
>><$set name=other-values 
>> filter="[all[]!get[field_example]] 
>> [all[]!titleget[field_example2]] 
>> [all[]!titleget[field_example3]] +[sort[]]">
>><>: |  
>><$list filter="[all[current]get[field_example]] 
>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>> variable=field-value>
>> > [enlistmatchthen[color: red;]] 
>> }}}><>
>> 
>>
>> 
>> 
>>
>> 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]]">
>> "<>" {{{ [split[ ]count[]] }}}
>> 
>> <$list filter="[all[]has[field_example]]">
>><>: |  

[tw5] Re: Highlighting duplicates in lists

2021-08-15 Thread TW Tones
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
>
>  <>: |  
><$list filter="[all[current]get[field_example]] 
> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
> variable=field-value>
> <$view field="field_example "format=date template=""/>
> <$view field="field_example1"format=date template=""/>
> <$view field="field_example2"format=date template=""/>
>
>  matchthen[color: red;]] 
> }}}><>
>
> 
>
> 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=""/>
>>
>> <$view field=created format=relativedate/>
>>
>>  5.1.23 now allows this inside filters. 
>> 
>>
>> 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?
>
> 
> <$list filter="[all[]has[field_example]]">
><$set name=other-values 
> filter="[all[]!get[field_example]] 
> [all[]!titleget[field_example2]] 
> [all[]!titleget[field_example3]] +[sort[]]">
><>: |  
><$list filter="[all[current]get[field_example]] 
> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
> variable=field-value>
>  [enlistmatchthen[color: red;]] 
> }}}><>
> 
>
> 
> 
>
> 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]]">
> "<>" {{{ [split[ ]count[]] }}}
> 
> <$list filter="[all[]has[field_example]]">
><>: |  
><$list filter="[all[current]get[field_example]] 
> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
> variable=field-value>
> <$set name=value-count filter="[split[ 
> ]matchcount[]]">
> compare:number:gt[1]then[color: 
> Red;]] }}} ><> (<>)
>  
> 
> 
> 
> 
>
> Of course in the above you can choose not to show the count of the 
> same value delete  "(<>)"
>
> Regards
> Tones
>
> On Sunday, 8 August 2021 at 02:05:57 UTC+10 mohamed...@hotmail.com 
> wrote:
>
>> Hi Tones,
>>
>> sorry for the 

[tw5] Re: Highlighting duplicates in lists

2021-08-15 Thread paulgilbert2000
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

 <>: |  
   <$list filter="[all[current]get[field_example]] 
[all[current]get[field_example2]] [all[current]get[field_example3]]" 
variable=field-value>
<$view field="field_example "format=date template=""/>
<$view field="field_example1"format=date template=""/>
<$view field="field_example2"format=date template=""/>

 matchthen[color: red;]] 
}}}><>



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=""/>
>
> <$view field=created format=relativedate/>
>
>  5.1.23 now allows this inside filters. 
> 
>
> 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?

 
 <$list filter="[all[]has[field_example]]">
<$set name=other-values 
 filter="[all[]!get[field_example]] 
 [all[]!titleget[field_example2]] 
 [all[]!titleget[field_example3]] +[sort[]]">
<>: |  
<$list filter="[all[current]get[field_example]] 
 [all[current]get[field_example2]] [all[current]get[field_example3]]" 
 variable=field-value>
 >>> [enlistmatchthen[color: red;]] 
 }}}><>
 

 
 

 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]]">
 "<>" {{{ [split[ ]count[]] }}}
 
 <$list filter="[all[]has[field_example]]">
<>: |  
<$list filter="[all[current]get[field_example]] 
 [all[current]get[field_example2]] [all[current]get[field_example3]]" 
 variable=field-value>
 <$set name=value-count filter="[split[ 
 ]matchcount[]]">
 compare:number:gt[1]then[color: 
 Red;]] }}} ><> (<>)
  
 
 
 
 

 Of course in the above you can choose not to show the count of the same 
 value delete  "(<>)"

 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 

[tw5] Re: Highlighting duplicates in lists

2021-08-15 Thread TW Tones
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=""/>

<$view field=created format=relativedate/>

 5.1.23 now allows this inside filters. 


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?
>>>
>>> 
>>> <$list filter="[all[]has[field_example]]">
>>><$set name=other-values 
>>> filter="[all[]!get[field_example]] 
>>> [all[]!titleget[field_example2]] 
>>> [all[]!titleget[field_example3]] +[sort[]]">
>>><>: |  
>>><$list filter="[all[current]get[field_example]] 
>>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>>> variable=field-value>
>>> >> [enlistmatchthen[color: red;]] 
>>> }}}><>
>>> 
>>>
>>> 
>>> 
>>>
>>> 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]]">
>>> "<>" {{{ [split[ ]count[]] }}}
>>> 
>>> <$list filter="[all[]has[field_example]]">
>>><>: |  
>>><$list filter="[all[current]get[field_example]] 
>>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>>> variable=field-value>
>>> <$set name=value-count filter="[split[ 
>>> ]matchcount[]]">
>>> compare:number:gt[1]then[color: 
>>> Red;]] }}} ><> (<>)
>>>  
>>> 
>>> 
>>> 
>>> 
>>>
>>> Of course in the above you can choose not to show the count of the same 
>>> value delete  "(<>)"
>>>
>>> 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 

[tw5] Re: Highlighting duplicates in lists

2021-08-14 Thread paulgilbert2000
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?
>>
>> 
>> <$list filter="[all[]has[field_example]]">
>><$set name=other-values 
>> filter="[all[]!get[field_example]] 
>> [all[]!titleget[field_example2]] 
>> [all[]!titleget[field_example3]] +[sort[]]">
>><>: |  
>><$list filter="[all[current]get[field_example]] 
>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>> variable=field-value>
>> > [enlistmatchthen[color: red;]] 
>> }}}><>
>> 
>>
>> 
>> 
>>
>> 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]]">
>> "<>" {{{ [split[ ]count[]] }}}
>> 
>> <$list filter="[all[]has[field_example]]">
>><>: |  
>><$list filter="[all[current]get[field_example]] 
>> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
>> variable=field-value>
>> <$set name=value-count filter="[split[ 
>> ]matchcount[]]">
>> compare:number:gt[1]then[color: 
>> Red;]] }}} ><> (<>)
>>  
>> 
>> 
>> 
>> 
>>
>> Of course in the above you can choose not to show the count of the same 
>> value delete  "(<>)"
>>
>> 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 

[tw5] Re: Highlighting duplicates in lists

2021-08-08 Thread paulgilbert2000
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?
>
> 
> <$list filter="[all[]has[field_example]]">
><$set name=other-values 
> filter="[all[]!get[field_example]] 
> [all[]!titleget[field_example2]] 
> [all[]!titleget[field_example3]] +[sort[]]">
><>: |  
><$list filter="[all[current]get[field_example]] 
> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
> variable=field-value>
> matchthen[color: 
> red;]] }}}><>
> 
>
> 
> 
>
> 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]]">
> "<>" {{{ [split[ ]count[]] }}}
> 
> <$list filter="[all[]has[field_example]]">
><>: |  
><$list filter="[all[current]get[field_example]] 
> [all[current]get[field_example2]] [all[current]get[field_example3]]" 
> variable=field-value>
> <$set name=value-count filter="[split[ 
> ]matchcount[]]">
> compare:number:gt[1]then[color: 
> Red;]] }}} ><> (<>)
>  
> 
> 
> 
> 
>
> Of course in the above you can choose not to show the count of the same 
> value delete  "(<>)"
>
> 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,

[tw5] Re: Highlighting duplicates in lists

2021-08-07 Thread TW Tones
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?


<$list filter="[all[]has[field_example]]">
   <$set name=other-values 
filter="[all[]!get[field_example]] 
[all[]!titleget[field_example2]] 
[all[]!titleget[field_example3]] +[sort[]]">
   <>: |  
   <$list filter="[all[current]get[field_example]] 
[all[current]get[field_example2]] [all[current]get[field_example3]]" 
variable=field-value>
matchthen[color: 
red;]] }}}><>

   



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]]">
"<>" {{{ [split[ ]count[]] }}}

<$list filter="[all[]has[field_example]]">
   <>: |  
   <$list filter="[all[current]get[field_example]] 
[all[current]get[field_example2]] [all[current]get[field_example3]]" 
variable=field-value>
<$set name=value-count filter="[split[ 
]matchcount[]]">
compare:number:gt[1]then[color: 
Red;]] }}} ><> (<>)
 





Of course in the above you can choose not to show the count of the same 
value delete  "(<>)"

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, 


[tw5] Re: Highlighting duplicates in lists

2021-08-01 Thread TW Tones
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 <> 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/388926b9-7468-464a-adad-d0f43a8a48f4n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-08-01 Thread paulgilbert2000
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 <> 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/d7dec5e1-c990-410a-9794-8d04e6488591n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-08-01 Thread PMario
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 <> 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/76d3f724-8046-4b33-8e70-a7f3106d8234n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-31 Thread paulgilbert2000
Hi Tones,

yes, this perfectly fits my needs, thank you very much

@ Mario , thank you for your help , i have just raised a feature request on 
GitHub

On Friday, July 30, 2021 at 2:23:40 PM UTC+2 TW Tones wrote:

> I can see by other replies that my example that showed the logic was not 
> enough for the OT
>
> Here I turn it into an unordered list with duplicates in red.
>
> 
> <$list filter="[all[]prefix[New]has[field]]">
> [all[]prefix[New]!titleget[field]match{!!field}then[color: 
> red;]] }}}> <> {{!!field}}
> 
> 
>
> Have I fully addressed the Original Post?
> Tones
> On Friday, 30 July 2021 at 21:28:43 UTC+10 Mat wrote:
>
>> I would say it is possible with this general idea:
>>
>> 
>> <$list filter="[tag[tests]]">
>> {{!!title}}
>>  .mywrap.{{!!title}}:not(:first-of-type) 
>> {background:yellow}
>> 
>> 
>>
>> The above will likely *not* work right away but it shows the idea. For 
>> example, for the title to work as a class name it must follow css naming 
>> conventions (and you can use some modifying filters in a $vars or $set to 
>> make it be so). And you might have to split out the content of the 
>> listwidget into a separate macro.
>>
>> <:-)
>>
>>
>> On Friday, July 30, 2021 at 1:03:33 AM UTC+2 mohamed...@hotmail.com 
>> wrote:
>>
>>> Hi ,
>>>
>>> is it possible to highlight duplicates in a list , or make them stand 
>>> out in a different format/color , you know similar to excel 
>>>
>>> so in the below example ,i have a list that returns tiddlers matching a 
>>> certain criteria , and then displays their title field value , and also the 
>>> value in a custom field i named "field_example"
>>>
>>> tiddler1 and tiddler4 have the same value in the custom field and the 
>>> value is "X"
>>>
>>> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>>>
>>> [image: duplicates.PNG]
>>>
>>

-- 
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/fa1a5cd1-5a2a-4856-b9a7-ba021e475c25n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-30 Thread TW Tones
I can see by other replies that my example that showed the logic was not 
enough for the OT

Here I turn it into an unordered list with duplicates in red.


<$list filter="[all[]prefix[New]has[field]]">
   get[field]match{!!field}then[color: 
red;]] }}}> <> {{!!field}}



Have I fully addressed the Original Post?
Tones
On Friday, 30 July 2021 at 21:28:43 UTC+10 Mat wrote:

> I would say it is possible with this general idea:
>
> 
> <$list filter="[tag[tests]]">
> {{!!title}}
>  .mywrap.{{!!title}}:not(:first-of-type) {background:yellow}
> 
> 
>
> The above will likely *not* work right away but it shows the idea. For 
> example, for the title to work as a class name it must follow css naming 
> conventions (and you can use some modifying filters in a $vars or $set to 
> make it be so). And you might have to split out the content of the 
> listwidget into a separate macro.
>
> <:-)
>
>
> On Friday, July 30, 2021 at 1:03:33 AM UTC+2 mohamed...@hotmail.com wrote:
>
>> Hi ,
>>
>> is it possible to highlight duplicates in a list , or make them stand out 
>> in a different format/color , you know similar to excel 
>>
>> so in the below example ,i have a list that returns tiddlers matching a 
>> certain criteria , and then displays their title field value , and also the 
>> value in a custom field i named "field_example"
>>
>> tiddler1 and tiddler4 have the same value in the custom field and the 
>> value is "X"
>>
>> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>>
>> [image: duplicates.PNG]
>>
>

-- 
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/a9624fc0-5fe7-40fa-8278-d478b5649053n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-30 Thread Mat
I would say it is possible with this general idea:


<$list filter="[tag[tests]]">
{{!!title}}
 .mywrap.{{!!title}}:not(:first-of-type) {background:yellow}



The above will likely *not* work right away but it shows the idea. For 
example, for the title to work as a class name it must follow css naming 
conventions (and you can use some modifying filters in a $vars or $set to 
make it be so). And you might have to split out the content of the 
listwidget into a separate macro.

<:-)


On Friday, July 30, 2021 at 1:03:33 AM UTC+2 mohamed...@hotmail.com wrote:

> Hi ,
>
> is it possible to highlight duplicates in a list , or make them stand out 
> in a different format/color , you know similar to excel 
>
> so in the below example ,i have a list that returns tiddlers matching a 
> certain criteria , and then displays their title field value , and also the 
> value in a custom field i named "field_example"
>
> tiddler1 and tiddler4 have the same value in the custom field and the 
> value is "X"
>
> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>
> [image: duplicates.PNG]
>

-- 
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/620a5821-8762-4398-b898-44843722c90bn%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-30 Thread PMario
Hi, 
Your construction should look like this, if you want to have a UL list


<$list ...>
 ... your code 



Otherwise you will create invalid HTML code.


On Friday, July 30, 2021 at 1:03:33 AM UTC+2 mohamed...@hotmail.com wrote:

can i highlight tiddler 1 and tiddler 4 maybe in red ?
>

You can't do this with 1 list widget.

TW loops evaluate each element in turn. So when tiddler 1 is evaluated, how 
should the loop know, that there will be a second element in the future, 
that will have the same name. ... Except you know, how to time-travel you 
will need 2 lists. 

The first list will need to evaluate the list of duplicates and the second 
run will need to add an eg: .duplicate-element class to every element that 
is there multiple times. 

I could think of a construction in wikitext, but it would be complex and 
time consuming. I personally would create a javascript macro, that returns 
a list of duplicates, or even better a data-tiddler with the duplicates as 
index and the color as a value. 

So it would be simple to assign a class to the elements. ... 

just some thoughts. I also think it's a valid request, and we should think 
about it in more detail.

So if you raise an issue with a link to this thread at github, we won't 
forget it. ..

-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/1197881d-4a89-453c-aaa0-9a688dec910en%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-29 Thread TW Tones
Mohamad

See the following
<$list filter="[all[]prefix[New]has[field]]">
   <$link/> {{!!field}} {{{ 
[all[]prefix[New]!titleget[field]match{!!field}then[*]] 
}}}



   - First we list All tiddlers satisfying [all[]prefix[New]has[field]]
   - Then we display a link to each tiddler and the value in field
   - Then inside the filtered transclusion (could be in a list) we now 
   search all tiddlers (again) excluding the current tiddler, if another 
   tiddler has the same value for {{!!field}} we display an Asterix.

It gets a little more complex if you want to select one as a the duplicate 
and the other as the original but if so you need to decide the condition to 
determine the first. Eg oldest in the primary, youngest is the duplicate.

Regards
Tones

On Friday, 30 July 2021 at 10:20:59 UTC+10 mohamed...@hotmail.com wrote:

> thanks tones
>
> for the second method , would that display the duplicates  , because i 
> want that 
>
> On Friday, July 30, 2021 at 1:37:33 AM UTC+2 TW Tones wrote:
>
>> Mohamad,
>>
>> One way is to sort in the parameter order before you can detect that the 
>> last is the same as the current ie a duplicate.
>>
>> The other way is for each tiddler, search for the same parameter 
>> elsewhere, if more than one found then it is duplicate before displaying 
>> the parameter. 
>>
>>- If you do this you may need to add to the filter the one that 
>>selected the list of tiddlers as well, so you don't find the parameter 
>>elsewhere. ie you are only searching in the current list of tiddlers.
>>
>> Regards
>> RTones
>> On Friday, 30 July 2021 at 09:03:33 UTC+10 mohamed...@hotmail.com wrote:
>>
>>> Hi ,
>>>
>>> is it possible to highlight duplicates in a list , or make them stand 
>>> out in a different format/color , you know similar to excel 
>>>
>>> so in the below example ,i have a list that returns tiddlers matching a 
>>> certain criteria , and then displays their title field value , and also the 
>>> value in a custom field i named "field_example"
>>>
>>> tiddler1 and tiddler4 have the same value in the custom field and the 
>>> value is "X"
>>>
>>> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>>>
>>> [image: duplicates.PNG]
>>>
>>

-- 
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/8976fbd6-a218-4ad4-9eec-0814a060d3afn%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-29 Thread paulgilbert2000
thanks tones

for the second method , would that display the duplicates  , because i want 
that 

On Friday, July 30, 2021 at 1:37:33 AM UTC+2 TW Tones wrote:

> Mohamad,
>
> One way is to sort in the parameter order before you can detect that the 
> last is the same as the current ie a duplicate.
>
> The other way is for each tiddler, search for the same parameter 
> elsewhere, if more than one found then it is duplicate before displaying 
> the parameter. 
>
>- If you do this you may need to add to the filter the one that 
>selected the list of tiddlers as well, so you don't find the parameter 
>elsewhere. ie you are only searching in the current list of tiddlers.
>
> Regards
> RTones
> On Friday, 30 July 2021 at 09:03:33 UTC+10 mohamed...@hotmail.com wrote:
>
>> Hi ,
>>
>> is it possible to highlight duplicates in a list , or make them stand out 
>> in a different format/color , you know similar to excel 
>>
>> so in the below example ,i have a list that returns tiddlers matching a 
>> certain criteria , and then displays their title field value , and also the 
>> value in a custom field i named "field_example"
>>
>> tiddler1 and tiddler4 have the same value in the custom field and the 
>> value is "X"
>>
>> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>>
>> [image: duplicates.PNG]
>>
>

-- 
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/fafb50c6-cb71-409d-8c22-c19357cf73a4n%40googlegroups.com.


[tw5] Re: Highlighting duplicates in lists

2021-07-29 Thread TW Tones
Mohamad,

One way is to sort in the parameter order before you can detect that the 
last is the same as the current ie a duplicate.

The other way is for each tiddler, search for the same parameter elsewhere, 
if more than one found then it is duplicate before displaying the 
parameter. 

   - If you do this you may need to add to the filter the one that selected 
   the list of tiddlers as well, so you don't find the parameter elsewhere. ie 
   you are only searching in the current list of tiddlers.

Regards
RTones
On Friday, 30 July 2021 at 09:03:33 UTC+10 mohamed...@hotmail.com wrote:

> Hi ,
>
> is it possible to highlight duplicates in a list , or make them stand out 
> in a different format/color , you know similar to excel 
>
> so in the below example ,i have a list that returns tiddlers matching a 
> certain criteria , and then displays their title field value , and also the 
> value in a custom field i named "field_example"
>
> tiddler1 and tiddler4 have the same value in the custom field and the 
> value is "X"
>
> can i highlight tiddler 1 and tiddler 4 maybe in red ?
>
> [image: duplicates.PNG]
>

-- 
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/84e44acd-e06d-4b76-851a-42d76c78c151n%40googlegroups.com.