Unable to pull identities in filter for quick link form

[Hramirezgonzalez (Heriberto Ramirez)]

Which IIQ version are you inquiring about?

8.3p1

import sailpoint.object.Filter;				
import sailpoint.object.Field;				
				
Field f = form.getField("UserIdentity");				
				
Filter filter1 = Filter.or(Filter.eq("EmployeeType","EMP"),Filter.eq("EmployeeType","CWR"));
Filter filter2 = Filter.and(Filter.ne("WorkflowCompleted","SuspensionCompleted"),Filter.ne("WorkflowCompleted", "Quiet Suspension"),Filter.ne("WorkflowCompleted", "LOA Completed"),Filter.ne("WorkflowCompleted", "Inactive90Days"));
Filter filter3 = Filter.ne("JobCode", "9990");				
Filter filter = Filter.and(filter1,filter2,filter3);				
f.setFilterString(filter.toString());

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

I am trying to pull all identities into a form with these filters set. A problem that I am running into is that there are identities that don’t have a line containing “WorkflowCompleted”. Is there a SailPoint method such as exists() to include in my filters? I’ve attempted using isnull() from the filter class however that would require that the “WorkflowCompleted” line exists in the identity object.

[pravin_ranjan (Kumar Ranjan)]

@Hramirezgonzalez

WorkflowCompleted

why identity should have WorkflowCompleted line ? can u give your requirement ? if you need to show identity then you can simply add filter that is correlated = true

You will get examples in identitySelector configuration file.

[Hramirezgonzalez (Heriberto Ramirez)]

The reason I wanted to pull identities based off of this attribute is because I want to filter out the identities that are currently already in suspension, or meet any of the criteria in filter2. This logic will be implemented to pull a list of identities into a suspension form where we can choose employees that need to be suspended.

[SanjeevIAM (Sanjeev Kumar)]

Assuming WorkflowCompleted is a searchable attribute on Identity object the following filter should work fine to pull all identities that do not have WorkflowCompleted attribute set.

Filter filter2 = Filter.isnull(“WorkflowCompleted”);