Hi all,
In the Select Expert, how do I add a certain criterium that sound like:
"Records should have at least a history where field RESULT=DO_LATER, but may have other results (later on) as well"
I'll Explain with examples. Here's a single record:
TIME MACHINEID RESULT
5-may-2008 mach1 DO_LATER
So far so good. Here's another example:
TIME MACHINEID RESULT
5-may-2008 mach1 DO_LATER
6-may-2008 mach1 ALL_DONE
There it is. This "mach1" has a history of "DO_LATER" and therefore I'd like to export all results of "mach1", whatever it did after "DO_LATER".
Here's another example:
TIME MACHINEID RESULT
5-may-2008 mach1 DO_LATER
6-may-2008 mach1 ALL_DONE
6-may-2008 mach2 ALL_DONE
So "mach1" we are interested in, but not "mach2". It has no history of "DO_LATER".
So we'd like to observe whether machines that will process tasks later actually do that. Perhaps they don't and report an error or even another "DO_LATER" event.
I'd be jolly happy if anyone could help me out.