Action Enum Translation 1 CREATED_ACTION lblCreated 2 UDPATE_ACTION lblUpdated 3 CREATED_FROM_ACTION lblCreatedFrom 4 UPDATED_FROM_ACTION lblUpdatedFrom 5 CREATE_NEW_ACTION lblCreateNew 6 CREATE_NEW_COPY_ACTION lblCreateNewCopy 7 CREATE_NEW_COPY_OF_ACTION lblCreateNewCopyFrom 8 CREATE_NEW_ISSUE_ACTION lblCreateNewIssue 9 CREATE_NEW_ISSUE_OF_ACTION lblCreateNewIssueFrom 10 CREATE_TARGET_REVISION_ACTION lblCreateTargetRevision 11 CREATE_TARGET_REVISION_OF_ACTION lblCreateTargetRevisionFrom 12 CREATE_FROM_TEMPLATE_ACTION lblCreateNewFromTemplate 13 CREATE_FROM_TEMPLATE_OF_ACTION lblCreateNewFromTemplateFrom 14 CREATED_FROM_EQ_ACTION lblCreatedFromEQ 15 UPDATED_FROM_EQ_ACTION lblUpdatedFromEQ 16 CREATE_NEW_ISSUE_FROM_EQ_ACTION lblCreatedNewIssueFromEQ 17 CREATE_FROM_TEMPLATE_FROM_EQ_ACTION lblCreatedNewFromTemplateFromEQ 18 CREATE_FROM_IMPORT_ACTION lblCreateNewFromImport
You can find the translations listed above in the "WebCommon/SpecLineageHistory" translation cache.
(cache pkid = '216533899e13-d861-441e-ae2a-af81b3e85c0c')
You can see these translations using the following SQL query (not that I restricted it to English only, but you can remove that)
select item.id, trans.*, * from commonTranslationCaches cache inner join commonTranslationItemsJoin j on j.fkTranslationCache = cache.pkid inner join commonTranslationItems item on item.pkid = j.fkTranslationItem inner join commonTranslationItemValues trans on trans.fkTranslationItem = j.fkTranslationItem where cache.ID = 'SpecLineageHistory' and trans.langID =0 -- restrict to English translations only
Thanks Ron for the information. Can you please let me know how we get from the Action Numeric value to the translation item? Or is this hard coded? We need to join data this together to produce a BO report.
Unfortunately, it is not specified in the database, but in classes.
So you could either create a simple lookup table yourself, associating the ActionNumber to the translationID, or write a function to do so, or something similar.
Can you tell me how to get a complete list of user friendly translations for the action items?
Example: For action 13, the UI has the Action Name as 'Created New From Template', but the translation in the table you provided has 'lblCreateNewFromTemplateFrom'
We are planning to create our own custom Action Item translation table and would like to have everything in it.
The SQL query I provided earlier should get the values for you.
When I run the query provided earlier I get the following labels which do not match the labels in the table you provided. Why the difference? How do I get the translations for the missing labels? And there are labels in the results that are not in your table. Thye do not all look like actions. Please advise.
Sorry for the confusion and the delay in responding.
Several of these entries from the cache are simply used in the User Interface as labels.
Others are from PQM and SCRM (they are using the same cache here).
Hope that helps.