Searching for single-quotes is broken across the entire system. If you try to use the SLSB interfaces, or the Criteria API, or the SearchBar - it doesn't work anywhere. When formatting query parameters that represent searchable fields, we need to escape single-quotes. Luckily, this functionality is centralized in QueryUtility class today, so updating it once there should enable this functionality for all places that call into it.
commit 8d0b63fa40dfd3f0dacd82b1e7003094fe8216e7 Author: Joseph Marques <joseph> Date: Wed Jul 14 21:07:11 2010 -0400 BZ-614688: support searching for values that contain single-quotes
Testing with build 175 of ci-rhq-release job. Searches for the following strings worked as expected, John's Job 'my broken job' my 'broken' job my 'broken' 'job' my '"' broken job Joseph pointed out to me that only a single level of nesting is supported; so, the following is not considered legal, my '"'broken'"' job since it nests single quotes two levels deep.
Mass-closure of verified bugs against JON.