Hello all,
I have been scanning the community for all articles related to Document ID with the goal of obtaining the sys_id from that type of value. And it seems its not that simple. One suggestion in the following post was:
"I don't think you can get sysId directly of the record being referred by Document ID field....
you can try to create database view table and then export and then it might contain sysId"
I am trying that approach. Here is my database view:
So, I am trying to get all email attachments that were discarded. Then obtaining the email referenced in those. And obtaining the task (specifically Ticket) referenced in the email's 'instance' field (which is of Document ID type).
However no record is being returned and I have 101 records that satisfy the conditions. Can anyone see what is wrong here?
Also, this is very similar to the OOTB incident_metric one and that works fine:
Note: The mi_definition field is of type Document ID.
Appreciate any help.
Thanks,
Deb
