fnfilter on alphanumeric column

fnfilter on alphanumeric column

doug_hale_jrdoug_hale_jr Posts: 22Questions: 0Answers: 0
edited April 2009 in General
My column contains either "TBD", "1","2", or "3". When I set fnFilter = "TBD" it filters fine. When I set fnFilter = "1", it ignores me. Does anyone know what's happening?

Thanks
Doug

Replies

  • allanallan Posts: 63,205Questions: 1Answers: 10,415 Site admin
    Hi Doug,

    Does the table contain "1" in the rows which do not have 1 in this column (including in the html)? Remember that this is a global search, so if "1" occurs anywhere in a single row, then it will be classed as matching. You could use individual column filtering if you wish.

    Allan
  • doug_hale_jrdoug_hale_jr Posts: 22Questions: 0Answers: 0
    Allan,

    You are brilliant! I knew the search was global but it didn't sink in my brain that the other columns DO contain a "1". I will use the individual column sorting like you said.

    Thanks
    Doug
This discussion has been closed.