User extended attributes and repository
Hi,
Here is my case :
I want to make custom report, sent by mail monthly, and I need to make query on several attributes.
So, I extended IDM user attributes, with org, manager, services and endDate.
Then, I created a new taskdefinition based on UI_REPTS_XML_USER_TITLE (UserReportTask).
I saw that my new attribute, org, has been added to the userAttr table, such as this :
id : (idmID)
attrname : ORG
attrVal : myOrgValue
These attributes reference user object on the repository, and are set when I create new user or I make a reconciliation on new user.
But only 'org' is added to the table. manager, services and endDate are not present in my userattr table...
First question :Anybody has extended user attributes, and notice that not all attributes are store in the userattr table ? (select distinct attrname from userattr;
to see attributes stored in sql repository)
I need to make query for my custom report in the taskdefinition file.
Here is the syntax for query on one attribute (here, 'o' attributes):
<Field name='queryAttr.o.enabled'>
<Display class='Checkbox'/>
<Default>
<s>true</s>
</Default>
</Field>
<Field name='queryAttr.o.useId'>
<Default>
<s>false</s>
</Default>
</Field>
<Field name='queryAttr.o.operator'>
<Default>
<s>isOneOf</s>
</Default>
</Field>
<Field name='queryAttr.o.value'>
<Display class='MultiSelect'>
<Property name='noNewRow' value='true'/>
<Property name='title' value='WP_REPORT_USER_WITH_ETABLISSEMENT_BANCAIRE'/>
<Property name='allowedValues'>
<rule name='GIECB Library:getIDMGroupeBancaireOrg'/>
</Property>
<Property name='sorted' value='true'/>
</Display>
</Field>
Second question:Anyone know how to make a query on resource attribute, like ldap, in order to filter on these attribute ?
Subsidiary question : Taskdefinition:UI_REPTS_XML_USER_TITLE is not directly editable in BPE. I have to edit in a notepad like editor. Is it the same for you ?
Thanks.
