Customizing the Reports

depends how much customisation you want to achieve...

you can customise a report by running into debug and exporting the base reports out and then editing the XPRESS code. That's an easier way.

There's a more flexible way of customisation which requires complicated Java coding. I'm actually just learning it myself.

new@idm at 2007-7-7 1:13:08 >

> I am glad this subject appeared. I also need to hack

> a Report. The ones the customer finds most useful are

> All Users and Today's activity.

>

> There are 2 levels of need. One is simple the other

> is a bit more complex.

>

> Simple one.

>

> On the User report. There is a default list of

> attributes I can select to display in the report. We

> use an extended attribute employeeId to hold the

> employeeNumber.

>

> Question. How can I add attributes to this list?

>

> More Complex.

>

> There are filters that can be applied, e.g. "Report

> only users whose username starts/contains/equals..

> _"

>

> Question. How can I add a filter that operates on

> lastname rather than accountId?

>

> Is the customisation of Reports documented anywhere?

yeah first one is easy.

1. If it's an extended attribute go to debug mode and list your Task Definition Objects - find UI_REPTS_XML_USER_TITLE - make sure to make a copy of it - or make a copy and edit the copy and make a new Base Report all together (what I would recommend).

2. Once you've exported UI_REPTS_XML_USER_TITLE - look for

<defvar name='attrMap'>

<Map>

<MapEntry key='accountId' value='UI_REPTS_XML_REPORT_ATTR_ACCOUNTID'/>

<MapEntry key='attributes.employeeId' value='Employee ID'/>

<MapEntry key='disabled' value='UI_ATTR_DISABLED'/>

<MapEntry key='email' value='UI_ATTR_EMAIL'/>

<MapEntry key='locked' value='UI_ATTR_LOCKED'/>

<MapEntry key='organization' value='UI_ATTR_ORGANIZATION'/>

<MapEntry key='passwordExpiry' value='UI_ATTR_PASSWORDEXPIRY'/>

<MapEntry key='resources' value='UI_ATTR_USER_RESOURCES'/>

<MapEntry key='role' value='UI_ATTR_ROLE'/>

</Map>

</defvar>

notice in my code block i have added attributes.employeeId - that is all you need to do so long as it is an extended attribute.

Applying an extended attribute filter:

1. To filter on last names you will have to go to Debug mode and list Configuration Objects - export UserUIConfig. Make a copy before you edit it.

2. Find

<QueryableAttrNames>

<List>

<String>MemberObjectGroups</String>

<String>terminationDate</String>

<String>employeeId</String> <!-- added this field -->

<String>managerId</String>

<String>commencementDate</String>

</List>

</QueryableAttrNames>

Queryable Attributes seem to only allow 5 fields - so choose wisely. I would put my extended attributes in all the other AttrName lists. Most of them are self explanatory.

3. You might have to reload your users once you've changed this file because previous users will still remain unquerable from this field.

4. Edit your Base Report again - just hack away at one of the existing fields - should be easy enough I think

Note: If you did create a new version of UI_REPTS_XML_USER_TITLE make sure you create a new report thru the report gui selecting the new base report you've just created/hacked.

new@idm at 2007-7-7 1:13:08 >

hello,

try some thing like this call:

<invoke name='getUnassignedResources' class='com.waveset.ui.FormUtil'>

<ref>:display.session</ref>

<ref>waveset.role</ref>

<ref>waveset.original.resources</ref>

</invoke>

Check the other methods of 'com.waveset.ui.FormUtil' on the 'IDM Technical Deployment.pdf' file

greetings,

dieraven2003 at 2007-7-7 1:13:08 >

Hi dieraven2003,

I have a question for you. Can you please let me know the answer to the earliest.

How can we have a report tht generates:

Drop down Number 1 will have all resources and Drop down Number 3 will have all the resources and Drop down Number 2 which will be in between the drop down's 1 and 3 , which will have values "IN" and "NOTIN" . Based On the selection from these 3 drop downs, the report should display the result.

example dropdown1dropdown2dropdown3

Users having account in ADNOT IN LDAP

LDAPINAD

How can I generate such a report?

idm_quest at 2007-7-7 1:13:08 >