List collector

[dev_K]

Hello,

so I have a catalog item list collector that points to "Question Choice" table with a reference qualifier.

I assume that highlighted is the sys ID, but how can I find it just by having this info which question it is ??

[Sid_Takali]

Hi @dev_K It seems your Question field is also a Reference field on your Question Choice (question_choice) table. Your attached image 2. Open that Question field in new tab and in List View. Apply filter using Funnel Icon  Sys Id is 

Regards,

Siddharam

[Ranjit Nimbalka]

Hi @dev_K ,

Just go to table "question_choice" and apply filter sys_id is "sys_id for which you want question" then open that record you can see the question field that's the question.

if you want script for that here it is:-

var grQuestionChoice = new GlideRecord('question_choice');
grQuestionChoice.addQuery('sys_id','8aecb352c0a80015004a961f9d4e8252');
grQuestionChoice.query();
if(grQuestionChoice.next())
{
	gs.print(grQuestionChoice.question.question_text);
}

If my answer has helped with your question, please mark my answer as accepted solution and give a thumb up.
Regards,
Ranjit

[BrahmjeetTanwar]

Hi dev_K,

Copy the sys_id from the reference qualifier and in the Question Choices table apply the filter as "Sys ID" is and paste the sys_id and run the filter, you will be able to get the desired question.

Let me know if you have any concerns.

Thanks,
Brahm

[Ranjit Nimbalka]

Hi @dev_K ,

If my answer solved your issue please mark as a accepted solution that will be useful for future readers.

Regards,

Ranjit