Trouble with fulltext search - displayed result more than once

csorvy

Hi,

I am facing some problems with fulltext search (dctm 5.3 SP3 on solaris and oracle on linux) when displaying results in a customized webtop application. Some documents (existing only in one version) are displayed more than once. However, fulltext query is executed without problems using DA (so every document is contained only once in result set. But when preparing the results in resultlist.jsp (see some fragment of this file below) some of these documents are displayed twice or even more. Even more curious: redundant documents do not appear one after the other but like this: A.doc, B.doc, C.doc, B.doc, D.doc, C.doc, D.doc

Does anybody know whether it is a bug in WDK framework?

<tr><dmf:celllist><dmf:celltemplate field='object_name'><td class='de_td_gray3' height='25px'></td><td class='de_td_gray3' colspan='2'></td><td align='left' width='300' class='de_td_gray3' scope='col'><dmf:datasortlink name='sort_object_name' datafield='CURRENT' cssclass='de_font_header_bold2' /></td></dmf:celltemplate></dmf:celllist><dmf:columnpanel columnname='path'><td class='de_td_gray3' height='25px' colspan='2'></td></dmf:columnpanel><td class='de_td_gray3'></td></tr><%String tablecss = "";boolean rowColor = false;%><dmf:datagridRow name='columns' tooltipdatafield='object_name'><%if(rowColor){tablecss = "de_td_gray4";}else{tablecss = "";}rowColor = !rowColor;%><tr><td class='<%=tablecss%>' height='25px'></td><td class='<%=tablecss%>'></td><td nodeap class='<%=tablecss%>' width='30px'><de:docbaseicon style='text-align: middle;' formatdatafield='a_content_type' typedatafield='r_object_type' size='16' linkcntdatafield='r_link_cnt' isvirtualdocdatafield='r_is_virtual_doc'/></td><dmf:celllist><dmf:celltemplate field='object_name'><td nodeap scope='row' class='<%=tablecss%>'><dmf:stringlengthformatter maxlen='32'><dmf:link cssclass='de_font4' name='lblObjName' onclick='onClickObject' datafield='object_name'><dmf:argument name='objectId' datafield='r_object_id'/><dmf:argument name='type' datafield='r_object_type'/></dmf:link></dmf:stringlengthformatter></td></dmf:celltemplate></dmf:celllist><td class='<%=tablecss%>'></td><dmf:columnpanel columnname='path'><td nodeap class='<%=tablecss%>' align='right'><dmf:link nlsid='DE_FOLDER_LINK' cssclass='de_font4' onclick='onClickTileFolder' runatclient='true'><dmf:argument name='compname' value='pro_tile_children'/><dmf:argument name='level' value='1'/><dmf:argument name='dctmId' datafield='r_object_id'/><dmf:argument name='servicename' value='<%=comp.serviceName%>'/></dmf:link></td></dmf:columnpanel><td class='<%=tablecss%>'></td></tr></dmf:datagridRow>

csorvy

I was wrog before, it is the query, and it seems to be a documentum bug. Depending on position of r_version_label (the only repeating attribute) in select statement result set contains different number of rows!

r_object_type,r_lock_owner,r_object_id,owner_name,score,i_is_reference,a_content_type,object_name,r_is_virtual_doc,r_link_cnt,r_content_size,i_vstamp,r_modify_date,r_version_label--> 5r_object_type,r_lock_owner,r_object_id,owner_name,score,i_is_reference,a_content_type,object_name,r_is_virtual_doc,r_link_cnt,r_content_size,i_vstamp,r_version_label,r_modify_date--> 7r_object_type,r_lock_owner,r_object_id,owner_name,score,i_is_reference,a_content_type,object_name,r_is_virtual_doc,r_link_cnt,r_content_size,r_version_label,i_vstamp,r_modify_date--> 8r_object_type,r_lock_owner,r_object_id,owner_name,score,i_is_reference,a_content_type,object_name,r_is_virtual_doc,r_link_cnt,r_version_label,r_content_size,i_vstamp,r_modify_date--> 7r_object_type,r_lock_owner,r_object_id,owner_name,score,i_is_reference,a_content_type,object_name,r_is_virtual_doc,r_version_label,r_link_cnt,r_content_size,i_vstamp,r_modify_date--> 4