topic Alfresco and Solr filter query support. in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271050#M224180 <HTML><HEAD></HEAD><BODY><SPAN>Hi,</SPAN><BR /><BR /><SPAN>I've added some customisations to the Alfresco/Solr code (4.0 enterprise) to support filter queries. I have created a custom field using the copy field pattern in the schema.xml,&nbsp; the type of the custom field is 'string' as I need a verbatim copy of the field. </SPAN><BR /><BR /><SPAN>In CoreTracker I can see the field is created using:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>builder.append("\u0000").append(locale.toString()).append("\u0000").append(stringPropertyValue.getValue());<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>so when I build my filter query string I'm using the same method, but nothing is returned. If I change the first '\u0000' to a wildcard character i get the results I expect, i.e.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>builder.append("*").append(locale.toString()).append("\u0000").append(stringPropertyValue.getValue());<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Viewing the field in Luke or the Solr's schema browser only displays the field with empty spaces, i.e. ' en myfield' </SPAN><BR /><BR /><SPAN>Does anyone know why nothing is returned if '\u0000' is placed before the locale in a filter query, or what should be placed before the locale as I don't what to use wildcard characters in my query.</SPAN><BR /><BR /><SPAN>Thanks,</SPAN><BR /><BR /><SPAN>Dan</SPAN></BODY></HTML> Fri, 11 May 2012 12:22:55 GMT dantuffery 2012-05-11T12:22:55Z Alfresco and Solr filter query support. https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271050#M224180 Hi,I've added some customisations to the Alfresco/Solr code (4.0 enterprise) to support filter queries. I have created a custom field using the copy field pattern in the schema.xml,&nbsp; the type of the custom field is 'string' as I need a verbatim copy of the field. In CoreTracker I can see the field i Fri, 11 May 2012 12:22:55 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271050#M224180 dantuffery 2012-05-11T12:22:55Z Re: Alfresco and Solr filter query support. https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271051#M224181 <HTML><HEAD></HEAD><BODY><SPAN>Hi</SPAN><BR /><BR /><SPAN>We should add filter queries.</SPAN><BR /><SPAN>Sometimes you miss the obvious!</SPAN><BR /><BR /><SPAN>Extending your schema has lost how the locale is processed in Alfresco.</SPAN><BR /><SPAN>You would need tokenisation that stripped it.</SPAN><BR /><BR /><SPAN>You would be better making your property dual tokenised "both" or tokenised "false" in your data model</SPAN><BR /><SPAN>You can then filter using = for exact and ~ for FTS matching</SPAN><BR /><BR /><SPAN>Andy</SPAN></BODY></HTML> Fri, 11 May 2012 20:02:51 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271051#M224181 andy 2012-05-11T20:02:51Z Re: Alfresco and Solr filter query support. https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271052#M224182 <HTML><HEAD></HEAD><BODY><SPAN>Thanks Andy.</SPAN><BR /><BR /><SPAN>I managed to getting it working by using the Lucene query parser instead of the Alfresco query parser.</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>fq={!lucene}myField:blah<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Are you planning to release any documentation on the Alfresco and Solr implementation?</SPAN><BR /><BR /><SPAN>Dan</SPAN></BODY></HTML> Wed, 16 May 2012 11:50:04 GMT https://connect.hyland.com/t5/alfresco-archive/alfresco-and-solr-filter-query-support/m-p/271052#M224182 dantuffery 2012-05-16T11:50:04Z