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.
Discussion posts and replies are publicly visible
Did you try an XOR node and an isnull() check as the condition?
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().
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.
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.
Again, why not make the user select whether to add a previous employee. Then you know whether you expect data and write the entry to DB.
A form without any mandatory fields is also pretty pointless IMHO.
Another option is to have a boolean rule input which is set to true in case one of the fields of the previous employee is modified. Then use that to control the flow in process.
© 2021 Appian. All rights reserved.