How to use Case Insensitive filter in a Query.

How to use Case Insensitive filter in a Query.

book

Article ID: KB0084537

calendar_today

Updated On:

Products Versions
TIBCO ActiveSpaces -
Not Applicable -

Description

Resolution:

We support upper() command. Here is an example.


============
show space 'mspace' entries filter "upper(tvalue)='VALUe5'"

Show Space Entries:
________________________________________________________________________________
  Show entries for space 'mspace'
      Filter:              upper(tvalue)='VALUe5'
      Distribution Scope:  all
      Time Scope:          time_scope_current
      Query Limit:         10000
      Prefetch:            1
      Browser Size:        -1
      Space Size:          7
      Filtered Space Size: 1
      Browser Init Time:   0ms
--------------------------------------------------------------------------------

  { tvalue : Value5
    tid    : 5
    tid2   : 30
  }

You can use upper(tvalue)=upper('value5') too.

Note that this query will ignore index scan even if you have a proper index created.

Issue/Introduction

How to use Case Insensitive filter in a Query.

Additional Information