Identity Search - How to change case sensitivity

  • 7011126
  • 04-Feb-2011
  • 02-Nov-2012

Environment

NetIQ Access Governance Suite

Situation

Instructions for changing the case sensitivity of extended attributes.

Resolution

Most searches are supposed to be case insensitive.  If you need case insensitive searches on extended attributes, then you need to define indexes for them in the extended attribute mapping file (IdentityExtended.hbm.xml, LinkExtended.hbm.xml, etc. and specify an index that ends with "_ci".  

 
 For example from IdentityExtended.hbm.xml:
    <property name="extended6" type="string" length="450"
              index="spt_identity_extended6_ci"/>
 And then regenerate the schema. 

In order to do this you must first extract the *.hbm.xml files from the identitiyiq.jar files in the WEB-INF/lib directory. After your edits are complete you can place these files in the same folder structure under the WEB-INF/classes directory and your custom mappings will override the ones in identityiq.jar.