INTERACT FORUM
More => Old Versions => Media Center 14 (Development Ended) => Topic started by: lise on February 04, 2010, 11:12:35 am
-
I have a gazillion smartlists that search for X in keywords, but now I want to modify them to also search for x in the [filename (name)] (tagging all my documents is proving to be too time consuming so searching for filename as well would be very useful and more accurate).
I've just been going at it manually when it occured to me that maybe I can create a custom calculated field that basically says: keywords OR filename (name). Then I can modify my smartlists to search that custom field. I'm not sure the combine list expression would work, because I need it to be an "or", and obviously filename (name) isn't a list.
Example of what I need: search for "plywood" in keywords OR in filename (name)
Any gurus out there have something similar?
-
is this what you want?
([Keywords]="plywood" or [Filename (name)]="plywood")
:)
gab
-
That's what I currently use in that particular smartlist.
This particular (very large) set of smartlists search keywords. Now I want them ato also search filename (name).
Rather than modify my gazillion smartlists to also include the filename in the search, I thought: what if I had a calculated field that included both those fields. Then I just have to modify my smartlists to say:
"NewCalculatedField" contains "plywood".
The beauty there is that if I change my mind about the fields I want to search I can just modify the calculated field to remove/include another field in it's expression, rather than modify all my smartlists.
-
oke, misunderstood you... why dont you just put them after eachother then, the new calculated field could be
[keywords];[filename (name)]
when you use 'contains' to search, it should work.
and when you would make the calculated field a defauls search field in the options you could even just type in plywood in the search.
:)
gab
-
"ListCombine" appears to work just fine too. Make a new library field using: listcombine([keywords],[filename (name)])
-
gappie: Goodness, it works! I didn't know that you could just add fields with a ; in between them like that. I figured it would have to be some complicated expression with a command of sorts! This is wonderful.
Marko, is there a difference between using listcombine and just [keywords];[filename (name)]?
And finally, one last thing that would make my life easier. Is there a way to use "or" in a smartlist that doesn't include having to add the field for each "or"? I seem to recall in the old days being able to type something like:
[keywords]=("plywood", "pine", "oak") rather than
([keywords]="plywood" or [keywords]="pine" or [keywords]="oak")
-
Ah, I think I have it.
I was using [keywords]="plywood" or "pine" or "oak" and also tried [keywords]="plywood", "pine", "oak" with and without parenthesis, when the answer is:
[keywords]="plywood","pine","oak" with no spaces between the commas.
Excellent.
-
i guess you could say that the listcombine expression is more hygienic, the result is cleaner.
say you have no keywords. with just the ; you could get:
;plywood factory.jpg
with listcombine you get
plywood factory.jpg
:)
gab