I have an issue where events are displaying incorrect information for a particular field in my search.
Example:
mySearch | table field 1, field 2, field 3, field 4, field 5, field 6, field 7
My problem is fields 4, 6, and 7 somewhat correspond with one another.
field 5 = errorCode
field 6 = errorMessage
field 7 = output string
If "field 5" = success ----------then "field 6" is null----------- and "field 7" shows the correct output string
HOWEVER
If "field 5" = an error code------- then "field 6" will show the error message-------BUT "field 7" shows the incorrect output string
What I am trying to do is evaluate "field 5", and if "Field 5" equals anything other than "success" string then "field 7" will equal a new string of my choice. If "field 5" equals "success" than leave "field 7" alone.
... View more