Values from RITM is not populating properly into the Catalog Task

suvi1
Tera Contributor

I  am having custom table and all the values are strings there.

i am populating 4 values from the custom table like this

suvi1_0-1724749201685.png

 

 if i select the Source system , the values are populating  based on the source system.

 (i want to say here , that same record is displaying from the back end cutom table)

 where entity, data owner and data owner 2 are dependent on the Source system.

 

  and  i am getting like this.

 

suvi1_1-1724749505858.png

 

Entity field and DataOwner fields are not populating.

 

Can any one suggest me , where can i have done the wrong.

 

and in the workflow i have set the fields.

 

2 ACCEPTED SOLUTIONS

GlideFather
Tera Patron

It might be caused by selecting records that have been deleted/deactivated.

Install browser extension called SN Utils and then when you have the form with the situation like you do, then double click the variable name (e.g. Entity or Data Owner), and you will see whether it is empty, or there is any sys_id.
When there is a sys_id, copy it, then go to backend and use a slashcommand "/" following the sys_id you just copied and press enter, it is the fastest way to recognise the sys id. Example of the full slash command "/basaeed5c3d60210647b0f35fd0133bf" + enter.

Screenshot 2024-08-29 at 11.18.03.png

You will see what the record is, or whether it is not existing, the same way it can be searched in PROD or any other environment,

It can happen for example when there is a record in PROD, and you are using the sys_id in DEV where it does not exist.

———
/* If my response wasn’t a total disaster ↙️ drop a Kudos or Accept as Solution ↘️ Cheers! */


View solution in original post

Since you see all 4 variables populated correctly on the request form, make sure you do not have an onSubmit Catalog Client Script, a workflow script, or a Client Script or Business rule on the sc_req_item table that could be affecting/clearing/overwriting these variable names.

View solution in original post

13 REPLIES 13

Brad Bowman
Kilo Patron
Kilo Patron

If I'm following correctly, you want to know why when you set the value of four fields in a workflow, only two of them are appearing on this RITM or Catalog Task record.  These appear to be reference type variables, so confirm that you are setting the value of each to a valid sys_id for the reference table of that variable.

suvi1
Tera Contributor

Hi Brad,

 

 Greetings!!

 Yes, i am setting the correct values, one record  from the custom table , i am setting those values.

 on the form they are reference variables, and in the custom table they are Strings.

 

So you are populating reference variables from custom table string values.  What tables are the four variables referencing?  The two that are not working must not be valid sys_ids for that specific reference table.

I am accessing a custom table and all the values are from the same custom table.