How do i add another field in Reports layout?

IdentityIQ (IIQ) IIQ Discussion and Questions
,
1

Which IIQ version are you inquiring about?

Version 8.4

Please share any images or screenshots, if relevant.

reports.png
reports.png1704×613 43.4 KB

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

Hi All,

im working on account group members report here i want to add another field in reports layout Is it possible to add another field to the page? If so, could anyone please provide assistance with this?

Thanks
Ranjith

2

Hi Ranjith,
there is a very good guide here: https://community.sailpoint.com/t5/Technical-White-Papers/Reporting-pdf/ta-p/75324
Have a look at page 22, section “ReportForm: Collecting Report-Specific Parameters”
It should clarify almost all of your questions.
Cheers
Steffen

3

Hi @Ranjith2000

Could you provide more details about what report are you working or what colums would you like add in the report.

In this case, you can add QueryParameters in the taskDefinition of the report. QueryParameters is a map of argument values used to createthe queryOptions object that controls the search. They can be specified based on report arguments, hard-coded values, or calculated values.

<QueryParameters>
      <Parameter argument="creationDateStart" operation="GT" property="created"/>
      <Parameter argument="creationDateEnd" operation="LT" property="created"/>
      <Parameter argument="attributeValue" property="attributeValue"/>
</QueryParameters>

Then you should include this inputs in Signature section. The Signature contains a map of Input attributes that name all of the parameters that can be specified for the report.

<Signature>
    <Inputs>
      <Argument name="creationDateStart" type="date">
        <Description>rept_input_cert_report_create_dt_start</Description>
      </Argument>
      <Argument name="creationDateEnd" type="date">
        <Description>rept_input_cert_report_create_dt_end</Description>
      </Argument>
      <Argument name="attributeValue" type="string">
        <Description>attributeValue</Description>
      </Argument>
    </Inputs>
  </Signature>

for more details you can refer to following guide: 8.4 IdentityIQ Reports Guide - Compass

4

Hi @ismaelmoreno1

I can create an additional field in the reports layout for the account group members report. In the first field, I select the application, and in another field, I provide the entitlement Organizational Unit (OU). Based on the selected OU, I aim to retrieve users with corresponding entitlements and generate reports. Is it possible to achieve this ? and does anyone have any ideas on how to accomplish it?

Thanks
Ranjith

5

Hello there,

You can create a new Form and refer it inside the Report(Task Definition XML)
Add fields inside the form
ex:-


6

Hi @Ranjith2000

In your case, you need a custom report.

To retrieve all the accounts associated to Organizational Unit, you will need create a custom report using DataSource criteria.

Please, try with following code, and let me know if it works

 <DataSource objectType="sailpoint.object.Link" type="Filter">
    <QueryParameters>
      <Parameter argument="Application" property="application.id"/>
      <Parameter argument="link" property="identity">
        <QueryScript>
          <Source>

        import sailpoint.object.*;
		import sailpoint.reporting.*;

		Filter links = Filter.like("identity","value",Filter.MatchMode.START);

          if (links!=null && links.isEmpty()) {
			queryOptions.addFilter(links);
			return queryOptions;
		}
      
		</Source>
        </QueryScript>
      </Parameter>

    </QueryParameters>
  </DataSource>
7

Hi @Ranjith2000
You have to create a custom report.
Please refer the whitepaper on reports as suggested in the earlier replies.
Using the initial form fields you take the values then use these form field values as input and run a query in your report by joining tables and get the required output fields that you are after.

8

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