Effective December 3, NetApp adopts Microsoft’s Business-to-Customer (B2C) identity management to simplify and provide secure access to NetApp resources.
For accounts that did not pre-register (prior to Dec 3), access to your NetApp data may take up to 1 hour as your legacy NSS ID is synchronized to the new B2C identity.
To learn more, read the FAQ and watch the video.
Need assistance? Complete this form and select “Registration Issue” as the Feedback Category.

Active IQ Unified Manager Discussions

query search case insensitive

berhei

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

1 ACCEPTED SOLUTION

trentino123

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%'

View solution in original post

1 REPLY 1

trentino123

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%'

View solution in original post

Announcements
NetApp on Discord Image

We're on Discord, are you?

Live Chat, Watch Parties, and More!

Explore Banner

Meet Explore, NetApp’s digital sales platform

Engage digitally throughout the sales process, from product discovery to configuration, and handle all your post-purchase needs.

NetApp Insights to Action
I2A Banner
Public