PTC/USER Portal

Welcome, Lawrence Jett - PTC/USER Members

11:20 PM America/Central

How do I get wt.part.WTPartUsageLink's usesOccurrenceVector

How do I get wt.part.WTPartUsageLink's usesOccurrenceVector

Sep 19, 2008 03:12 AM


Hi,

I am building a jsp page that should walk a part tree to build a bom, and I need to add the list of occurences with the location id for each part in an electronical board.

I have been able to list the WTPartUsageLink objects, but when I try to get the usesOccurrenceVector I receive a "null". The information is somewhere however, as I can get it using the standard "export" function.

Does any body know how I could get it with a jsp page or a homemade java class ?
The attachment is the qml query for the report that I use to get part usage links.

TIA,

Vincent


Attachments:
PartLinks.qml
(2.4k) - Sep 19, 2008 03:12 AM   [3335]

RE: How do I get wt.part.WTPartUsageLink's usesOccurrenceVector

Dec 05, 2008 08:11 AM


Hi Vincent,

Did you get a solution for this problem? Example? I have a similar issue. Product Structure Explorer displays well the Product Tree of WTParts but the DIRECTION "uses" in my webject/jsp page does not seem to be able to get the structure ok.

 

 


RE: How do I get wt.part.WTPartUsageLink's usesOccurrenceVector

Dec 10, 2008 04:32 AM



Christophe,

The part locations are in a table named wt.part.PartUsesOccurrence which you can obtain once you have the PartUsageLinkRef with a where clause : 

ls_Param = "linkReference=" + <PartUsageLinkRef>

and a webject like :

<ie:webject name="Query-Objects" type="OBJ">

<ie:param name="INSTANCE" data="<%=gs_Instance%>" />

<ie:param name="AUTHORIZATION" data="${@SERVER[]AUTHORIZATION[0]}" />

<ie:param name="TYPE" data="wt.part.PartUsesOccurrence" />

<ie:param name="WHERE" data="<%=ls_Param%>" />

<ie:param name="GROUP_OUT" data="Occurrences" />

</ie:webject>

where the PartUsageLinkRef was obtained by a UsedBy query on the "object reference"

<ie:webject name="Query-Links" type="OBJ">

<ie:param name="INSTANCE" data="<%=gs_Instance%>" />

<ie:param name="AUTHORIZATION" data="${@SERVER[]AUTHORIZATION[0]}" />

<ie:param name="OBJECT_REF" data="<%=ws_ObjectRef%>" />

<ie:param name="DIRECTION" data="usedBy" />

<ie:param name="TYPE" data="WCTYPE|wt.part.WTPartUsageLink" />

<ie:param name="ATTRIBUTE" data="name,quantity.amount,quantity.unit,SupplierReference,Status" delim="," />

<ie:param name="SELECTBY" data="BASELINE" />

<ie:param name="SELECTBY_BASELINE_REF" data="<%=gs_BaselineRef%>" />

<ie:param name="OUTPUT_TYPE" data="FULL" />

<ie:param name="GROUP_OUT" data="UpperLink" />

</ie:webject>

 HTH,

 HTH,

 

Vincent

 

 


In Reply to Christophe Laudou:

Hi Vincent,

Did you get a solution for this problem? Example? I have a similar issue. Product Structure Explorer displays well the Product Tree of WTParts but the DIRECTION "uses" in my webject/jsp page does not seem to be able to get the structure ok.

 

 



Copyright © 2009 PTC/USER. All Rights Reserved
All material, files, logos and trademarks within this site are copyright their respective organizations.
Terms of Service - Privacy Policy - Contact

Logout


Are you sure you want to logout?
Yes No