tracker issue : CF-3503537

select a category, or use search below
(searches all categories and all time range)
Title:

SOLR "key" Field Unsearchable

| View in Tracker

Status/Resolution/Reason: Closed/Withdrawn/

Reporter/Name(from Bugbase): Christopher Tierney / Christopher Tierney (Christopher Tierney)

Created: 02/20/2013

Components: Text Search

Versions: 9.0.1

Failure Type: Usability Issue

Found In Build/Fixed In Build: 9.0.1 /

Priority/Frequency: Trivial / Unknown

Locale/System: English / Windows 7

Vote Count: 0

Problem Description: When using cfsearch with criteria for the "key" field, results are never found.

Looking at the logs, a search in the "title" field returns the correct results:
..."GET /solr/col/select?q=title%3A%22My+Title%22&fl=key%2Cuid%2Curl%2Ctitle%2Cauthor%2Cmime%2Csize%2Csummary%2Cscore%2Ccontents%2Cspell%2Ccustom1%2Ccustom2%2Ccustom3%2Ccustom4%2Ccategory%2Ccategorytree&fl=score&rows=1&wt=javabin&version=1 HTTP/1.1" 200 1472 
..."GET /solr/admin/cores?action=STATUS&core=col&wt=javabin&version=1 HTTP/1.1" 200 488 
..."GET /solr/col/select?q=title%3A%22My+Title%22&fl=key%2Cuid%2Curl%2Ctitle%2Cauthor%2Cmime%2Csize%2Csummary%2Cscore%2Ccontents%2Cspell%2Ccustom1%2Ccustom2%2Ccustom3%2Ccustom4%2Ccategory%2Ccategorytree&fl=score&rows=5&qt=standard&start=0&wt=javabin&version=1 HTTP/1.1" 200 1494 

However, a search in the "key" field ends up searching the "contentsExact" field for some reason and doesn't return the expected result:
..."GET /solr/col/select?q=key%3A%2277%22&fl=key%2Cuid%2Curl%2Ctitle%2Cauthor%2Cmime%2Csize%2Csummary%2Cscore%2Ccontents%2Cspell%2Ccustom1%2Ccustom2%2Ccustom3%2Ccustom4%2Ccategory%2Ccategorytree&fl=score&rows=1&wt=javabin&version=1 HTTP/1.1" 200 242 
..."GET /solr/admin/cores?action=STATUS&core=col&wt=javabin&version=1 HTTP/1.1" 200 488 
..."GET /solr/col/select?q=key%3A%2277%22&fl=key%2Cuid%2Curl%2Ctitle%2Cauthor%2Cmime%2Csize%2Csummary%2Cscore%2Ccontents%2Cspell%2Ccustom1%2Ccustom2%2Ccustom3%2Ccustom4%2Ccategory%2Ccategorytree&fl=score&rows=5&qt=standard&start=0&wt=javabin&version=1 HTTP/1.1" 200 268 
..."GET /solr/admin/cores?action=STATUS&core=col&wt=javabin&version=1 HTTP/1.1" 200 488 
..."GET /solr/col/select?q=contentsExact%3Akey%3A%2277%22&fl=key%2Cuid%2Curl%2Ctitle%2Cauthor%2Cmime%2Csize%2Csummary%2Cscore%2Ccontents%2Cspell%2Ccustom1%2Ccustom2%2Ccustom3%2Ccustom4%2Ccategory%2Ccategorytree&fl=score&rows=5&qt=standard&start=0&spellcheck=false&wt=javabin&version=1 HTTP/1.1" 400 1881 

Steps to Reproduce: <cfsearch collection="col" name="results" criteria="key:77">

Actual Result: Empty query results

Expected Result: Query result matching "key" 61.

Any Workarounds: Duplicate value into another field and search on it.

----------------------------- Additional Watson Details -----------------------------

Watson Bug ID:	3503537

External Customer Info:
External Company:  
External Customer Name: firefighter990
External Customer Email:  
External Test Config: My Hardware and Environment details: CF Version 9,0,1,274733 using a standalone CFM page to debug.

Attachments:

Comments:

"key" field by default is not indexable. You can change these configuration in your schema.xml file Default setting for 'key' field is : <field name="key" type="string" indexed="false" stored="true" required="false" />
Comment by Uday O.
16247 | October 01, 2013 05:21:59 AM GMT