Filter non-blanks

Lyndon Whyatt

• 2024年01月15日 18:22

I’ve a record picker with one column displayed called ‘name’. However some fields are blank. Is it possible to filter by non-blanks? I tried sort by name but it puts all the blanks at the beginning. I’ve show all records selected but there is no option I can find for non-blanks.

0

• 

  Peter Thane

  ★ BarTender Hero ★

  • 2024年01月15日 23:03

  Have you tried performing a reverse sort on that field in the Database Connection setup screens?

  0
• 

  Lyndon Whyatt

  ★ BarTender Hero ★

  • 2024年01月17日 18:37

  Yes that sort of works though of course my records start Z and work backwards to A followed by the blanks. A bit confusing though!

  0
• 

  Peter Thane

  ★ BarTender Hero ★

  • 2024年01月18日 09:37

  Yes, but <BLANK> comes before A in an alphabetical sort so probably no way round it

  0
• 

  Lyndon Whyatt

  ★ BarTender Hero ★

  • 2024年01月18日 14:56

  Yes, I can’t find a way to stop display empty records in Bartender itself. Would be handy.

  0

請登入寫評論。