INTERACT FORUM

More => Old Versions => Media Center 16 (Development Ended) => Topic started by: Vincent Kars on August 15, 2011, 02:51:44 pm

Title: Searchbox and calculated fields
Post by: Vincent Kars on August 15, 2011, 02:51:44 pm

I have a calculated field Artist (individual)
This gives me all the names (multiple values) from vatious fields.

Code: [Select]

ListBuild(1,;,[Conductor],Replace([artist],//,;),Replace([Album Artist],//,;))&datatype=[list] 

I set this field to Default Search Field.

If I type xxx in the search box; xxx ( Artist (individual)) will pop up in the suggestion box.
However, if I select this item the result is always empty.

Title: Re: Searchbox and calculated fields
Post by: marko on August 16, 2011, 02:35:19 am

I'm not sure if this is a fair comparison, but...

I have a calculated field Population
This gives all the names held under "!People" in my nested [Keywords] field.

Code: [Select]

listbuild(1,;,if(isequal(listitem([keywords],0,;),people,8),replace(listitem([keywords],0,;),!People\,),),if(isequal(listitem([keywords],1,;),people,8),replace(listitem([keywords],1,;),!People\,),),if(isequal(listitem([keywords],2,;),people,8),replace(listitem([keywords],2,;),!People\,),),if(isequal(listitem([keywords],3,;),people,8),replace(listitem([keywords],3,;),!People\,),),if(isequal(listitem([keywords],4,;),people,8),replace(listitem([keywords],4,;),!People\,),),if(isequal(listitem([keywords],5,;),people,8),replace(listitem([keywords],5,;),!People\,),),if(isequal(listitem([keywords],6,;),people,8),replace(listitem([keywords],6,;),!People\,),),if(isequal(listitem([keywords],7,;),people,8),replace(listitem([keywords],7,;),!People\,),),if(isequal(listitem([keywords],8,;),people,8),replace(listitem([keywords],8,;),!People\,),),if(isequal(listitem([keywords],9,;),people,8),replace(listitem([keywords],9,;),!People\,),),if(isequal(listitem([keywords],10,;),people,8),replace(listitem([keywords],10,;),!People\,),),if(isequal(listitem([keywords],11,;),people,8),replace(listitem([keywords],11,;),!People\,),),if(isequal(listitem([keywords],12,;),people,8),replace(listitem([keywords],12,;),!People\,),),if(isequal(listitem([keywords],13,;),people,8),replace(listitem([keywords],13,;),!People\,),),if(isequal(listitem([keywords],14,;),people,8),replace(listitem([keywords],14,;),!People\,),),if(isequal(listitem([keywords],15,;),people,8),replace(listitem([keywords],15,;),!People\,),),if(isequal(listitem([keywords],16,;),people,8),replace(listitem([keywords],16,;),!People\,),),if(isequal(listitem([keywords],17,;),people,8),replace(listitem([keywords],17,;),!People\,),),if(isequal(listitem([keywords],18,;),people,8),replace(listitem([keywords],18,;),!People\,),))&datatype=[list]
I set this to Default Search field, type some stuff, and matches shown for (Population) do not return empty results.

Not my most helpful reply ever, I know, but, hey, I tried :) Are there any other clues you can look for, perhaps something in the "Set rules for file display" in the customise view options has something interfering?

Title: Re: Searchbox and calculated fields
Post by: zirum on August 16, 2011, 03:00:20 am

Expression seems to work correctly when used as a pane, selecting one item which has multiple values. Seems like a bug to me.

Title: Re: Searchbox and calculated fields
Post by: Vincent Kars on August 16, 2011, 03:39:31 pm

Tried both a Pane and a Category view.
Rules for file display is of
None works

If I use the Wizard instead of text like
Artist (individual) contain XYZ
then it works