Returning a new constant field in a subquery


1 comment

  • Official comment
    Matt Sullivan

    assuming you want to just show results from category1 where Id from category 2 is present, you might opt to move the subquery to the scoping portion of the query, and presuming category1 does not have a field named singleId, you must use the keywords modifier on the subquery. Net result is something like below

    | parse "Id * " as singleId
    | compose singleId keywords]

Please sign in to leave a comment.