Dot Walk current.sysapproval.sys_class_name == 'sc_req_item'

Tadz
Tera Guru
Tera Guru

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

1 ACCEPTED SOLUTION

Brian Dailey1
Kilo Sage

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


View solution in original post

5 REPLIES 5

anupama8
Tera Expert

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.


HI Anupama, I was trying to create a UI action and I'm trying to dotwalk from the conditions.



Thanks,



Tadz


Brian Dailey1
Kilo Sage

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


Thank you Brian,



It really helped me undestand what sys_class_name is.



Thanks,



Tadz