Hi, I'm trying to filter the results from one search based on the results from another search. Example: Consider the following table of data user eventId Joe 1 Joe 2 Bob 3 I have created a search that returns only eventIds generated by user Joe and creates a token with the result <search>
<query> "event created" user=Joe | table eventId </query>
<done>
<set token="eventId">$result.eventId$</set>
</done>
</search> I have another table with the following data eventId eventName 1 myEvent_1 2 myEvent_2 3 myEvent_3 What I would like to do is create a search that will return just the eventId and eventName that was generated by user Joe using the token created in the first search. So far I have this query "event names" eventId=$eventId$ | table eventId eventName This query is only returning the first result from the token list rather than every result. Is there a way to use the token this way to return results from all values in the token? I would like to avoid using JOIN or subsearches as I will need to create multiple tables with the same token filter and those methods would start to get very slow. Thanks in advance!
... View more