Query on Requested Item variable/values?

Mazin AliKarar
Mega Expert

Hello everyone,

Can somebody please answer the below question. It was asked by Chuck Tomasi but has not been answered yet. 

Thank you all, 

find_real_file.png

 

 

Best regards, 

1 ACCEPTED SOLUTION

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

When you create a report on sc_req_item table then you can find variables in the list of columns(it works like the reference field), so as you click on it the + sign appears and clicking on it you will get the list of catalogs to select in a popu[p window. Select the catalog in question and then you will get all the variables from that catalog.

find_real_file.png

 

 

-Anurag

View solution in original post

3 REPLIES 3

Anurag Tripathi
Mega Patron
Mega Patron

Hi,

When you create a report on sc_req_item table then you can find variables in the list of columns(it works like the reference field), so as you click on it the + sign appears and clicking on it you will get the list of catalogs to select in a popu[p window. Select the catalog in question and then you will get all the variables from that catalog.

find_real_file.png

 

 

-Anurag

Thank you!

Tushar Sharma2
Kilo Guru

Hello Mazin,

This is something to do with code as the value of question provided by user stores in different table and relation of Question with RITM stored different table with dependency.

For this you have to search for RITM in sc_item_option_mtom form where you will find dependency field which stores the sys_id of records from sc_item_option which stores the question and its value answered by user. Hence in sc_item_option_mtom form per RITM you will find records depends upon the answered by user. Lets say if you have 5 question in a RITM then you will find 5 records created in the sc_item_option_mtom with same parent name and different dependency questions.

You can build qualification like below in the reports: 

find_real_file.png

Hit like and correct answer on the impact of response.

Regards,

Tushar

DXSherpa Technologies