title: Is there a way to use a value in a JSON array (or any array for that matter) as an argument within a KQL query?
body: <p>EDIT:</p>
  <p>Let me try to make it more helpful.</p>
  <p>I run a general query that contains, as part of the results, the aforementioned JSON Array:</p>
  <pre><code>My_workspace
  | where ArgumentOne == &quot;ThisIsArgumentOne&quot;
  | project Time, ArgumentOne, Data_Set_One
  </code></pre>
  <p>So i get many results and one of them reads like this:</p>
  <div class="s-table-container">
  <table class="s-table">
  <thead>
  <tr>
  <th>Time</th>
  <th>ArgumentOne</th>
  <th>Data_Set_One</th>
  </tr>
  </thead>
  <tbody>
  <tr>
  <td>2022-09-01 12:00:00</td>
  <td>ThisIsArgumentOne</td>
  <td>[&quot;value1&quot;,&quot;value2&quot;,&quot;value3&quot;,&quot;value4&quot;,&quot;value5&quot;]</td>
  </tr>
  </tbody>
  </table>
  </div>
  <p>After getting my results i want to search for everything that contains one of the values from Data_Set_One as a parameter in Data_Set_One</p>
  <p>e.g from my original query something like</p>
  <pre><code>My_workspace
  | where Data_Set_One contains &lt;INSERT COMMAND HERE&gt; [&quot;value1&quot;,&quot;value2&quot;,&quot;value3&quot;,&quot;value4&quot;,&quot;value5&quot;]
  </code></pre>
  <p>Again, even a way to look for an item within an array, having to modify the JSON entry in some way would be welcome.</p>