When using the all cap terms JOIN, ORDERBY, ORDERBYDESC, GROUPBY, TRENDBY as the value of a filter operator/value pair, the filter does not find the correct records.

If you search for the value "JOIN" in all caps, the matching list returns all records for both normal field value searches as well as text searches, but the lower case search will behave as expected. Other search terms that contain "JOIN" will cause the same behavior ("JOIN", "JOINT", "INNER JOIN" etc).


Steps to Reproduce


  1. Open a list of incidents.
  2. Change the breadcrumbs to be Short description contains JOINT.
  3. Issue the search.
    Notice all records are returned and the breadcrumbs show blank.
  4. Issue a global text search for JOINT.
  5. Perform the same searches for joint (lowercase.
    Notice this search behaves correctly.

  1. Create a record that has a string field starting with “JOINT.”
  2. From the list view, create the filter “starts with JOINT."
  3. Run the filter.
    Notice records that meet the criteria are not found.


This problem has been fixed in Istanbul and forwards. An instance upgrade is necessary.


Related Problem: PRB592406

Seen In

Berlin Patch 4 Hot Fix 1
Calgary Patch 2
Calgary Patch 4
Eureka Patch 12 Hot Fix 2
Eureka Patch 8
Geneva Patch 4 Hot Fix 6
Helsinki Patch 3

Fixed In


Associated Community Threads

There is no data to report.

Article Information

Last Updated:2018-03-23 03:04:35