Question

Null value in workflow filter

  • 11 April 2023
  • 3 replies
  • 176 views

Badge +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

Userlevel 3
Badge +10
  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?
Badge +1

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

Userlevel 3
Badge +10

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

Reply