
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-06-2016 11:49 PM
Hi, can anyone explain sys_class_name?
Because I am try to dotwalk from the sysapproval_approval table to the specific catalog item.
Is there a way to dotwalk to the catalog item level in the sysapproval_approval table?
Thank!
Tadz
Solved! Go to Solution.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2016 06:38 PM
Hi Cris,
The field 'sys_class_name' is used on extended-table systems and essentially stores the extended type for the record. The best way to see is by example...
If you look at the Task [task] table, you will see in the 'sys_class_name' field names from all of the tables that are extended from Task:
- incident
- sc_request
- sc_req_item
- change_request
- change_request_task
- (etc.)
So an INC record gets a sys_class_name of 'incident', and so on. You can use this, for example, if you want to query the Task table for all task-types but still be able to tell them apart.
Does that help your understanding?
-Brian
Edit: So for your UI Action conditions example, you might create an action for the Task table to be available for most tasks, but that you DO NOT want to show up for Incidents in particular. You could enter as the condition:
current.sys_class_name != incident
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2016 02:06 AM
Hi Cris,
If you are creating a BR then you can simply get the table name by dot walking (current.sysapproval.sys_class_name).
PS; Hit like/correct/helpful if it solves your issue.

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2016 05:37 PM
HI Anupama, I was trying to create a UI action and I'm trying to dotwalk from the conditions.
Thanks,
Tadz

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2016 06:38 PM
Hi Cris,
The field 'sys_class_name' is used on extended-table systems and essentially stores the extended type for the record. The best way to see is by example...
If you look at the Task [task] table, you will see in the 'sys_class_name' field names from all of the tables that are extended from Task:
- incident
- sc_request
- sc_req_item
- change_request
- change_request_task
- (etc.)
So an INC record gets a sys_class_name of 'incident', and so on. You can use this, for example, if you want to query the Task table for all task-types but still be able to tell them apart.
Does that help your understanding?
-Brian
Edit: So for your UI Action conditions example, you might create an action for the Task table to be available for most tasks, but that you DO NOT want to show up for Incidents in particular. You could enter as the condition:
current.sys_class_name != incident

- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎03-07-2016 06:42 PM
Thank you Brian,
It really helped me undestand what sys_class_name is.
Thanks,
Tadz