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.