How to filter inactive managers from a dropdown in a form in SailPoint IIQ (IdentityIQ)?

IdentityIQ (IIQ) IIQ Discussion and Questions
1

Hi All,

I have a requirement to filter out “inactive” && whose “managerStatus” equals ‘true’ from the dropdown in a form.

Could you please help me to filter here. I have tried below filterString to filter. But no luck. Please advise.

"filterString=“inactive==false”

Query = (managerStatus == true && inactive == false && identityStatus == “Active”)

Below is the Field.
<Field displayName="Digital Workers ID Owner" filterString="workgroup==false" name="managerID" postBack="true" required="true" type="sailpoint.object.Identity"/>

Regards,
Venu

3

Hi Venugopala,

Are you referring the ‘inactive’ attribute of iiq? if yes, do you want to filter the users that are inactive? and are managers?
Also you mentioned below is the field but looks like you missed to put it. Can you please share the field snippet?

4

Yes correct ‘inactive’ attribute in IIQ. I want to filter “inactive” users and whose “managerStatus” state is false. i.e I need only “Active” managers in the dropdown.

Just like filterString=“workgroup==false” in snapshot.

Capture
Capture1365×77 8.41 KB

Please find the Field attached. Thank you in advance.

5

form
form1321×824 34.7 KB

One more for your reference.

6

keep this code in you allowed value definition of your form

 `import sailpoint.object.Identity;
      import sailpoint.object.QueryOptions;
      import sailpoint.object.Filter;
      import sailpoint.tools.GeneralException;
  		import java.util.Iterator;
  
      List activeManagerList = new ArrayList();
     	QueryOptions qo = new QueryOptions();
      qo.addFilter(Filter.eq("workgroup", false));
    qo.addFilter(Filter.eq("managerStatus", true));
    qo.addFilter(Filter.eq("inactive", false));
      Iterator itr = context.search(Identity.class,qo);
      while((null != itr) &amp;&amp; (itr.hasNext())){
        Identity id = (Identity) itr.next();
        	activeManagerList.add(id);
        
      }
      sailpoint.tools.Util.flushIterator(itr);
      return activeManagerList;`
1 Like
7

Hi @Venu1010,

You can use the below filterString which will filter only active manager.

filterString=“managerStatus == true && inactive == false”

Regards,
Arun

1 Like
8

tried to add filterString=“workgroup==false && inactive == false” but not working.

9

Hi @Venu1010,

Did you try with below filterString?

image
image823×70 1.79 KB

I hope, your requirement is to display only the active manager. correct me, if i am wrong.

Regards,
Arun

10

Yes you are correct.

11

Try with below filterString and let me know the result.

image
image811×52 1.72 KB

Regards,
Arun

12

@Venu1010 Pls try to use identitySelector so you can use same filter at other places also.

13

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.