10 Replies Latest reply on Jul 8, 2015 9:10 AM by mark_wiley_miller@mac.com

    Help with ExecuteSQL

    mark_wiley_miller@mac.com

      The Let Statement below works until I add the Where clause, not sure what is wrong with this syntax, Any help appreciated

       

      Let (

       

       

      callCount = ExecuteSQL(

       

       

      "SELECT COUNT (Type) AS agg FROM Call_Log

        WHERE Au.Created.Date >= \'2014-01-01\'

        GROUP BY Type"

      ;

       

       

      ""; ¶) ;

       

       

      callCount

       

       

      )