case sensitivity in finders

[stephen2]

All, I am looking to find and select vfilers by name where the customer has mixed upper and lower case vfiler names.  For example, they have the following:

vfiler_pdc_a

vfiler_PDC_B

vfiler_DR_A

vfiler_dr_B

is there an ignore case type of function, or some cobinations of functions that will allow me to return the vfiler if it matches the letters, regardless of case?

Thanks

[tanzim]

Hi Stephen,

What you're looking for can definitely be done.

Clone the filter "Filter vFilers by name in array" and modify the SQL query to case the column name and string, in your case it is the vfiler name.

Basically, you can modify this line in the filter query -

     AND vfiler.name = '${vfiler_name}' 

to,

     AND upper(vfiler.name) = upper('${vfiler_name}')

You can now use this filter for case insensitive vfiler name matching.

Regards,

Tanzim