element_id in journal entry table doesn't map to incident number

[Bonnie4]

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?

[Ankur Bawiskar]

Hi,

please share your configuration

Regards
Ankur

[Onkar Pandav · Accepted solution]

Hi,

Try to create database view on "Incident" and "Journal Entry" tables.

Further try writing a where clause on Journal Entry table like inc_sys_id=journal_element_id.

(Assuming prefix inc for incident and journal for journal entry tables).

[Bonnie4]

journal_element_id=task_sys_id

It is working. The missing incidents were the one that migrated from an old system, hence don't have journal collected in the new system 🙂

All good now thanks

[Bonnie4]

Please see the conf of the db view. It contains 2 table sy_journal_field and incident

And

the conf for journal entry table

The conf for incident table