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
    • 5 mths ago
    • Reported - view

    Hi  , can you try the following:

    !=null

      • JGM
      • Jose_Monteiro
      • 5 mths ago
      • Reported - view

       

       

      did not work either

      • Nick
      • 5 mths ago
      • Reported - view

       ,

      The solution mentioned by the   works fine.

      • szormpas
      • 5 mths 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
      • 5 mths 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
      • 5 mths ago
      • Reported - view

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

      • JGM
      • Jose_Monteiro
      • 5 mths ago
      • Reported - view

       

      Done!

      Thanks

Content aside

  • Status Answered
  • 5 mths agoLast active
  • 7Replies
  • 40Views
  • 3 Following