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

[Rushi Savarkar]

Hello @dp11 

Please change the variable prefix of sys_email_attachment table from emailAttach to emailattach. You will get the desired output. 

Note: Don't use camel casing in database views

[dp11]

Thanks for your reply. I changed to emailattach and still no output.

[Rushi Savarkar]

Hello @dp11 

Now change the Where Clause for sys_email_attachment table like below:

emailattach_action='discarded'

It should work as it worked at my end

[dp11]

OK, did that:

Still empty result:

And as you can see below I have 101 of such records: