ODBC Test Returns msg from results

jsimotas · Post by **jsimotas** » Sat Jul 02, 2005 2:53 am

I know there is a way to email the result value (column 1) of an ODBC test.
But this is typically just a threshold number.
How about if I want to email an error description from column 2 on the same row?

KS-Soft · Post by **KS-Soft** » Sat Jul 02, 2005 2:30 pm

You may choose any column you want. ODBC Query test allows you to choose column that you want to check.
Or you want to check one column but send bye-mail value of another column?

Regards
Alex

jsimotas · Post by **jsimotas** » Tue Jul 05, 2005 6:07 am

KS-Soft wrote:Or you want to check one column but send bye-mail value of another column?

Yes that's what i mean

KS-Soft · Post by **KS-Soft** » Wed Jul 06, 2005 8:28 pm

I have added your request into "to do" list but I am not sure when it will be implemented.
As workaround you may create auxiliary test (TestA) item that will retrieve and display field A ("another column"). Use check condition that may never happen so test item always will be "Ok". Then you may setup TestA as Master test for the existent test item (TestB) - in this case TestA will be performed before TestB and retrieve up-to-date value of the field. Alert profile that sends e-mail should be assigned to TestB (test that really checks some field); using variable like %::TestA::Reply% in the e-mail body you may send both fields

Regards
Alex