LogoLogo
  • Release Notes
    • 2024
      • July 2024
      • June 2024
      • May 2024
      • April 2024
      • March 2024
      • February 2024
      • January 2024
    • 2023
      • December 2023
      • November 2023
      • October 2023
      • September 2023
      • August 2023
      • July 2023
      • June 2023
      • May 2023
      • April 2023
      • March 2023
      • February 2023
      • January 2023
    • 2022
      • December 2022
      • November 2022
      • October 2022
      • September 2022
      • August 2022
      • July 2022
      • June 2022
      • May 2022
      • April 2022
      • March 2022
      • February 2022
      • January 2022
  • CDP 365 INTRODUCTION
    • Overview of CDP 365
    • Feature Structure
    • CDP 365's Interface
    • Help feature
  • PERSONAS
    • Visitors & Customers
      • Data table
      • Explore data
      • Upload data
      • Apply data view
      • View profile
    • Segments
    • Plannings
    • Predictive Models
      • RFM Model
      • Lifecycle Stages
  • DATA HUB
    • Event Sources
      • Source
        • Website
        • System delivery
      • Conversion Event
    • Business Objects
      • Data Objects
        • Data table
        • Attributes
          • Custom Attribute
          • Computed Attribute
            • Event Counter
            • Aggregation
            • Most Frequent
            • First
            • Last
            • Unique List
            • Unique Count
            • Conversion Attribution
            • Virtual Custom Function
            • Schedule Custom Function
        • Collections
        • Groups
        • Setting
      • Data Views
      • Import Histories
      • Export Histories
    • Analytic Models
    • Data Schema
  • Marketing Hub
    • Customer Journeys
      • Work with Journey
        • Destination nodes
          • Web Embedded
            • Design from JSON
              • Control Toolbar
              • Setting
                • Template Setting
                • Blocks & Settings
                  • Countdown
                  • Dynamic Content
                  • Image
                  • Video
                  • Boolean
                  • Number
                  • Text
                  • Array
                  • Object
          • Line App
          • Zalo
      • Blast Campaign
      • Third-party campaigns
      • Metrics
      • Label
      • Custom Function
      • Status of Journey
    • Channel Integration - Destinations
      • All Destinations
        • Email
        • Web Personalization
        • Web Push-Notification
        • App Push Notification
        • Smart Inbox
        • Conversation
        • Webhook
        • SMS
        • Viber
        • Whatsapp
        • Line
        • Zalo
        • File Transfer
    • Promotion Center
    • Media Template
      • Control Toolbar
      • Settings
        • Template Settings
          • Basic
          • Advanced
        • Blocks & Settings
          • Columns
          • Text
          • Image
          • Button
          • Optin Fields
            • Email
            • Phone
            • Dropdown select
            • Datetime
            • Radio button/ Checkbox
            • Privacy Notice
          • Yes/No
          • Count down
          • Video
          • Coupon Wheel
          • Spacer
          • Divider
          • Icon
          • HTML
          • Slide show
          • Group
          • Rating
          • Table
          • Shake and Win
          • Lucky gift box
          • OTP Verification
      • Layers
      • Live Preview
    • Email Template
      • Control Toolbar
      • Settings
        • Email Template Settings
          • Basic
          • Advanced
        • Blocks & Settings
          • Columns
          • Text
          • Image
          • Button
          • Count down
          • Spacer
          • Divider
          • Icon
          • HTML
          • Menu
          • Table
          • Unsubscribe
          • Group
      • Layers
      • Live Preview
    • Link Management
  • Insights
    • Quick start guide
    • Data Source
      • Create a data source
    • Reports
      • Create reports
        • About reports
        • Build, stylize, and add data to reports
          • Set report date ranges
          • Add and configure components
          • Chart references
            • Area chart reference
            • Bar chart reference
            • Bullet chart reference
            • Geo chart reference
            • Line chart reference
            • Pie chart reference
            • Pivot table reference
            • Scatter and bubble chart reference
            • Scorecard reference
            • Table reference
            • Time series reference
            • Tree map reference
          • Add reference lines to charts
          • Add and edit data
          • Add pages and report navigation
          • Report layout options
          • Work with color
          • Add text, images, lines, and shapes
          • Arrange and distribute components
          • Use the Insights Report Editor
        • Copy a report
        • Delete a report
        • Tutorial: Create a new report
      • Filter your data
        • About filters
        • Create, edit, and manage filters
        • Configure filter conditions
        • Filter examples
      • Make reports interactive
        • Let your viewers control the date range
        • About controls
        • Use controls across data sources
        • Add chart interaction filters
        • Let viewers drill down into your data
        • Link to a page
        • Export data from a chart
        • Embed external content in reports
        • Let viewers select the fields in charts
      • Blend multiple data sources in a chart
        • About data blending
        • Blend data in charts
        • Filter blended data
        • Change the date range for blended data
        • Use blending to reaggregate data
      • Glossary
        • Aggregation
        • Blended data
        • Chart
        • Component
        • Component, report-level
        • Connector
        • Data set
        • Data source
        • Dimension
        • Edit mode
        • Field
        • Join key
        • Metric
        • Owner
        • Page
        • Properties panel
        • Report
        • View mode
        • Viewer (user type)
  • DATAFLOWS
    • Dataflows
      • Creating a Dataflows
        • Action node
          • Add data
          • Delay
          • Filter
          • Script
          • SQL
          • Branch
          • Add column
          • Aggregate
          • Select column
          • Join
          • Bin
          • Merge Columns
          • Split Columns
          • Group
          • Union Rows
          • Save data
        • Destination channel
          • Send mail
          • Export to Google Sheet
          • Google Audience
          • Facebook Audience
          • Big Query
          • Postgre
          • Export to CDP 356 Events
          • Export to CDP 365 Business Object
          • Export to CDP 365 Segment
      • Work with Dataflow
      • Status of Dataflow
    • Data Destinations
      • Create a Data Destination
      • View/Edit a Data Destination
      • Data Destinations Connectors
        • Amazon S3
        • CDP Coupon
        • Google Audiences
        • CDP Business Object
        • CDP Segment
        • CDP Event
        • Audience SaleForce Maketing Cloud
        • Google BigQuery
        • Facebook Audiences
        • Google Ads Audiences
        • Postgres
        • Send Mail
        • Google Sheet
    • Data Source
      • Create a Data Source
      • View/Edit a Data Source
      • Data Source Connectors
        • Google Sheets
        • Oracle
        • KiotViet
        • Elastic Search
        • Haravan
        • Tiki
        • Sapo
        • Lazada
        • Shopee
        • Fanpage Messages
        • Google Analytics
        • CDP ANTSOMI
        • Trello
        • Google Ads
        • Facebook Ads
        • Youtube
        • PostgreSQL
        • MySQL
        • File Upload (Big Table)
        • Business Object
        • JSON API
        • SQL Workspace
        • CDP 365 Segment's Members
        • Analytic Model Antsomi
        • SQL Server
  • PORTAL SETTINGS
    • Overview
    • Data Protect
    • General Setting
      • Roles
    • Accounts
    • IP Restriction
    • Menus
    • Account Sharing
  • Annotation
    • Conditions
    • Time range
    • Data Format
    • Function List
  • TICKET MANAGEMENT
    • Tickets
  • Use cases
    • Personas
      • Visitors/Customers
        • How to add new and update Customers to CDP
        • How to create a Customer Custom Attribute
        • How to create a Customer Computed-Last Attribute
      • Segments
        • How to export .xml file?
        • How to create a Dynamic Segment
        • How to create a Static Segment (Matching file)
        • How to create a new segment?
        • Create a segment for Cart Abandonment
        • Set up a "Segment" containing emails to be excluded before sending mail
      • How to create "Attribute" for "Customer"/"Visitors"?
    • Data Hub
      • Event Sources
        • Set up Event Tracking code to track events into CDP
        • Set up Event Tracking code to track events into CDP
        • How to check data after you track an event on the website and app?
      • Business Objects
        • How to create "Data Source" connected with the "Data Object" of CDP 365
        • How to create a Collection
        • How to create "Custom Attributes" with Input via UI feature
    • Marketing Hub
      • How do I set up an advertising SMS campaign using the SMS FPT destination?
      • Strengthening User Identity Verification with OTP Authentication
      • How to use Line Message Templates?
      • How to set up a Webhook Journey
      • How to set up a campaign using SMS channel
      • How to setup a campaign using App Notification channel?
      • How to configure a smart inbox campaign? (In Progress...)
      • How to calculate conversion goals for a journey?
      • How to recommend products using the Parent-Child Algorithm
      • How to create Branded domain in Link Management?
      • How to send messages using OneWay SMS destination?
      • How to explore Journeys?
      • How to test a Journey using Email channel?
      • How to send marketing email using Mailgun Destination?
      • How to send marketing SMS using One Way SMS Destination?
      • How to create Web Personalization using Media JSON in CDP 365?
      • How to create an Email Customer Journey?
      • How to create a Web personalization journey?
      • How to create a "Trello Card" using CDP 365
      • How to display template on website using CDP 365
      • Initialize customer after submitting form
      • How to create Customer Journey?
      • How to set up some Inline templates
      • How to monitor campaign performance?
      • How to create "Promotion"/"Coupon" by uploading files?
      • How to create Coupon from Magento or ERP system to CDP 365?
      • How to send "SMS Yondu" using CDP 365
      • How to send mail from email upload?
      • How to send "Zalo Notification Service" using CDP 365
      • How to send message using "FB Messenger" in CDP
      • How to Send SMS using "Klasik SMS" in CDP 365
      • How to push notification "Firebase Cloud Messaging" using CDP 365
      • How to Send email using "Amazon SES" in CDP 365
      • How to define zone in website for improve web personalize performance
      • How to Send "Viber Yondu" using CDP 365
      • How to send "Infobip Viber" using CDP 365
      • How to send "eSMS Viber" using CDP 365
      • How to create a new "Display Zone"
      • How to Send SMS using "Telerivet SMS" in CDP 365
      • How to push notification using "Onesignal (App Push)" in CDP 365
      • How to push notification using Antsomi Web Push in CDP 365?
      • How to Send email using "SendGrid" in CDP 365
      • How to send email using "Mailjet" in CDP 365?
      • How to send WhatsApp message in CDP 365?
      • How to send Telegram message in CDP 365?
      • How to track click metric of OneSignal App Push
      • How to send Ticket from CDP 365 to Antbuddy?
    • Insights
      • How to create "Report" with “Journey performance” data source?
      • How to create a new "Data sources"?
    • Dataflows
      • How can I export data from CDP 365 to Google Sheets?
      • Collect data from TikTok Form to CDP 365
      • How to create a Segment Data Source
      • How to create a report from multiple data sources?
      • How to send messages using "Facebook Messenger" in CDP 365
      • How to create a new Google Analytics data source?
      • How to create Facebook Ads data source?
      • How to create Google Ads data source?
      • How to create a "Destination Channel" in "Dataflows"?
      • Set up Dataflows to push data to a Business Object in CDP 365
      • Set up Dataflows to push data to Google and Facebook Audiences
      • How to upload segment data into Google Ad Manager (GAM) 360 using Dataflow?
    • Portal Settings
      • How to set up two-step authentication?
