View previous topic :: View next topic |
Author |
Message |
jsimotas
Joined: 02 Jul 2005 Posts: 5
|
Posted: Sat Jul 02, 2005 2:53 am Post subject: ODBC Test Returns msg from results |
|
|
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? |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Sat Jul 02, 2005 2:30 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
jsimotas
Joined: 02 Jul 2005 Posts: 5
|
Posted: Tue Jul 05, 2005 6:07 am Post subject: |
|
|
KS-Soft wrote: | Or you want to check one column but send bye-mail value of another column? |
Yes that's what i mean |
|
Back to top |
|
|
KS-Soft
Joined: 03 Apr 2002 Posts: 12795 Location: USA
|
Posted: Wed Jul 06, 2005 8:28 pm Post subject: |
|
|
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 |
|
Back to top |
|
|
|