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

    Hi  , can you try the following:

    !=null

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

       

       

      did not work either

      • Nick
      • 1 mth ago
      • Reported - view

       ,

      The solution mentioned by the   works fine.

      • szormpas
      • 1 mth 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 mth 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 mth ago
      • Reported - view

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

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

       

      Done!

      Thanks

Login to reply

Content aside

  • Status Answered
  • 1 mth agoLast active
  • 7Replies
  • 36Views
  • 3 Following