• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Filter logic
#1
I'm using a "custom" field to contain one of two values indicating if the edit for that song is either "complete" or "incomplete". When I filter my song list to serge the custom field for "incomplete" it works fine. When I set the filter to "complete" it returns all songs since the string "complete" is included in both values. How do I chaage the filter logic to look for the exact value of the field rather than any occurrence of the string in the field"

Thanks and regards
Michael Bond
Reply
#2
Don't know (Mike will be along)
Not sure if there is an easy way to do this - I like having partial matching in the key fields

Consider using "partial" instead of "incomplete" ?

Geoff
Samsung Galaxy Tab A6
Reply
#3
MobileSheets just searches for occurrences of the search term anywhere in the formatted song title. The word "complete" is inside "incomplete", so that's going to be a problem. Just use two different words or something like isComplete, isIncomplete, and then you shouldn't have an issue. In the future, I may add an option to specify that the entire search term has to match the value in a given field, as well as options to match on punctuation and capitalization (both are currently ignored).

Mike
Reply
#4
better add "complete" and "incomplete" to the value list of "source types"
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#5
itsme is also correct - if you want to use a field like source type, you can just filter using the source dropdown. 

Mike
Reply




Users browsing this thread:
2 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.