I need the where clause with 2 conditions :
1- tsk_opened_at >= DATE('2017-01-01') but nothing happend.....
2- (tsk_sys_class_name ='request' || tsk_sys_class_name ='incident' || tsk_sys_class_name ='catalog task' || tsk_sys_class_name ='external customer support' )
I have tried in differents way many times without any results.
Coud someone advice me ?
It seems you cant create a DB view with only one table, a workaround would be to add the task table a second time with prefix tsk2.
Then in tsk2 where clause set:
tsk_sys_id = tsk2_sys_id && tsk_opened_at > '2017-01-01 08:00:00' &&
(tsk_sys_class_name ='sc_request' ||
tsk_sys_class_name ='incident' ||
tsk_sys_class_name ='sc_task' ||
tsk_sys_class_name ='u_external_customer_support'
Also make sure you are using the table name, not the label, for example sc_request instead of Request
Hi Arnoud,
I tried on this way with sys_created_on but I'm only receiving the sys_class_name='request'. I'm very sure that I have more data for the others sys_class_name
It seems you cant create a DB view with only one table, a workaround would be to add the task table a second time with prefix tsk2.
Then in tsk2 where clause set:
tsk_sys_id = tsk2_sys_id && tsk_opened_at > '2017-01-01 08:00:00' &&
(tsk_sys_class_name ='sc_request' ||
tsk_sys_class_name ='incident' ||
tsk_sys_class_name ='sc_task' ||
tsk_sys_class_name ='u_external_customer_support'
Also make sure you are using the table name, not the label, for example sc_request instead of Request
