Field of a type "table_name" on a form showing the sys_id instead of a value.

[Rahul84]

Hi Team,

I am facing one of the issue for a field of a type of "table name" on a form.

I am populating the value of a field via service catalog request. On a submission of a service request , data is filled in the target table. Data insertion is working fine but one of the field value on a form is showing sys_id instead of a value.

We are setting the value of glide_list variable on a catalog form into the field of type "table name" in the target table.

If we manually select the value of a field ( type - table name) on a form , it is displaying the correct name only but when setting the value from catalog request submission into the target table then sys_id is getting reflected on the form view.

In the XML record also , filled contains only the sys_id , no display value.

Can anyone pls help , what will be the main root cause of this behavior and how we can overcome this.

Thanks

[Ravi9]

do provide some screenshots / sample code

[Rahul84]

@Ankur Bawiskar : can you pls suggest something on this..

[Sourabh26]

Hi,

Can you share the below details and confirm -

1. Field on the catalog references to which table
2. Field on the form references to which table
3. Both fields (catalog and form) should be reference fields only

Share the screenshots for the same to have more clarity.

Regards,

Sourabh

[Rahul84]

Hi Sourabh,

Please find the inline response.

1. Field on the catalog references to which table

<< Field on the catalog form references to sys_db_object >>

     2. Field on the form references to which table

<< Field on the target table form is a type of "Table Name" field not a reference field>>

      3. Both fields (catalog and form) should be reference fields only

<< No , they are not of the same type . On the catalog form it is type of reference field and on a table form view , it is type of "Table Name" field>>

If we are going to change the type of table field from "Table Name" to reference than existing data will be vanished as per some other community post.

Pls suggest the best suitable way.

Thanks