How to display variable value in dropdown

[PallaviGTUS]

I have requirement where i have one field which is reference field.(sc_req_item table it is referring to) which will display all ritm number raised by me for particular catalog item.

But i need to display catalog form's variable along with RITM number.

The variable is Multirow variable set variable

[Samaksh Wani]

Hello @PallaviGTUS 

Instead of Display, you can do one use case you can store it in combined form after submit, or else you need to create

a new field which will show the combined data on the basis of selection.

Plz Mark my Solution as Accept and Give me thumbs up, if you find it Helpful.

Regards,

Samaksh

[PallaviGTUS]

Actually it will be displayed when user submitting for second time.

 So the requirement  is to show previous details.

[sushantmalsure]

Hi @PallaviGTUS 

Its a strange ask.

But I think can be done, instead of referencing to sc_req_table, I would suggest reference to 'sc_item_option_mtom' table.

This table holds value of all the variables with its associated RITM number under filed named Parent Item.

Now once you refer to this table then you can filter the records in reference qualifier with your variable name.

And using variable attributes (ref_ac_columns) you can select only Parent Item (RITM),Question (variable name) and Value (variable's value) fields to be present as columns .

[PallaviGTUS]

above method is not working