Difference between two columns named "created" under "sc_task_sla table"

vat2do
Tera Contributor

Dear Community Members,

 

What is the difference between below mentioned columns and which one should be used if we need to get the request created date/time in excel report.

Created(sct_sys_created_on)

Created(taskslatable_sys_created_on)

 

Thanks in advance

1 ACCEPTED SOLUTION

Hi @vat2do ,

 

You want created date for Request item of the task. Right? 

If yes, please configure List Layout using dot walk as shown below.

 

Himani_14_0-1714634887364.png

Thanks

Himani

View solution in original post

3 REPLIES 3

Himani_14
Mega Sage
Mega Sage

Hi @vat2do ,

 

sc_task_sla is database view created using below 2 tables :

1. task_sla (Task SLA) having variable prefix as taskslatable

2. sc_task (Catalog Task) having variable prefix as sct

 

This means

Created(sct_sys_created_on) : This is created date for Catalog Task table

Created(taskslatable_sys_created_on) : This is created date for Task SLA

 

Please have a look at below screenshot for more clarity.

 

Himani_14_0-1714633820987.png

 

Also to get Request Item created date, please configure List Layout using dot walk as shown below.

 

Himani_14_1-1714634577172.png

 

 

Thanks

Himani

 

vat2do
Tera Contributor

Thanks @Himani_14 for explaining.

 

Now question remains is what should be used in order to get the very first creation date/time either Created(taskslatable_sys_created_on) or Created(sct_sys_created_on)?

Hi @vat2do ,

 

You want created date for Request item of the task. Right? 

If yes, please configure List Layout using dot walk as shown below.

 

Himani_14_0-1714634887364.png

Thanks

Himani