Advice on custom TMS query, how to link VT to responses table
Last updated on NOVEMBER 03, 2016
Applies to:Oracle Thesaurus Management System - Version 5.0.1 to 5.1.0 [Release 5.0 to 5.1]
Information in this document applies to any platform.
Your trying to put together a custom query which needs to join derived custom values stored in the value_text column on the responses table, with LLT codes in TMS. These response values are also stored on a custom table.
The query is so you can compare TMS (response value is linked to the LLT) with the same on the custom table.
What's the most efficient way to join the derived LLT term(s) to the responses table, or is there an existing View?
You're thinking something like e.g. to find the terms loaded with dictionary id 1 and dictionary level 81 (which is LLT from tms_def_levels) a query similar to below:
But your not totally sure how to link to the responses table.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms