MenuQueries LibrarySend an email with summary of activitySend an email with summary of activityThis query sends an email indicating the number of new comments added to the site for several periods of time: In the last 24 hs In the last 1 year Since the beginning of the month Since the beginning of the year query CountComments { DATE_ISO8601: _env(name: DATE_ISO8601) @remove timeToday: _time dateToday: _date(format: $__DATE_ISO8601, timestamp: $__timeToday) timeYesterday: _intSubtract(subtract: 86400, from: $__timeToday) dateYesterday: _date(format: $__DATE_ISO8601, timestamp: $__timeYesterday) time1YearAgo: _intSubtract(subtract: 31536000, from: $__timeToday) date1YearAgo: _date(format: $__DATE_ISO8601, timestamp: $__time1YearAgo) timeBegOfThisMonth: _makeTime(hour: 0, minute: 0, second: 0, day: 1) dateBegOfThisMonth: _date(format: $__DATE_ISO8601, timestamp: $__timeBegOfThisMonth) timeBegOfThisYear: _makeTime(hour: 0, minute: 0, second: 0, month: 1, day: 1) dateBegOfThisYear: _date(format: $__DATE_ISO8601, timestamp: $__timeBegOfThisYear) commentsAddedInLast24Hs: commentCount(filter: { dateQuery: { after: $__dateYesterday } } ) @export(as: "commentsAddedInLast24Hs") commentsAddedInLast1Year: commentCount(filter: { dateQuery: { after: $__date1YearAgo } } ) @export(as: "commentsAddedInLast1Year") commentsAddedSinceBegOfThisMonth: commentCount(filter: { dateQuery: { after: $__dateBegOfThisMonth } } ) @export(as: "commentsAddedSinceBegOfThisMonth") commentsAddedSinceBegOfThisYear: commentCount(filter: { dateQuery: { after: $__dateBegOfThisYear } } ) @export(as: "commentsAddedSinceBegOfThisYear") } query CreateEmailMessage @depends(on: "CountComments") { emailMessageTemplate: _strConvertMarkdownToHTML( text: """ This is the number of comments added to the site: | Period | # Comments added | | --- | --- | | **In the last 24 hs**: | {$commentsAddedInLast24Hs} | | **In the last 365 days**: | {$commentsAddedInLast1Year} | | **Since begginning of this month**: | {$commentsAddedSinceBegOfThisMonth} | | **Since begginning of this year**: | {$commentsAddedSinceBegOfThisYear} | """ ) emailMessage: _strReplaceMultiple( search: [ "{$commentsAddedInLast24Hs}", "{$commentsAddedInLast1Year}", "{$commentsAddedSinceBegOfThisMonth}", "{$commentsAddedSinceBegOfThisYear}" ], replaceWith: [ $commentsAddedInLast24Hs, $commentsAddedInLast1Year, $commentsAddedSinceBegOfThisMonth, $commentsAddedSinceBegOfThisYear ], in: $__emailMessageTemplate ) @export(as: "emailMessage") } mutation SendDailyStatsByEmailNumberOfComments( $to: [String!]! ) @depends(on: "CreateEmailMessage") { _sendEmail( input: { to: $to subject: "Daily stats: Number of new comments" messageAs: { html: $emailMessage } } ) { status } }CopyPrevSend an email with dynamic dataNextSubscribe an email on a Mailchimp list
This query sends an email indicating the number of new comments added to the site for several periods of time: In the last 24 hs In the last 1 year Since the beginning of the month Since the beginning of the year query CountComments { DATE_ISO8601: _env(name: DATE_ISO8601) @remove timeToday: _time dateToday: _date(format: $__DATE_ISO8601, timestamp: $__timeToday) timeYesterday: _intSubtract(subtract: 86400, from: $__timeToday) dateYesterday: _date(format: $__DATE_ISO8601, timestamp: $__timeYesterday) time1YearAgo: _intSubtract(subtract: 31536000, from: $__timeToday) date1YearAgo: _date(format: $__DATE_ISO8601, timestamp: $__time1YearAgo) timeBegOfThisMonth: _makeTime(hour: 0, minute: 0, second: 0, day: 1) dateBegOfThisMonth: _date(format: $__DATE_ISO8601, timestamp: $__timeBegOfThisMonth) timeBegOfThisYear: _makeTime(hour: 0, minute: 0, second: 0, month: 1, day: 1) dateBegOfThisYear: _date(format: $__DATE_ISO8601, timestamp: $__timeBegOfThisYear) commentsAddedInLast24Hs: commentCount(filter: { dateQuery: { after: $__dateYesterday } } ) @export(as: "commentsAddedInLast24Hs") commentsAddedInLast1Year: commentCount(filter: { dateQuery: { after: $__date1YearAgo } } ) @export(as: "commentsAddedInLast1Year") commentsAddedSinceBegOfThisMonth: commentCount(filter: { dateQuery: { after: $__dateBegOfThisMonth } } ) @export(as: "commentsAddedSinceBegOfThisMonth") commentsAddedSinceBegOfThisYear: commentCount(filter: { dateQuery: { after: $__dateBegOfThisYear } } ) @export(as: "commentsAddedSinceBegOfThisYear") } query CreateEmailMessage @depends(on: "CountComments") { emailMessageTemplate: _strConvertMarkdownToHTML( text: """ This is the number of comments added to the site: | Period | # Comments added | | --- | --- | | **In the last 24 hs**: | {$commentsAddedInLast24Hs} | | **In the last 365 days**: | {$commentsAddedInLast1Year} | | **Since begginning of this month**: | {$commentsAddedSinceBegOfThisMonth} | | **Since begginning of this year**: | {$commentsAddedSinceBegOfThisYear} | """ ) emailMessage: _strReplaceMultiple( search: [ "{$commentsAddedInLast24Hs}", "{$commentsAddedInLast1Year}", "{$commentsAddedSinceBegOfThisMonth}", "{$commentsAddedSinceBegOfThisYear}" ], replaceWith: [ $commentsAddedInLast24Hs, $commentsAddedInLast1Year, $commentsAddedSinceBegOfThisMonth, $commentsAddedSinceBegOfThisYear ], in: $__emailMessageTemplate ) @export(as: "emailMessage") } mutation SendDailyStatsByEmailNumberOfComments( $to: [String!]! ) @depends(on: "CreateEmailMessage") { _sendEmail( input: { to: $to subject: "Daily stats: Number of new comments" messageAs: { html: $emailMessage } } ) { status } }Copy