[sys_user] = Users table. Where however do you actually input the [sys_user] to bring up that table? Sometimes it works in the global text search, and sometime it doesn't.

[patricklatella]

throughout the SysAdmin course, it is repeated that each table in the platform can be represented with something like [sys_user] for the Users table.   Where however do you actually input the [sys_user] to bring up that table?   Sometimes it works in the global text search, and sometime it doesn't.   Not sure I'm understanding where the [sys_user] version of representing the User table is used and for what purpose.   Thanks all.

[mamann · Accepted solution]

HI Patrick,

In the left hand navigation menu at the top, you can type in the table name +.list to open the list in the main frame. (or .LIST to open in a new tab). Example: sys_user.list

[kopp820]

You also will use sys_user if you're writing any code to query the user table. That's why it's important to know the system name of it since there are two "User" tables out of the box. The other one is imp_user.

[patricklatella]

thanks very much Kailey and Mark for the explanations!

[yetesh_ch]

Hi,

Yeah thats right. Summarizing, there are basically three uses:

1. To open a list view of table, type '<table_name>.list' in navigation menu

2. To open a form view of table i.e. new record in the table, type '<table_name>.do' in navigation menu

3. To write a script like:

var gr = new GlideRecord ('sys_user');