Assigned date filter in Identity entitlement report

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Version 8.3

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

Hi team,

Can you please suggest, how to add entitlement assigned date as filter in OOTB Identity entitlement report to filter out entitlements assigned to the user before certain date from the report

Thanks,

2

Do the below changes within your form fields add the below field for the date picker

    <Field displayName="Assigned After Date" helpKey="Assigned After Date" name="assignedDate" type="date" value="ref:assignedDate"/>

Within Task Definition add the below Parameter and also at last the argument

        <Parameter argument="assignedDate" property="created">
                  <QueryScript>
                    <Source>
                      import sailpoint.object.Filter;
                      import sailpoint.object.IdentityEntitlement.AggregationState;
                      import sailpoint.tools.Util;

                  		if(value!=null){
                      queryOptions.addFilter(Filter.gt("created", value));    
                      }
                     
                      return queryOptions;
                    </Source>
                  </QueryScript>
                </Parameter>```


Argument changes


<Argument name="assignedDate" type="date">
    <Description>Assigned After Date.</Description>
    <Prompt>assignedDate</Prompt>
  </Argument>```

This should work for you, please test and let me know

In short we are trying to filter the IdentityEntitlement Objects based on the created date.

1 Like
3

The solution provided by @iamksatish will work.
Just a simplification to the Parameter set up. You can use the below line as well.

<Parameter argument="assignedDate" operation="GE" property="created" valueClass="date"/>

As created is a searchanble field in IdentityEntitlement object, we can use operation attribute in the Parameter tag.

hope this helps.

1 Like
4

Thanks all for reply. Given solution worked. Thanks !!

5

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