5 Replies Latest reply: Jun 20, 2018 9:39 AM by Mark Ritter RSS

    Script Coding Question

    Mark Ritter

      I was provided with this standard sql code by a developer and am having trouble figuring out how to get it setup in QS script to work properly.  Any advice would be greatly appreciated.


      SELECT tp.sessionkey, COUNT(*)

      FROM transactions te

      JOIN transactions tp ON tp.k = te.parentkey

      WHERE te.srcfile LIKE '2018-05-09%'

      AND te.worktype IN ('envelope')

      GROUP BY tp.sessionkey ;