I'm trying to get migrate to solr, but have a question about using the record key in the search critera
With Verity my code looks like this: <cfsearch name="getPreDeleteInfo" collection="#sttCFG.strCollectionName#" type="simple" status="info" language="english" criteria=" CF_KEY <CONTAINS> '#variables.criteria#'"> The record in the collection looks like: [Record # 1] AUTHOR: casjlr CATEGORY: smm_doclibsecure CATEGORYTREE: Web/ CONTEXT: [empty string] CUSTOM1: office 2003 doc test CUSTOM2: office 2003 doc test CUSTOM3: [empty string] CUSTOM4: Everyone_Intranet KEY: D:\...\Web\Create_View_Delete_Calendar_Groups.doc RANK: 1 RECORDSSEARCHED: 1 SCORE: 0.0000 SIZE: 76288 SUMMARY: Pick members from an Address Bookor Contacts list Create a calendar group based on the calendars that you are viewing Pick members from an Address Book or Contacts list In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Create New Calendar Group. Create a calendar group based on the calendars that you are viewing In Calendar, on the Home tab, in the Manage Calendars group, click Calendar Groups, and then click Save as New Calendar Group. Add ... TITLE: office 2003 doc test TYPE: application/msword URL: body_emp.cfm?id=xx&action=RetrieveFile&ref=33&fp=/Create_View_Delete_ Calendar_Groups.doc An example of something that doens't work: <cfsearch name="test" collection="test_solr "status="info" criteria='key:D*\...\Web\Create_View_Delete_Calendar_Groups.doc'> Note: ... is not the actual info (Didn't want to put my server actual path info in a public site) I've tried a number of differnet combinations, but to no avail. Has anyone else successfully written a query like this? Getting at the custom fields works fine. <cfsearch name="test" collection="prodsite_smm_doclibsecure_solr "status="info" criteria='custom1:office 2003'> brings back the expected results. In the Scheme.xml file I changed the key and URL fields to be indexed="true" <field name="key" type="string" indexed="true" stored="true" required="true" /> <field name="url" type="string" indexed="true" stored="true" required="true" /> I can do a search on the URL field as long as like put the wildcard * at the end of the search criteria, but I still do not get any results using the key field. Any ideas how now to escape colons : in the path name? <cfsearch name="test" ="#sttCFG.strCollectionName#" status="info" criteria='url:b*=32356&*'> Any help is appreciated. ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-talk/message.cfm/messageid:346090 Subscription: http://www.houseoffusion.com/groups/cf-talk/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-talk/unsubscribe.cfm