Powered by GitBook
On this page
  • 1. Operator
  • 1.1. Plus (+)
  • 1.2. Minus (-)
  • 1.3. Multiply (*)
  • 1.4. Devide (/)
  • 1.5. Less than (<)
  • 1.6. Greater than (>)
  • 1.7. Less than or equal to (<=)
  • 1.8. Greater than or equal to (>=)
  • 1.9. Equal to (=)
  • 1.10. Less than or greater than but not equal to (<>)
  • 1.11. Not equal to (!=)
  • 1.12. Remainder (%)
  • 2. String
  • 2.1. Char
  • 2.2. Length
  • 2.3. Trim
  • 3. Math
  • 3.1. Abs
  • 3.2. Rand
  • 3.3. Round
  • 3.4. Sqrt
  • 4. Calendar/ Date
  • 4.1. Current_Time
  • 4.2. DayOfWeek
  • 4.3. Hour
  • 4.4. Minute
  • 4.5. Month
  • 4.6. Second
  • 4.7. Year
  • 4.8. Now
  • 4.9. Week_Of_Year
  • 5. Expressions
  • 5.1. Case

Was this helpful?

  1. Annotation

Function List

1. Operator

1.1. Plus (+)

Plus sign for addition

1.2. Minus (-)

Minus sign for subtraction

