Report to get only folders to match with certain phrase

Dhana_Marothu

hi ,

i am looking for the list of folders which are having certrain phrase (for e.g 'abc ' in the phrase) with additional information who has created and who has modified latest.

can any one help me to get the report using MS SQLquery?

 

Thanks,

Lakshmi

Colin_Schmidt

select dta.parentid "ParentID", dtp.name "Parent Folder", dta.dataid "DataID", dt.name "Object Name", 

case dt.subtype when 0 then 'Folder' when 1 then 'Alias' when 128 then 'WF map' when 136 then 'Compound doc' when 140 then 'URL' when 141 then 'Enterprise WS' when 142 then 'Personal WS' when 144 then 'Document' when 145 then 'Text doc' when 202 then 'Project' when 223 then 'Form' when 230 then 'Template' when 268 then 'Template folder' when 299 then 'Report' when 543 then 'Project template' when 749 then 'Email' else 'Subtype ['+CAST(dt.subtype as nvarchar)+']' end SubtypeD, 

case when dta.acltype=1 and dta.rightid<1 then 'Owner' when dta.acltype=1 and dta.rightid>0 then 'Owner: '+k.name when dta.acltype=2 and dta.rightid<1 then 'Owner Group' when dta.acltype=2 and dta.rightid>1 then 'Owner Group: '+k.name when dta.acltype=3 and dta.rightid<1 then 'Public Access' when dta.acltype=4 and dta.rightid<1 then 'System Admin' when dta.acltype=4 and dta.rightid>1 then 'System Admin: '+k.name when dta.acltype=0 then 'Assigned: '+k.name else k.name end GroupID, 

case when (dta.permissions&2) = 2 then 'See' end See,

case when (dta.permissions&36865) = 36865 then 'See Contents' end SeeCon, 

case when (dta.permissions&65536) = 65536 then 'Modify' end Modify,

case when (dta.permissions&16) = 16 then 'Edit Permissions' end EditP, 

case when (dta.permissions&131072) = 131072 then 'Edit Attributes' end EditA,

case when (dta.permissions&4) = 4 then 'Add Items' end AddI, 

case when (dta.permissions&16384) = 16384 then 'Delete Versions' end DelV, 

case when (dta.permissions&8) = 8 then 'Delete' end Del, 

case when (dta.permissions&8192) = 8192 then 'Reserve' end Reserve 

from dtreeancestors dtan 

join dtreeacl dta on dtan.dataid = dta.dataid 

join dtree dt on dta.dataid = dt.dataid 

left outer join kuaf k on dta.rightid = k.id 

left outer join dtree dtp on dta.parentid = dtp.dataid 

where dtan.ancestorid = %1  

order by dta.parentid, dt.name, dta.acltype

Colin J.

On Wed, Mar 11, 2015 at 3:33 AM, eLink Entry: Content Server LiveReports Forum <livereportsdiscussion@elinkkc.opentext.com> wrote:

Report to get only folders to match with certain phrase

Posted bydmarothu@rambus.com (Marothu, Dhana)On 03/11/2015 03:28 AM

hi ,i am looking for the list of folders which are having certrain phrase (for e.g 'abc ' in the phrase) with additional information who has created and who has modified latest.can any one help me to get the report using MS SQLquery? Thanks,Lakshmi

---

[To post a comment, use the normal reply function]
Forum:	Content Server LiveReports Forum
Content Server:	Knowledge Center

This electronic message contains information from MeadWestvaco Corporation (mwv.com) or subsidiary companies, which may be confidential, privileged or otherwise protected from disclosure. The information is intended to be used solely by the recipient(s) named. If you are not an intended recipient, be aware that any review, disclosure, copying, distribution or use of this transmission or its contents is prohibited. If you have received this transmission in error, please notify MeadWestvaco immediately at postmaster@mwv.com.