Hey all! Hope you're well.
I was wondering if anyone had a snappy way of pulling a list of folks who have documents attached to their files.
I am sure that I could do it before, but I assume with the new documents radio button...things may have changed. (Or I am just tired LOL)
Jen
Hi Jen,
This is Zach Domrese from the Support team at Tessitura Network. Here is a quick query you can use:
SELECT DISTINCT parent_object_id FROM VS_DOCUMENT dLEFT JOIN TR_DOCUMENT_CATEGORY c ON d.category = c.idWHERE c.parent_table_name = 'T_CUSTOMER'
The WHERE clause removes documents from other places such as steps and this query can be put directly into a list using the Show Query option.
Please let me know if you have any questions!
Thanks,
Zach