1.3. Multiply (*)

Multiply sign for multiplication

1.4. Devide (/)

Devide by sign for division

1.5. Less than (<)

Returns true if expr 1 is less than expr 2

1.6. Greater than (>)

Returns true if expr 1 is greater than expr 2

1.7. Less than or equal to (<=)

Returns true if expr1 is less than or equal to expr2

1.8. Greater than or equal to (>=)

Returns true if expr1 is greater than or equal to expr2

1.9. Equal to (=)

Returns true if expr1 equals expr2, or false otherwise

1.10. Less than or greater than but not equal to (<>)

Returns true if expr1 is not equal to expr2, or false otherwise

1.11. Not equal to (!=)

Returns true if the operands don't have the same value; otherwise, it returns false

1.12. Remainder (%)

Returns the remainder after expr1/expr2

2. String

2.1. Char

Converts a numeric value between 0 and 255 to the character value corresponding to the ASCII code.

CHAR(expr)

  • expr is any expression that evaluates to a numerical value between 0 and 255.

2.2. Length

Returns the length, in number of characters, of a specified string. The length is returned excluding any trailing blank characters.

LENGTH(expr)

  • expr is any expression that evaluates to a character string

2.3. Trim

Removes the leading and trailing space characters from string

TRIM(expr)

  • expr is any expression that evaluates to a character string.

