Hmm, maybe not the right answer for you but I prefer to get the information from the database directly.

Perhaps I cover your request here:  On-demand session: Useful SQL statements in IM&G - examples for Vibe, Filr, SMG, Retain 

Hmm, maybe not the right answer for you but I prefer to get the information from the database directly.

Perhaps I cover your request here:  On-demand session: Useful SQL statements in IM&G - examples for Vibe, Filr, SMG, Retain 

Thanks. Looking through that I made a quick change and came up with:

SELECT S.sharerid as sharer, P1.title Wer,
S.sharedentity_id as ID2, F.title as Was,
S.recipient_id as recipient, P2.title as
AnWen,comments, daystoexpire, enddate
FROM public.ss_shareitem as S
LEFT JOIN public.ss_principals as P1 ON
S.sharerid = P1.id
LEFT JOIN public.ss_principals as P2 ON
S.recipient_id = P2.id
LEFT JOIN public.ss_forums as F ON
S.sharedentity_id = F.id
WHERE S.sharerid = <Filr User ID>;

Is there a reason F.title as Was would return NULL for some shares? Even if I change this to F.pathname I still see NULL. What is interesting is that the following SQL command returns NULL. Maybe the file was shared and then removed, removing it from ss_forums but the share remains in ss_shareitem?

SELECT * FROM "public"."ss_forums" WHERE id = <Share ID returning NULL>;

The above SELECT returns 9 shared items while the GUI shows 8 shared items for the indicated user.