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

[vat2do]

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

[Himani_14]

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.

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

Thanks

Himani

[vat2do]

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)?

[Himani_14 · 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.

Thanks

Himani