Skip to main content

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

  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?

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

@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


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings