INTERACT FORUM

Please login or register.

Login with username, password and session length
Advanced search  
Pages: [1]   Go Down

Author Topic: Searchbox and calculated fields  (Read 1496 times)

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Searchbox and calculated fields
« 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.
Logged

marko

  • MC Beta Team
  • Citizen of the Universe
  • *****
  • Posts: 9220
Re: Searchbox and calculated fields
« Reply #1 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?

Logged

Some alternative skins are here | Import Stats on Steroids | Middle click the close button=One of the neatest things added to MC in a long time

zirum

  • Galactic Citizen
  • ****
  • Posts: 403
  • still learning.
Re: Searchbox and calculated fields
« Reply #2 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.
Logged
Note to myself: Read, think, write - Read, think, write - think, read, write - think, write, read - think, write, read... Aahhw, i always mess that up...

Vincent Kars

  • Citizen of the Universe
  • *****
  • Posts: 1154
Re: Searchbox and calculated fields
« Reply #3 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
Logged
Pages: [1]   Go Up