• Replies 1 reply
  • Subscribers 337 subscribers
  • Views 163 views
  • Users 0 members are here
Related

List of Patrons with Documents on their account

Jen Skelly
$organization

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

Parents
  • $organization

    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 d
    LEFT JOIN TR_DOCUMENT_CATEGORY c ON d.category = c.id
    WHERE 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

Reply
  • $organization

    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 d
    LEFT JOIN TR_DOCUMENT_CATEGORY c ON d.category = c.id
    WHERE 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

Children
No Data