Hi everyone, Is it possible to achieve this: My search has resulted in four columns Column1 Column2 Column3 Column4 ------ ------- ------- ------- Type1 Source1 OK(status) Item1 Type2 Source2 OK(status) Item2 Type3 Source3 BAD(status) Item3 Type4 Source4 OK(status) Item4 Type5 Source5 BAD(status) Item5 Type6 Source6 BAD(status) Item6 I wish to send an email periodically with this text: At this time, Items: Item1, Item2, Item4 are OK, and Item3, Item5, Item6 are BAD. Is it possible to filter Items based on Column3 and get all fields in a single line in order to put them in a message which will also be part of the resulting query? If it is not possible to make both cases - OK and BAD in the same line, it would be nice to have only one working.
... View more