I am asked to created a report on customer communication for incident. I created a database view to link the journal entry table with task table by element_id in journal entry table with sys_id in task table. But element id from journal entry doesn't amp to the sys_id in task tabel when task type is incident. May I please ask if anyone know if there is anything can be done to resolve this?
I also copied some element id from journal entry table and searched them in incident table. No match found. However, if I join journal entry table with task table, there are match found for requested items.
