Would it be possible to create a report that lists the date a tab or any of the modules on a tab was last modified?  I looked through the Tabs and TabModules tables in the database and there doesn't seem to be field that I can build a query against that will give me this information.  We have approx 45 users that are responsible for maintaining different parts of a portal and the we would like to ensure that this is being done on a routine basis.  Any help would be greatly appreciated.

Thanks and regards,

rdv

The problem here is one of tracking. Since each module has its own definition of "last modified date", the core does not make any attempt to track it. The only way it could track it is if the modules reported to the Core when they are making modifications, which they don't.

Sample reports are a bit lacking, since the actual development consumes such a large portion of my time, however if you want to retrieve data for each page, you need to start with a list of pages:

SELECT * FROM {oQ}Tabs

Then, lets say you had some data in a table called "Foo" that was related to each page (using a column TabID), you can include that data using an INNER JOIN:

SELECT T.*, F.* FROM {oQ}Tabs AS T INNER JOIN Foo AS F ON F.TabID = T.TabID

Once Reports 5.0 is out the door, I'll be focusing on improving the documentation, but until then keep asking questions here and I'll be happy to answer them to the best of my ability.

Andrew Nurse
DotNetNuke Core Team Member and Reports Module Project Lead
Microsoft Certified Professional Developer