topic Search Yields Unexpected Results in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169257#M122661 <HTML><HEAD></HEAD><BODY><SPAN>According to the Search WIKI at </SPAN><A href="http://wiki.alfresco.com/wiki/Search#Category_Queries" rel="nofollow noopener noreferrer">http://wiki.alfresco.com/wiki/Search#Category_Queries</A><BR /><BR /><BLOCKQUOTE class="jive-quote">There are not true child relationships between category type nodes and the things they categorize. However, these links can be searched using the special "member" QName.</BLOCKQUOTE><SPAN>And</SPAN><BR /><BLOCKQUOTE class="jive-quote">This finds any child that is not a "member" child. <BR /><BR />To find all subclassifications of "cm<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />oftware Document Classification" is more complex as you need to find any children that are not members of the category (ie things that are children but have not been categorised) <BR /><BR /> +PATH:"/cm:generalclassifiable//cm<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />oftware_x0020_Document_x0020_Classification//*"<BR /> -PATH:"/cm:generalclassifiable//cm<img id="smileyfrustrated" class="emoticon emoticon-smileyfrustrated" src="https://connect.hyland.com/i/smilies/16x16_smiley-frustrated.png" alt="Smiley Frustrated" title="Smiley Frustrated" />oftware_x0020_Document_x0020_Classification//member"</BLOCKQUOTE><BR /><SPAN>From these two statements I conclude that a search for "//*" will return subcategories and members, and a query for "//member" will only return members.</SPAN><BR /><BR /><STRONG>The problem is, Alfresco is not behaving as documented.&nbsp; I am using Alfresco 2.9.0B build 707 on Windows XP Business Server with Tomcat 5.5 and Java 1.6.0_04.</STRONG><BR /><BR /><SPAN>I have a category hierarchy consisting of Regions/USA/&lt;state abbreviations&gt;/&lt;counties&gt;, and I have hundreds of documents assigned to &lt;state abbreviations&gt; and &lt;counties&gt;.</SPAN><BR /><BR /><SPAN>A Lucene query in the Node Browser for </SPAN><STRONG>+PATH:"/cm:generalclassifiable/cm:Regions/cm:USA//*</STRONG><SPAN> matches 401 rows.&nbsp; All of these are Documents.&nbsp; None of these are subcategories of Regions/USA as expected.</SPAN><BR /><SPAN>A Lucene query in the Node Browser for </SPAN><STRONG>+PATH:"/cm:generalclassifiable/cm:Regions/cm:USA//member"</STRONG><SPAN> matches 201 rows.&nbsp; Again, all of these are Documents, but I expected this from the document quoted above.</SPAN><BR /><BR /><SPAN style="text-decoration: underline;"><STRONG>I have two BIG problems with these results.</STRONG></SPAN><BR /><SPAN>1.&nbsp; Why aren't all 401 documents being returned by the query </SPAN><STRONG>+PATH:"/cm:generalclassifiable/cm:Regions/cm:USA//member</STRONG><SPAN>?</SPAN><BR /><SPAN>2.&nbsp; Why isn't the query </SPAN><STRONG>+PATH:"/cm:generalclassifiable/cm:Regions/cm:USA//*</STRONG><SPAN> returning any category nodes as documented on the WIKI?</SPAN><BR /><BR /><STRONG>Impact:</STRONG><SPAN>&nbsp; We have clients complaining that documents in Alfresco are not showing up on their websites.&nbsp; Their websites use the Alfresco web service client to perform Lucene queries for documents by category PATH (as documented on the Search WIKI - we use the "/member" QName for finding documents assigned to a category), and Alfresco is not returning results as documented.</SPAN><BR /><BR /><SPAN>Let me know if you are seeing this issue as well, in this version of Alfresco or another.</SPAN><BR /><BR /><SPAN>I am starting this conversation on the forums to confirm that this is a bug before I post a Bug to the Alfresco JIRA, so your help is necessary and appreciated.</SPAN><BR /><BR /><SPAN>Cheers!</SPAN><BR /><BR /><SPAN>Stephen</SPAN></BODY></HTML> Wed, 23 Apr 2008 19:55:14 GMT stevewickii 2008-04-23T19:55:14Z Search Yields Unexpected Results https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169257#M122661 According to the Search WIKI at http://wiki.alfresco.com/wiki/Search#Category_QueriesThere are not true child relationships between category type nodes and the things they categorize. However, these links can be searched using the special "member" QName.AndThis finds any child that is not a "member" Wed, 23 Apr 2008 19:55:14 GMT https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169257#M122661 stevewickii 2008-04-23T19:55:14Z Re: Search Yields Unexpected Results https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169258#M122662 <HTML><HEAD></HEAD><BODY><SPAN>You've got the wrong query. You want something like:</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE>PATH:"/cm:generalclassifiable//cm:United_x0020_States_x0020_of_x0020_America//*"<SPAN class="line-numbers-rows"><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /><SPAN>Unless your categories are set up differently to me?</SPAN><BR /><BR /><SPAN>How are you running the queries? Have you tried them in the node browser?</SPAN><BR /><BR /><SPAN>Rob</SPAN></BODY></HTML> Fri, 25 Apr 2008 11:22:44 GMT https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169258#M122662 dinger 2008-04-25T11:22:44Z Re: Search Yields Unexpected Results https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169259#M122663 <HTML><HEAD></HEAD><BODY><SPAN>My categories are set up differently.</SPAN><BR /><BR /><SPAN>I have a Regions/USA/&lt;state abbr&gt;/&lt;county name&gt; category hierarchy.</SPAN></BODY></HTML> Fri, 25 Apr 2008 18:23:58 GMT https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169259#M122663 stevewickii 2008-04-25T18:23:58Z Re: Search Yields Unexpected Results https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169260#M122664 <HTML><HEAD></HEAD><BODY><SPAN>What happens when you run the query in the node browser?</SPAN><BR /><BR /><SPAN>Rob</SPAN></BODY></HTML> Mon, 28 Apr 2008 10:01:53 GMT https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169260#M122664 dinger 2008-04-28T10:01:53Z Re: Search Yields Unexpected Results https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169261#M122665 <HTML><HEAD></HEAD><BODY><SPAN>See Original Post.&nbsp; Every query was executed through the Node Browser.</SPAN></BODY></HTML> Fri, 30 May 2008 18:49:01 GMT https://connect.hyland.com/t5/alfresco-archive/search-yields-unexpected-results/m-p/169261#M122665 stevewickii 2008-05-30T18:49:01Z