Solved

Search for empty date?

  • 13 December 2022
  • 2 replies
  • 136 views

Userlevel 1
Badge +2
  • Sidekick (Customer)
  • 5 replies

Good day,

 

Is it possible to do an Item Search on a custom field in assyst, using the Item Monitor, to find Items that do not have a date specified? A search with a blank date returns an error, which leads me to wonder if this search should normally work.

 

assyst Version: assyst 11.4.1
Build: 12405 Date built: 07 February 2022 06:15:33

 

 

Thanks,

…Donovan

icon

Best answer by Steve Miller 14 December 2022, 13:18

View original

2 replies

Userlevel 4
Badge +12

Hi Donovan,

I have not found a way of searching on null values because the system takes a blank search field as ‘any value’. This might be a product enhancement suggestion.

Perhaps a scheduled report or SQL query would a suitable workaround?

 

 

Badge

Hello IFS
we also need the search for empty fields again and again.

Please add this in the new product!

Regards
Marion

Reply