- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2024 02:06 AM
I am having custom table and all the values are strings there.
i am populating 4 values from the custom table like this
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.
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.
Solved! Go to Solution.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2024 03:19 AM
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.
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! */
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
09-03-2024 07:59 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-27-2024 06:06 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2024 04:45 AM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-28-2024 02:31 PM
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-29-2024 02:23 AM
I am accessing a custom table and all the values are from the same custom table.