Command on Delete of test

totte · Joined: 30 May 2007 Posts: 55

Hi

We are using an SQL database with 2 tables for loggning. One table that has data that is updated often and one that contains data that is not updated very often.

I would like hostmonitor to run a sql command when a test is removed so that I can set the test as deleted in the database aswell.

Regards
Christoffer
Hogia

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

Run SQL Query after each or some modifications in test list?
I have added your request into "to do" list but I am not sure when it can be implemented.

Regards
Alex

totte · Joined: 30 May 2007 Posts: 55

Hi

Is it possible to get Testid in an report?

I thought I could make a report which I then can compare with the database until the function is implemented

//Christoffer
Hogia

KS-Soft · Joined: 03 Apr 2002 Posts: 12795 Location: USA

You may use Custom report and %TestID% variable
Such report type was designed for HTML reports but it can generate simple text file as well. You may use empty "header", "folder title", "folder summary", "footer" fields, type "%TestID% on "Test items" page and apply "Use selected template for all statuses" popup menu item to copy this template.

Please check the manual or visit our web site for details
http://www.ks-soft.net/hostmon.eng/mframe.htm#profiles.htm#CustomHTML

Regards
Alex