cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

We are happy to announce the new Windchill Customization board! Learn more.

Joining WTCHANGEISSUE to LWCLOCALIZABLEPROPERTYVALUE

AC_10025776
4-Participant

Joining WTCHANGEISSUE to LWCLOCALIZABLEPROPERTYVALUE

Hi all,

I am seeking some assistance to work out how WTCHANGEISSUE links to LWCLOCALIZABLEPROPERTYVALUE. Firstly, we are interested in these records from LWCTYPEDEFINITION:

 

SELECT ida2a2, ida3a4, name
FROM lwctypedefinition
WHERE ida3a4 IN (SELECT ida2a2
FROM lwctypedefinition
WHERE name = 'EngineeringIssue');

 

This returns these records:

 

122479 122122 EngineeringDesignDevelopmentIssue
122530 122122 HomelessItem
122574 122122 PartModellingQualityIssue
122615 122122 PenetrationAdviceRequest
122655 122122 ProductionQuery
122989 122122 RedChange
123070 122122 StakeholderReviewComment

 

Now if I pick out ida2a2 = 122530 (HomelessItem), I can see this value in LWCLOCALIZEPROPERTYVALUE via IDA2B4. I.e.

 

SELECT value
FROM lwclocalizablepropertyvalue
WHERE ida3b4 = 122530

 

gives me:

 

Homeless Item

 

I now want to link this value to WTCHANGEISSUE but can't see what the relationship is. Any assistance welcome.

 

Thanks in advance.

2 REPLIES 2

Can anyone please help?

After a fair bit of research, I have worked this out. Posting SQL if anyone is interested:

 

SELECT pv.VALUE
FROM wtchangeissuemaster dm,
wtchangeissue d,
wttypedefinition wttd,
lwctypedefinition td,
lwclocalizablepropertyvalue pv,
lwcpropertydefinition pd
WHERE dm.ida2a2 = d.ida3masterreference
AND wttd.ida2a2 = d.ida2typedefinitionreference
AND td.name = wttd.logicalidentifier
AND pv.ida3a4 = pd.ida2a2
AND pv.ida3b4 = td.ida2a2
AND pd.name = '[NAME]'

Top Tags