Skip to main content
Nintex Community Menu Bar
Question

Null value in workflow filter

  • April 11, 2023
  • 3 replies
  • 366 views

Forum|alt.badge.img+1

Hello,

I have a Workflow where I’m filtering on a Table (SmartObject) and I want to return records with an empty column A (i.e. inactive date is null).

There is no IS NULL option when done in K2 Designer Workflow.

I tried Filter Name = Empty String (from the Text expression section) but this did not work.

  • Leaving blank does not work
  • Using Empty String from Text functions does not work
  • Using an Empty Variable does not work
  • Adding the Empty String to the Variable does not work

How do I pass a null value in the filter?

Thanks

3 replies

Forum|alt.badge.img+11
  • Nintex Employee
  • April 11, 2023
  1.  What is the SmartObject Property data type?
  2. Is this a SmartBox, SQL, SharePoint SmartObject?  What is the data type on the LOB system?
  3. Have you tried with the string scnull to see if it behaves any differently?

Forum|alt.badge.img+1
  • Author
  • Rookie
  • April 12, 2023

Thanks for the response.

  1. The data type is DATE.
  2. This is an SQL (Oracle) SmartObject.   
  3. I have not tried SCNULL.  Will it work with a DATE column?

Sean


Forum|alt.badge.img+11
  • Nintex Employee
  • June 6, 2023

@sireland 

Currently I don’t have an Oracle instance to test, but I would assume it should work.  I did test with Smartbox, which is SQL table and passing in ‘scnull’ to the SmartObject layer does pass ‘Null’ to the SQL table layer.