Skip to main content
Solved

Search for empty date?

  • December 13, 2022
  • 2 replies
  • 236 views

dlong
Sidekick (Customer)
Forum|alt.badge.img+2

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

Best answer by Steve Miller

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?

 

 

2 replies

Forum|alt.badge.img+12
  • Hero (Customer)
  • Answer
  • December 14, 2022

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?

 

 


Forum|alt.badge.img
  • Do Gooder (Customer)
  • December 20, 2022

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

Please add this in the new product!

Regards
Marion