Hi All,
I would like to generate a Report of list of documents in a folder related to a particulate Category. I would like the following attributes in my report:
Document Name, Attribute1, Attribute2 etc.
Thanks
What is the nature of the category's relation?
Is said category applied to these items, or does the category have some sort of metadata that logically ties it back to these documents?You can get a list of items from within a folder by joining DTree on DBrowseAncestors/DTreeAncestors, wherein AncestorID = the ParentID/DataID (of the Folder).
If you want subfolder contents, otherwise you can just Select * FROM DTree WHERE ParentID = YourFolderID
If it has to do with categories applied to items, then you throw on LLAttrData, optionally, with CatRegionMap, to see what DataIDs have a particular DefID (category) and/or AttrID (attribute of a given category).
