Hello all,

Does anyone know of a module or how to display the most popular documents within a portal? I used a dnnsql view module to write a small sql query to display the most popular documents, however, the documents get tracked within the documents table so all portals' docs are shown in the query.

Any info/suggestions/insight would be great.

thanks,
K

my sql query is very basic as my sql knowledge is basic.

my query is as follows:

SELECT Top 5 *
FROM Documents, UrlTracking
WHERE Documents.URL=
UrlTracking.Url
Order By Clicks DESC

I then am able to link the appropriate doc by using the DNNSQLView module to display an xsl doc.

My question is how, if possible, do I distinguish one portal's doc from another?

Genius. Now I have run into a problem because the Documents table stores the url as "FiledID." What table does one figure out the full url that these docs are stored as? For instance, when you click on edit a document, you see a full url, but I can not find where in the database that is stored. Maybe with that info, I can figure out how to finish off this problem.

thanks,

K