Skip to main content
Nintex Community Menu Bar
Question

Null value in workflow filter

  • April 11, 2023
  • 3 replies
  • 290 views
  • Translate
S
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

Did this topic help you find an answer to your question?

T
Nintex Employee
Forum|alt.badge.img+10
  • TinTexNintex Employee
  • 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?
Translate
S
Forum|alt.badge.img+1
  • sireland
  • 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

Translate
T
Nintex Employee
Forum|alt.badge.img+10
  • TinTexNintex Employee
  • 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.

Translate

Reply


Sidebar Buttons
Nintex Community Home Contact Nintex Support Email Nintex Community Check Nintex Status
Terms & ConditionsCookie Settings

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