myAttrs = StructNew(); myAttrs.categoryId = portletDefinition.portletConfig.categoryId; if( myAttrs.categoryId eq "" ) { myAttrs.categoryId = 0.1; } myAttrs.includeCategory="yes"; myAttrs.isPrivate = 1; myAttrs.fspro_userid = client.id; myAttrs.authorizedGroups = client.listgroups; if( client.brokerId neq 0) { myAttrs.brokerId = client.brokerId; } myAttrs.docLibVersion = 2; myAttrs.ownerId = client.ownerId; myAttrs.ownerType = client.ownerType; myAttrs.datasource = client.datasource; myAttrs.queryName = "qmd_documentList"; myAttrs.cc_itemId = 0; myAttrs.sortOrder = "doc.SortRank, doc.DocTitle"; myAttrs.slctflds = "distinct doc.DocID, doc.DocTitle, doc.DocDescription, doc.FileSize, doc.FileExt, path.DocPath, doc.PswrdProtect, doc.DocPassword, doc.sortrank, doc.UploadDate, dclnk.child_attrID myCatId";

select distinct * from qmd_documentList where myCatId = order by sortRank, docTitle

#categoryTitleToUse#

#DocTitle#

#portletDefinition.portletConfig.emptyMessage#