SYS_ID column in list view

[Valor1]

Long time listener, first time caller..

I cannot for the life of me determine how to get the "Sys ID" field to show up in a list / list filter. Some instances show the field and some do not. I've searched the wiki, community and our internal resources and can't find it.

Is there a property or user preference that I'm missing?

[mamann]

Valor,

You can try this and it should work for what you need 😃

1. Go to System UI -> Lists

2. Select the record for the Table and view you want to modify

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

4. Execute cache.do

[Valor1]

Excellent! Thanks, Mark!

I really don't know why there's not a property to allow for admins in the list personalizer.

[haldroid]

I created a new view in our dev instance of one of our custom tables and added sys_id. It works in a browser but not when I try download with &CSV. Also I see that sys_id does not show up when I click in the list view banner and select Personalize > List Layout.

Mark's technique is useful for browser, but I expect to switch to JSON output, since that sends sys_id by default for reference fields. Present task involves data munging with R, and R does JSON.

[Valor1]

OT: I'm very happy that JSON has caught on.. it's a great way to handle (in a simple manner) cross-application data comparison.