Database view and Document ID

[dp11]

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"

https://www.servicenow.com/community/developer-forum/export-the-sys-id-of-document-id-column-instead...

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

[dp11]

Oh the attachment field is blank because it has got discarded due to the max size limit. We should not see an attachment where "action = Discarded"

[Rushi Savarkar]

Okay, but I am still able to see the records in database view with the current Where Clause. Please follow the manual steps I have provided in the above response without adding an attachment

[dp11]

In any case I went ahead and manually created an email attachment record with non-empty attachment as per your suggestion. But, that still did not show up in the database view output

[Rushi Savarkar]

I am giving you my Email Attachment, Email, Ticket record and Database view record. Please import it into the respective table. Hope it works

[dp11]

Thank you so much for sending the xmls and I imported them all. Added the tables to the database view. But when I click on Try it, nothing is returned. Can you please share a screenshot of your view results for this example?