adding sys_id field.

[AryanJ471894898]

How to add sys_id field in the list view in change and problem table for reporting purposes?

[Abbas_5]

Hello @AryanJ471894898,

Please refer to the below steps:

1. Go to: System Definition > Database View.
2. Create a new View and add the table you want to report on. Add a Where clause if needed.
3. Select the Fields to add to the View. Make sure to select the sys_id field too.
4. Save your view. ...
5. Create a List report base on the new Database View.

If it is helpful, please mark it as helpful and accept the correct solution. In future, it might be helpful for someone to refer to this solution.

Thanks & Regards,

Abbas Shaik

[Chaitanya ILCR]

Hi @AryanJ471894898 ,

Try this out
configure a function field with function : glidefunction:substring(sys_id,1,32) and add the column to the report.

If it is helpful, please mark it as helpful and accept the correct solution. In future, it might be helpful for someone to refer to this solution.

Thanks,

Chaitanya