Joining WTCHANGEISSUE to LWCLOCALIZABLEPROPERTYVALUE

[AC_10025776]

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.

[AC_10025776]

Can anyone please help?

[AC_10025776]

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]'