Skip to main content
Nintex Community Menu Bar
Question

Null value in workflow filter

  • Apr 11, 2023 7:28 PM UTC
  • 3 replies
  • 443 views
  • Translate All

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
  • Apr 11, 2023 9:33 PM UTC
  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?
Translate

Forum|alt.badge.img+1
  • Author
  • Rookie
  • Apr 12, 2023 5:34 PM UTC

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

Translate

Forum|alt.badge.img+11
  • Nintex Employee
  • Jun 6, 2023 3:35 PM UTC

@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.

Translate