Issue when running the custom report

Hi @LohithHarish,

in Reports tab you find the templates, yours or default of SP. Every time you want launch it, you must create a report and it will be created in My Report tab. According with permision, this report is only yours or avaible for all users.

Later, you can use this report for schedule or execution, with the configuration made at the time of creation, but you can change it in second time. Also, if you change the template, you will change all the report correlated with the template.

The simplest way for change a column is the RenderScript, where you can change the result value of the column.
Example:

<ReportColumnConfig field="identity" header="Name;" property="l" sortable="true" width="80">
                <RenderScript>
                  <Source>
                    import sailpoint.object.Link;
                    try{          
                      Link l = value;
                      l.getIdentity().getName();
                      if (l.getApplication().getName().equals("ACTIVE DIRECTORY")){
                          Integer obj =  Integer.parseInt(l.getIdentity().getAttribute("StatusAD"));
                            if ((obj / 2) % 2 == 0)
                            {
                              return "Active";
                            }
                            else
                            {
                              return "Inactive";
                            }
                          }
                      }
                      return l.getIdentity().getName();
                    }
                    catch(Exception e){                  
                      return null;
                    }
                   </Source>
                </RenderScript>
              </ReportColumnConfig>

whit this you can add code, reading a custom or put a fixed value a return it.

You can see this topic too, maybe can help you:

1 Like