0

selecting rows on a table using header column filter

I have a table with a few columns and one named MAG that contains text.

Some rows in this column are empty.

I want to show in the tabular view of this table only the rows that have the MAG column filled.

I've tried in the filter box in the column header the following code:

MAG != ""

or

MAG is not empty

 

Both of these options retrieve no records.

How can I select the records containing text in MAG?

7 replies

null
    • szormpas
    • 1 yr ago
    • Reported - view

    Hi  , can you try the following:

    !=null

      • JGM
      • Jose_Monteiro
      • 1 yr ago
      • Reported - view

       

       

      did not work either

      • Nick
      • 1 yr ago
      • Reported - view

       ,

      The solution mentioned by the   works fine.

      • szormpas
      • 1 yr ago
      • Reported - view

       , 

      I have tested it, and it works for me.

      Have you put the above condition into the Filter box and omit the "MAG" name?

      See the screenshot below.

      • JGM
      • Jose_Monteiro
      • 1 yr ago
      • Reported - view

       

      I've tried now without the MAG column name in the filter box and it works fine, that is:

      != null

      Thank you for your help.

      • szormpas
      • 1 yr ago
      • Reported - view

       glad it works for you. Could you please mark the post as answered, thanks.

      • JGM
      • Jose_Monteiro
      • 1 yr ago
      • Reported - view

       

      Done!

      Thanks

Login to reply

Content aside

  • Status Answered
  • 1 yr agoLast active
  • 7Replies
  • 66Views
  • 3 Following