'SM 7.01: Contains' operand in search filter is not case insensitive

  • KM634821
  • 01-Apr-2009
  • 13-Jun-2011

Archived Content: This information is no longer maintained and is provided "as is" for your convenience.

Summary

In SM7.X'Case insensitivity' is not working with 'Advanced Filter' selections. The system still behaves as 'case sensitive', even though the SQL database, the incidents dbdict and the company record all show case insensitive. QCR32062 was opened to address this issue.

Question

'Case insensitivity' is not working with 'Advanced Filter' selections. The system still behaves as 'case sensitive', even though the SQL database, the incidents dbdict and the company record all show case insensitive.  Attached is a trace of the issue. The query shows:

Returned recs:

5604( 4272) 03/30/2009 09:41:09 RTE D DBQUERY^F^incidents(SQL Server I)^7^0.000000^P^21^0.422000^"index("BOB", contact.name)>0"^ ^0.000000^0.000000 ( [ 1] cc.search select )

5604( 4272) 03/30/2009 09:41:09 RTE D (0x093173B0) DBACCESS - Select against file incidents in 0.422000 seconds

5604( 4272) 03/30/2009 09:41:09 RTE D RADTRACE 516 [ 1] cc.search many.records process CPU( 234 10562 )

Returns no recs:

5604( 4272) 03/30/2009 09:41:24 RTE D DBQUERY^F^incidents(SQL Server I)^7^0.000000^P^0^0.610000^"index("bob", contact.name)>0"^ ^0.000000^0.000000 ( [ 1] cc.search select )

5604( 4272) 03/30/2009 09:41:24 RTE D (0x093173B0) DBACCESS - Select against file incidents in 0.610000 seconds

5604( 4272) 03/30/2009 09:41:24 RTE D RADTRACE 641 [ 1] cc.search no.records.msg msg

 If I use the Microsoft query tool and change the query to:

select INCIDENT_ID, CONTACT_NAME from dbo.incidentsm1 where CONTACT_NAME like '%bob%'

it will work fine

The query shows up as a 1=1 against the database.

STEPS TO REPRODUCE:

1. Setup SQL server 2005 as case insensitive.

2. Setup SM7.02 as case insensitve on the SQL server, so the company record reads 'Case Insensitive'.

3. Login with falcon. Both (eclipse and webtier can replicate)

4. Go to Search Interactions.

5. Go to the Advanced Filter tab

6. Select Add New Filter Criteria

7. In the ‘Field In Interaction’ field, select “Contact Name”.

8. In the ‘Comparison’ field, select “Contains”

9. In the ‘Value’ field, input “bob”. Make sure to input this as written and in lower case.

10. Click ‘Next’ at the bottom of the screen.

11. Click ‘Search’ at the top of the screen

You will get no records found. If you repeat the steps again with "BOB" as the value in step 9, you will return 2 records.

Answer

QCCR1E32062