- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2019 07:37 AM
Team,
What table or tables in the database schema hold the variables and variable values? For example, when I view a Request Item there is a section called variables with fields and values. I am trying to understand what table or tables holds these values. Ultimately, I am looking to JOIN these variable fields and values to the sc_req_item table.
Solved! Go to Solution.
- Labels:
-
Reporting
- 95,558 Views
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2019 01:07 PM
M2M table to request item
sc_item_option_mtom.request_item = sc_req_item.sys_id
M2M table to variable
sc_item_option_mtom.sc_item_option = sc_item_option.sys_id
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
10-04-2023 11:23 AM
This looks like a great reference, if I could recreate it. How was the list created? What table did they use to start?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2019 08:56 AM
They can be found on the "question_answer" table.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2019 08:57 AM
sc_item_option_mtom is the table name.
Please share your exact requirement in case of you need more information/pointers.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-24-2019 10:44 AM
Do you know what fields (keys) I should use to JOIN these 3 tables? Assuming sys_id will be used...
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-23-2019 08:59 AM
Request Item: sc_req_item
Request Item to Variable: sc_item_option_mtom
Variable: sc_item_option