3. Math

3.1. Abs

Calculates the absolute value of a numeric expression.

ABS(expr)

  • expr is any expression that evaluates to a numerical value.

3.2. Rand

Returns a pseudo-random number between 0 and 1

3.3. Round

Rounds a numeric expression to n digits of precision.

ROUND(expr, integer)

  • expr is any expression that evaluates to a numerical value.

  • integer is any positive integer that represents the number of digits of precision.

3.4. Sqrt

Calculates the square root of the numeric expression argument. The numeric expression must evaluate to a nonnegative number.

4. Calendar/ Date

4.1. Current_Time

Returns the current time to the specified number of digits of precision, for example: HH:MM:SS.SSS

CURRENT_TIME

If no argument is specified, the function returns the default precision.

4.2. DayOfWeek

Returns a number between 1 and 7 corresponding to the day of the week for a specified date expression.

For example, 1 always corresponds to Sunday, 2 corresponds to Monday, and so on through to Saturday which returns 7.

4.3. Hour

Returns a number (between 0 and 23) corresponding to the hour for a specified time expression. For example, 0 corresponds to 12 a.m. and 23 corresponds to 11 p.m.

4.4. Minute

Returns a number (between 0 and 59) corresponding to the minute for a specified time expression.

4.5. Month

Returns the number (between 1 and 12) corresponding to the month for a specified date expression.

4.6. Second

Returns the number (between 0 and 59) corresponding to the seconds for a specified time expression.

4.7. Year

Returns the year for the specified date expression.

4.8. Now

Returns the current timestamp. The NOW function is equivalent to the CURRENT_TIMESTAMP function.

4.9. Week_Of_Year

Returns a number (between 1 and 53) corresponding to the week of the year for the specified date expression.

5. Expressions

5.1. Case

This form of the Case statement evaluates each WHEN condition and if satisfied, assigns the value in corresponding THEN expression.

If none of the WHEN conditions are satisfied, it assigns the default value specified in the ELSE expression.

If no ELSE expression in specified, the system will automatically add an ELSE NULL. CASE WHEN request_condition1 THEN expr1 ELSE expr2 END exprs is any valid expression

PreviousData FormatNextTickets

Last updated 1 year ago

Was this helpful?