Rule to create workitem is creating duplicate workitems

Which IIQ version are you inquiring about?

8.4p1

Share all details about your problem, including any error messages you may have received.

*I have a rule that based on a search filter calls a workflow to create workitems for revoked certification items.This is my search filter.

qo.addFilter(Filter.and(Filter.eq("status", "Remediated"), Filter.isnull("workItem"), Filter.isnull("comments"), Filter.eq("decisionCertificationId", cert.getId())));
List certificationActions = context.getObjects(CertificationAction.class, qo);

The problem is , if I dont remove the “Filter.isnull(“comments”)” it wont detect auto revoked items since it already has a comment “auto revoked due to non action”.
If I remove it, the rule creates duplicate work items. I have attached the whole rule.
Any solution to this problem? Id appreciate it.
RULE.XML (7.3 KB)

Hi @dk0200

can you try with isempty:
Filter.isempty("comments")

hello,

wouldn’t it be the same thing? since comments is not empty for auto revoked items