Link query returning objects of wrong type

[Arun Katkere <ka...@praja.com>]

For some reason, the link query is not working as it should for me (see
http://ems-katkere/emssample/TestLinkQuery.jsp
<http://ems-katkere/emssample/TestLinkQuery.jsp> ). 
 
Attached is the CR. The corresponding SQL is:
 
SELECT DISTINCT  Q0.PrId FROM PRAJA1PrDbObject Q0,PRAJA1PrDbObject
Q2,PRAJA1__2 Q1,PRAJA1ENTITY_LIST Q3 WHERE (Q0.PrId=Q3.PrId AND
Q2.PrId=Q3.Value AND Q2.Name LIKE 'World%' AND
STRCMP(Q2.ClassificationCategoryName,'PreDefinedLocationSet')=0) AND
(Q0.IsTemplate = 0)

-arun

CR 2993

CR Number:	 	2993	
Entered By:	 	Arun Katkere	
Synopsis:	 	Link query sometimes returns ids from the linked
type.	
Type:	 	Defect	
Status:	 	Open	
Severity:	 	High	
Responsibility:	 	Tom Edwards	
Last Build Tested:	 	00_08_31.test	
Work Around:	 		
Modified Time:	 	8/31/00 6:33:55 PM	
Priority:	 	Yes	
Description:	 	Test JSP page:
<%@ taglib uri="/taglibs" prefix="ems" %>

<ems:Query id="result">
<AND queryType="event">
<Category name="META_EVENT"/>
<Link attrName="locationSetList">
<DbObjectName name="World"/>
</Link>
</AND>
</ems:Query>

<ems:foreach name="result" property="Result">
<ems:getProperty id="dbId" type="String" property="Id"/>
<ems:Event dbId="<%=dbId%>">
<ems:getProperty property="Name"/>
</ems:Event>
</ems:foreach>

URL: http://ems-katkere/emssample/TestLinkQuery.jsp

You get a ClassCastException indicating that one of the ids is a location id
and not an event id.
	
Test Command:	 		
Fix:	 		
Entered On:	 	8/31/00 6:33:27 PM	
View:	 	EMSXX	

  _____  


Total: 1