Skip to main content
Solved

Search for empty date?

  • December 13, 2022
  • 2 replies
  • 215 views

dlong
Sidekick (Customer)
Forum|alt.badge.img+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

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?

 

 

View original

2 replies

Forum|alt.badge.img+12
  • Hero (Customer)
  • 141 replies
  • 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)
  • 5 replies
  • 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


Reply


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings