how can you include the sys_id in a report

Rob Litkenhaus · ‎02-13-2018

How can you include the sys_id in a report and how can you view the sys_id in a list view or on the actual records as a value in a field ?

darius_koohmare · ‎02-13-2018

1. Go to module System UI -> Lists

2. Select the record for the Table and view you want to modify (e.g. incident table, default view).

3. In the List Elements related list, add sys_id in the position you want

4. In your application navigator, type cache.do

Geoffrey_Bishop · ‎06-01-2021

For adding the sys_id column to a List View, this article includes screenshots, and may help someone.

OsitoTeitorNew · ‎09-06-2023

A quick solution could be:

- While you are creating the report in the step 'Configure'

- Add a 'Configure function field'

- Set a label: 'Your desired Sys ID'
- Set a return type: 'Text'

- Set Add Operation: concat(,) <-- set the cursor over the first part of the method concat(<cursor here>,)

- Set an Add Field, from the list select 'Sys ID' -- > concat(sys_id, '') the second part of the method must be ''

- Click 'Save'

- Go back to configure step and select your new column

- Click 'Choose columns'

- Search and select your field previously created 'Your desired Sys ID'

- Save/Run your report

Don't forget to mark it as helpful!!