Modifying Access Review Search Filter for Case-Insensitive and Keyword Searches

IdentityIQ (IIQ) IIQ Discussion and Questions
, ,
1

Which IIQ version are you inquiring about?

Version 8.3

Please share any images or screenshots, if relevant.

Captura de pantalla 2024-01-26 171503.png
Captura de pantalla 2024-01-26 171503.png1919×727 37.7 KB

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

Hello experts and community members, I hope you are all doing well.

I have a specific requirement to modify the search filter for the Access Review to make it case-insensitive and allow keyword searches. In order to do this, and based on a post from the Compass Community, I’ve checked the .hbm files and noticed that the attributes I intend to use for filtering have an index ending with “_ci.”

Additionally, I’ve checked the System Configuration object and attempted to modify a “SearchInputDefinition” to include “matchMode=“ANYWHERE”,” but unfortunately, that didn’t yield the desired results.

If anyone has insights on how I can achieve this or suggestions on where else I can look to make this change, it would greatly assist me.

Thank you so much in advance for your time and assistance.

2

Can you share the link of compass here ?

3

Sure! Here’s the link: How to change case sensitivity for identity search - Compass.
As I mentioned, I checked the attributes, and they have the ‘_ci’ index. However, I’m unable to perform case-insensitive searching for all the attributes available in the filter.

4

Hi @maria_hernandez,

Did you ran the task ‘Full Text Index Refresh’ after you set the SearchInputDefinition ?

Not sure if it will help, but worth to try :stuck_out_tongue_winking_eye:

– Remold

1 Like
5

Another option would be to add ignoreCase="true" on the SearchInputDefinition element.

For example:

<SearchInputDefinition description="srch_input_def_last_name" headerKey="srch_input_def_last_name" ignoreCase="true" inputType="Like" matchMode="START" name="lastName" propertyName="lastname" propertyType="String" searchType="Identity"/>

– Remold

1 Like
6

Hi @Remold ,

Thanks for the options.

I ran the task, but I didn’t see any changes in the behavior of the filter.

I also check the ignoreCase="true" on the SearchInputDefinition element, and it’s already there. The thing is, for identity attributes (like LastName or fullName), it works fine, but I need it to work for account attributes as well (like applicationName).

So, for example, this one has the ignoreCase, but in that Access Review filter, the case-insensitive feature is still not working.

<SearchInputDefinition description="srch_input_def_application" filterBuilder="sailpoint.search.ApplicationFilterBuilder" headerKey="application" ignoreCase="true" inputType="Like" matchMode="ANYWHERE" name="certification.application" propertyName="Application.name" propertyType="String" searchType="Certification"/>

Thank you again for your time and help. I would really appreciate any other suggestions.

8

when you say “account attributes as well”, that means you have to see the option like “Account Properties” in that filter.

If you need to search based on account properties then you have to make it searchable in Link attribute.

Check entry in ObjectConfig = Link , there should be some extendedNumber added for that field like extendedNumber=""6".

in LinkExtended.hbm.xml - we need to enable it and make it like below

<property name="extended6" type="string" length="450" index="spt_link_extended6_ci"/>

Need to generate the schema again and make changes in DB.

Pls correct if i misunderstood. pls stay connected if need more help.

9

Hi @maria_hernandez did you get chance ?

10

Hi @pravin_ranjan ,

Thank you so much for your response.

I already did all those steps before, that’s why I asked about any other possible options to modify the behavior of that filter.

11

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