I have 2 separate searches.
search1 = 17 results
search2 = 20 results
Key column that exists in both searches is "target_id".
How do I show all results containing the target_id that are in search1 but not in search2? How can I solve this using multisearch, join, or subsearch or is there a better way?
Search 2 acts like a a filter.. I dont want to see any results in search1 that has the key column in search2.
Like this:
<search1> AND NOT [ <search2> | stats count BY target_id | table target_id ]
Like this:
<search1> AND NOT [ <search2> | stats count BY target_id | table target_id ]