postgresql - Jive 5.0当前头像

我正在尝试从Jive5.0数据库导出配置文件图像。我有一个postgre查询，可以提取图像。但是我很难确定哪个图像是当前为该配置文件选择的图像。

select *
from jiveuser u
    LEFT JOIN jiveusercontainer c ON u.userid = c.userid
    LEFT JOIN jivecontent ct ON ct.containerid = c.usercontainerid
    left join jiveattachment ja on ja.objectid = ct.contentid
WHERE ct.contenttype = 501  and
    ja.objecttype = 501 and
    u.userid in (4794)  and
    filename = 'profile_image_500.png'
order by ja.modificationdate desc

有人知道Jive数据库中存储这些信息的位置吗？

最佳答案

这是我认为将拉取当前配置文件图像的查询：

select  ja.attachmentid, c.displayname, ja.creationdate, ja.filename , (select propvalue from jivecontentprop jcpi where jcpi.contentid = ct.contentid and propname = 'index' )
from jiveuser u
    LEFT JOIN jiveusercontainer c ON u.userid = c.userid
    LEFT JOIN jivecontent ct ON ct.containerid = c.usercontainerid
    left join jiveattachment ja on ja.objectid = ct.contentid
WHERE ct.contenttype = 501  and
    ja.objecttype = 501 and
    u.userid in (4794)  and
    filename = 'profile_image_500.png'
order by propvalue
limit 1

关于postgresql - Jive 5.0当前头像，我们在Stack Overflow上找到一个类似的问题：https://stackoverflow.com/questions/21838459/