9 lines
465 B
SQL
9 lines
465 B
SQL
--vesp_getformatfields 'ATTACHNUM1'
|
|
|
|
--select formatid, count(*) cnt from vefn_getversionformatitems('') where formatid in (39, 38, 41, 136) group by formatid
|
|
|
|
select vn.foldername, dbo.ve_getshortpathfromcontentid(cc.contentid)
|
|
from vefn_getversionformatitems('') vi
|
|
join vefn_getversionnames() vn on vi.versionid = vn.versionid
|
|
join contents cc on cc.contentid = vi.contentid
|
|
where (vi.formatid = 41 and cc.type = 10004) or (vi.formatid = 136 and cc.type = 10005) |