04 February 2012
Support   »   Forums  
Forums

Search our forums for the answers to your questions.

Further support options include the FAQs and Knowledge Base.

Note - Please login if you want to post to the forums.
CELCAT Timetabler Forums
Forums > Installation & Configuration > Timetabler Server
Subject: CT_Log table
Prev Next
You are not authorized to post a reply.

AuthorMessages
MartinUser is Offline

Posts:4

08 Mar 2010 4:51 PM  

Hi

I would like to use the CT_log table to mimic the 'view history' available from the the event window. Can you tell me how show the actual table names staff names, room names, operations, etc rather than their foreign keys.

 

Thank you

simonUser is Offline

Posts:0

10 Mar 2010 3:33 PM  
We include a Log Viewer utility for this which is built into CELCAT Administrator. It allows you to filter activity within the timetable on our specific tables, such as "CT_Event" or a specific resource table such as "CT_Staff" or "CT_Rooms". The Log Viewer then displays results with column headers as Operation Name, Operation Mode, the User who made the change and additional information. In essence it's the Client View History feature and more.

Hope this helps.

CELCAT Technical
MartinUser is Offline

Posts:4

10 Mar 2010 4:33 PM  
Thanks for that- I will have a look at that report but really I need to mimic the report in SQL server SQL so that certain non-admin users can view the information as required.

I asume it is possible at the view history grid achieves it!
AntonyUser is Offline

Posts:21

16 Mar 2010 5:25 PM  

Perhaps the best way is to reverse engineer the log display by comparing the raw data with the LogViewer window

Rgds

Antony

You are not authorized to post a reply.
Forums > Installation & Configuration > Timetabler Server > CT_Log table



ActiveForums 3.7

Privacy Statement  |  Terms Of Use
Copyright © 2011 CELCAT, All Rights Reserved