Announcement

Collapse
No announcement yet.

Advanced search add option for "Not an Empty Field"

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

    Advanced search add option for "Not an Empty Field"

    Can there be another option added to the Admin side advanced search for "Not an Empty Field" please?

    advanced-search-options.PNG

    ... and if there is an equiv that works right now can somebody please tell me?
    EX: "Not Like" and an empty field going along with it is not the answer. I've tested some of this stuff.
    Colin Puttick
    Miva Web Developer @ Glendale Designs

    #2
    Hi Colin -

    You should be able to use the Contains option and then for the value put an underscore. This is wildcard in mysql for any character.
    • The percentage ( % ) wildcard matches any string of zero or more characters.
    • The underscore ( _ ) wildcard matches any single character.
    Brennan Heyde
    VP Product
    Miva, Inc.
    [email protected]
    https://www.miva.com

    Comment


      #3
      Originally posted by Brennan View Post
      Hi Colin -

      You should be able to use the Contains option and then for the value put an underscore. This is wildcard in mysql for any character.
      • The percentage ( % ) wildcard matches any string of zero or more characters.
      • The underscore ( _ ) wildcard matches any single character.
      Wow, learn something new every day. It might be a good idea to include that tip somewhere within the application as a tool tip.

      While on this subject, how does Advance Search "* (Comma Separated List)" works? I've never been able to make it work.

      Thank you, Bill Davis

      Comment

      Working...
      X