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 now 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:body_emp.cfm?id=4735&action=RetrieveFile&ref=32356&fp=/Create_View_Delete_C alendar_Groups.doc*'>
OK, so I've figured out the syntax or querying the key field. The criteria looks something like this:
*note that every '\' has been escaped to '\\'
Now say, I want to add additional criteria like documents that contain the word office, the criteria looks like this:
criteria='""key:"D:\\Inetpub\\FoldererName\\FolderName\\FolderName\\Create_View_Delete_Cal endar_Groups.doc""" AND "+office"'\
What I really want to do though is limit the search do docments in a specific folder, something like
I can't seem to get this to work. I've read other posting saying wildcard searches need to be in lower case, and I've used lcase() around the string to force this, but still nothing is returned.
It's probalby a syntax issue, but I tried lots of variation with no success.