8 Replies Latest reply on Sep 2, 2019 3:00 AM by Nathalie Obadia

Criteria case sensitive in Queries

Andrey Gabriel Jul 31, 2019 5:16 AM

Share This:

Bonjour a toutes et tous,

I found in Querie's criterias a very nice effect

Using the operator 'Contains' or 'Start with' for selecting the right OS for devices. But it would be ok if I did not try to select Mac OS ...

Using the find tool

it is case un-sensitiv

But in the query

in lower case I get as result:

in capital letter for the value

What is bother me it is that I do not have the same result in the find tool and the query

it is a bug ?

best regards

Gabriel

1. Re: Criteria case sensitive in Queries

Dominik Kress Jul 31, 2019 8:38 AM (in response to Andrey Gabriel)

Hi Andrey,

Which Database do you use? I've seen this when Postgres is used as DB. My guess would be wrong configuration of your DB. So when your DB is case sensitive BCM will also be case sensitive.

Edit:

Screenshot query:

Screenshot preview:
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
2. Re: Criteria case sensitive in Queries

Andrey Gabriel Jul 31, 2019 8:52 AM (in response to Dominik Kress)

Bonjour Dominik,

It's Oracle, but good tip .. Il will check with the DB master !

Thanks
Like Show 1 Likes(1)

Actions
3. Re: Criteria case sensitive in Queries

Dominik Kress Jul 31, 2019 9:05 AM (in response to Andrey Gabriel)

Hi Andrey,

If your DB master find the setting to switch from case sensitive to case insensitive it would be great to update the discussion with your solution.
1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
4. Re: Criteria case sensitive in Queries

Andrey Gabriel Aug 5, 2019 3:36 AM (in response to Dominik Kress)
Bonjour Dominik Kress,

Yes the records in the DB are in upper/lower case, so not a good solution to modify on the DB.

I can make Free Queries, but then, as I could not mix regular and free queries I have to choose a solution between:

Using like(SQL) operator with %ac%OS% and hope that Apple will not change theire way gto name theire OS
Changing all the queries which need an UPPER (tables.objectname) Like N'something' to be case unsensitiv (hard way for maintening)
Ask to BMC to have theire 'Contain' operator acting as it is in the Find tool
Like Show 0 Likes(0)

Actions
5. Re: Criteria case sensitive in Queries

Andrey Gabriel Aug 5, 2019 3:28 AM (in response to Andrey Gabriel)

I feel it's acting like that

Where          operator      value
Find Tool     contains      UPPER (Table.ObjectName) LIKE N'something'
Query          contains      Table.ObjectName LIKE N'something'
Like Show 0 Likes(0)

Actions
6. Re: Criteria case sensitive in Queries

Dominik Kress Aug 5, 2019 4:19 AM (in response to Andrey Gabriel)

Hi Andrey,

I would not wait until BMC does change it. This may could take a while. You should consider to contact tech support or your support partner to get the DB requirements and with this your DB admin is able to verify if everything is configured correct.

just an extract from another source:
Oracle databases are by default configured as case sensitive. Version 10gR2 added a new feature to its NLS (National Language Support) that allows to do case-insensitive sorts and comparisons altering the session settings.
This can be done changing the value of two NLS parameters, NLS_SORT and NLS_COMP.

Regards,
Dominik

1 of 1 people found this helpful
Like Show 0 Likes(0)

Actions
7. Re: Criteria case sensitive in Queries

Andrey Gabriel Aug 27, 2019 7:27 AM (in response to black iyto)

Sorry for late answer

Oracle DB 10gR2
Like Show 0 Likes(0)

Actions
8. Re: Criteria case sensitive in Queries

Nathalie Obadia Sep 2, 2019 3:00 AM (in response to Andrey Gabriel)

Hi Audrey,

There is an Administrator Preference: Miscellaneous/Advanced Search Case Sensitive
We apply this preference for criterion values.

Nathalie
Like Show 1 Likes(1)

Actions