Skip to main content
November 30, 2021
Question

Where and how I can check whether CDT is empty or not.

  • November 30, 2021
  • 5 replies
  • 0 views

Hi,

I have defined the below process model and an interface with milestone.

I don't have any mandatory fields inside the "Previous Employment" tab (form), but still by current process is creating an empty record inside PreviousEmployment table with an employeeId.

Can someone advise, how can I stop creating an empty record.

Basically, I need to check whether PreviousEmployment CDT is empty or not. Where and how I can do this?

Thanks in advance.

5 replies

stefanhelzle0001
Brainy
December 1, 2021

Did you try an XOR node and an isnull() check as the condition?

stewart.burchell
December 1, 2021

Take care when checking if your CDT is null or not - a CDT that has all of its attributes set to null is not flagged as null when using fn!isnull().

stefanhelzle0001
Brainy
December 1, 2021

Agreed. I would try to solve that in the interface. Why not let the user select whether he wants to add that additional data. If yes, make some of the fields required.

December 4, 2021

None of the fields in the screen/interface tab is non mandatory. Business users may enter or may not enter.

I have used write to multi store entity services to write into multiple tables. So, I am not sure how to fix this.