How to restore the values of the reference variable in the catalog item after changing variable typ

Kruthika BM
Tera Contributor

‎10-27-2023 09:31 AM - edited ‎10-27-2023 09:34 AM

Hi Team,

 

We had a requirement, where had to make changes on the existing variable type of the catalog item.

The variable type was "Lookup select box", which was referring to one of the table. Later we changed the variable type to "List Collector"(even now it is referring to the same table)  as per the requirement.

Now, the values of the existing RITM and sctasks got removed, which were created before the changes.

Can anybody please help me to restore the value which we had before for respective RITMs and scatsks. We have around 800 records, with empty values for that variable.

 

Thanks in Advance!

 

Regards,

Kruthika 

0 Helpfuls
  • 257 Views
2 REPLIES 2

Danish Bhairag2
Tera Sage
Tera Sage

‎10-27-2023 09:41 AM

Hi @Kruthika BM ,

 

U can write a fix script for this querying the "sys_audit" table where u can apply appropriate filter in addEncodedQuery & then update it to the previous value.

 

Thanks,

Danish

 

0 Helpfuls

Kruthika BM
Tera Contributor
In response to Danish Bhairag2

‎10-27-2023 10:03 AM

@Danish Bhairag2 ,

 

Thank you for the quick response!

 

We are able to see the values of that particular variable under sc_item_option.LIST table.

The values are in the sys ID.

Also, could you please help me with the scripting. As I don't have much idea on the scripting.

 

Thanks and Regards,

Kruthika BM

0 Helpfuls