AMA 1시간 전

Date
October 5, 2023 7:00 PM (GMT+9)
  • 푸시 내용
    • EN
    KR
    AMA starts in 1 hour
    1시간 뒤, AMA가 시작돼요
    (Ad) Catch us on YouTube in a while!
    (광고) 잠시 후, 유튜브에서 만나요!
  • 발송 조건
    • 버전 1.0.5~7 v49 이상
    • 마케팅푸시 수신 동의
  • 진입화면
    • Home

푸시알림 예약 내역 (by Eric)

{
    "user_query": "SELECT u.id, u.fcm_token, u.timezone_offset, u.language FROM users u WHERE u.agree_push_alert = true AND u.push_alert_permission = 'granted' AND u.agree_push_alert = true AND u.agree_push_marketing = true AND client_version IS NOT NULL AND client_version  <> '' AND CAST(SPLIT_PART(client_version , '.', 3) AS INTEGER) >= 5 AND CAST(SPLIT_PART(client_version , '.', 3) AS INTEGER) <= 7  AND CAST(CASE WHEN CHAR_LENGTH(client_version) - CHAR_LENGTH(REPLACE(client_version , '.', '')) = 2 THEN '0' ELSE SPLIT_PART(client_version , '.', 4) END AS INTEGER) >= 49;",
    "release_at": "2023-10-05T10:00:00.000000Z",
    "release_at_local_time": false,
    "push_alert_data": {
        "titleEn":"AMA starts in 1 hour",
        "bodyEn": "(Ad) Catch us on YouTube in a while!",
        "titleKo": "1시간 뒤, AMA가 시작돼요",
        "bodyKo": "(광고) 잠시 후, 유튜브에서 만나요!",
        "link": "over-mobile://home/main",
        "iconUrl": ""
    }
}