select t.PROJECT as 'Projekt',t.TASKID as 'Task-ID',t.TASKNAME as 'Name',t.TASKDESC as 'Beschreibung',
            t.STARTTIME as 'Beginn',t.ENDTIME as 'Ende',t.TASKRESP as 'Verantwortlich', t.ESTEFFPH as 'Planstunden',
           (CASE WHEN JSON_LENGTH(t.TASKATTRIB)=0 THEN '' ELSE  t.TASKID END) as 'Attribute' 
  from CCTASK t where PARENTID=?