query search case insensitive

berhei — Thu, 05 Jun 2025 05:06:20 GMT

Hello (again)

if you use a query as userinput you can search the list "as you type". Is there a way to make this search case insensitive?

Best regards

berhei

Re: query search case insensitive

trentino123 — Wed, 11 Feb 2015 18:29:53 GMT

sure, if you are talking about a query in SQL. my suggestion is bring to lowercase your user input and also the data you are looking for.

this is an example AND LOWER(igroup.name) LIKE LOWER('%${vmware_cluster}%') :

SELECT
    DISTINCT aggregate.name AS 'name',
    vserver.name AS 'vserver.name',
    cluster.primary_address AS 'node.cluster.primary_address' ,
    node.name AS 'node.name',
    cluster.id AS 'cluster.id'
FROM
    cm_storage.vserver vserver,
    cm_storage.igroup igroup,
    cm_storage.cluster cluster,
    cm_storage.aggregate,
    cm_storage.node
WHERE
    igroup.vserver_id = vserver.id
    AND LOWER(igroup.name) LIKE LOWER('%${vmware_cluster}%')

    AND vserver.is_repository IS NOT TRUE
    AND (
        vserver.type = 'cluster'
        OR vserver.type = 'data'
    )
    AND vserver.cluster_id = node.cluster_id
    AND node.cluster_id = cluster.id
    AND aggregate.name NOT LIKE '%aggr0%'

topic query search case insensitive in Active IQ Unified Manager Discussions

query search case insensitive

Re: query search case insensitive