Help needed using a column of results returned in a second query (Chained input).
I'm aware of an example in the docs showing chained input but it does not seem to work or be suitable for adaptation.
I would like the first search to return a list of unique ID's that are used as part of the second query, this will eventually be a watcher job so I would like it to run in a "single" query.
Any help is useful, thanks