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 1428 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: 9139
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?

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