Combine 2 searches with 2nd search dependent on first

I am trying to combine 2 searches into one. However, the results for the 2nd search should only return if there are results in the first one.

If no results in the first query, then nothing should be returned. If there are results from the first one, then display the returns from the 2nd search

First query:
| where jobName="test_job1" AND statusText in ("FAILURE", "SUCCESS")

Second query:
| where like(jobName,"test%") AND statusText="FAILURE" | stats earliest(statusText) as FirstFailure, earliest(timestamp) as FirstFailureTime by jobName, machine
| join jobName
[search index=batch | where like(jobName,"test%") | stats latest(statusText) as Latest
Status, latest(timestamp) as LastUpdatedtime by jobName]
| sort by LastUpdatedtime desc

Any help would be appreciated. Thanks

Tags (1)
0 Karma