Title: General syntax and SQL functions available  
Author: Nikita Kamai Jan 12, 2023
Last Changed by: Katerina Kovriga Aug 27, 2025
Tiny Link: (useful for email) https://docs.stiltsoft.com/x/TAesCQ
Export As: Word · PDF  
Incoming Links
Table Filter, Charts & Spreadsheets for Confluence - Knowledge base (5)
    Page: Pivot Table
    Page: Chart from Table
    Page: Table Filter
    Page: Table Transformer
    Page: Table Toolbox
Hierarchy
Parent Page
    Page: Table Transformer
Labels
Global Labels (1)
Recent Changes
Time Editor  
Aug 27, 2025 14:38 Katerina Kovriga View Changes
Published by Scroll Versions from space TFAC and version Draft
Aug 27, 2025 12:06 Katerina Kovriga View Changes
Published by Scroll Versions from space TFAC and version Draft
Aug 26, 2025 17:28 Katerina Kovriga View Changes
Published by Scroll Versions from space TFAC and version Draft
Aug 26, 2025 14:58 Katerina Kovriga View Changes
Published by Scroll Versions from space TFAC and version Draft
Aug 21, 2025 07:16 Katerina Kovriga  
Published by Scroll Versions from space TFAC and version Draft
Outgoing Links
External Links (118)
    https://docs.microsoft.com/en-us/sql/t-sql/queries/at-time-…
    https://www.w3schools.com/sql/sql_ref_as.asp
    https://www.w3schools.com/sql/func_mysql_time.asp
    https://www.w3schools.com/sql/func_mysql_instr.asp
    https://www.w3schools.com/sql/func_mysql_upper.asp
    https://www.w3schools.com/sql/func_mysql_date_add.asp
    https://www.w3schools.com/sql/func_mysql_timestamp.asp
    https://github.com/agershun/alasql/wiki/Case
    https://www.w3schools.com/sql/func_mysql_ifnull.asp
    https://www.w3schools.com/sql/sql_null_values.asp
    https://github.com/agershun/alasql/wiki/Cube
    https://www.w3schools.com/sql/func_sqlserver_getdate.asp
    https://cloud.google.com/bigquery/docs/reference/standard-s…
    https://www.w3schools.com/sql/func_mysql_power.asp
    https://github.com/agershun/alasql/wiki/If
    https://github.com/agershun/alasql/wiki/First
    https://www.w3schools.com/sql/sql_insert.asp
    https://github.com/agershun/alasql/wiki/Left
    https://www.w3schools.com/sql/func_mysql_date_sub.asp
    https://www.w3resource.com/mysql/aggregate-functions-and-gr…
    https://docs.stiltsoft.com/pages/viewpage.action?pageId=422…
    https://www.w3schools.com/sql/func_mysql_subdate.asp
    https://www.w3schools.com/sql/sql_between.asp
    https://docs.oracle.com/cd/B14117_01/server.101/b10759/cond…
    https://www.w3resource.com/mysql/date-and-time-functions/my…
    https://www.w3schools.com/sql/sql_and_or.asp
    https://www.w3schools.com/sql/sql_select.asp
    https://github.com/agershun/alasql/wiki/Union
    https://confluence.atlassian.com/bitbucketserver/markdown-s…
    https://www.w3schools.com/sql/sql_default.asp
    https://github.com/agershun/alasql/wiki/End
    https://docs.microsoft.com/en-us/sql/t-sql/functions/char-t…
    https://www.w3schools.com/sql/sql_in.asp
    https://www.w3schools.com/sql/func_mysql_mid.asp
    https://github.com/agershun/alasql/wiki/Min
    https://www.w3schools.com/sql/func_mysql_second.asp
    https://www.w3schools.com/sql/func_sqlserver_datediff.asp
    https://www.w3schools.com/sql/func_mysql_substr.asp
    https://www.w3schools.com/sql/func_mysql_weekday.asp
    https://github.com/agershun/alasql/wiki/Sum
    https://www.mysqltutorial.org/mysql-interval/
    https://github.com/agershun/alasql/wiki
    https://github.com/agershun/alasql/wiki/Outer
    https://www.w3schools.com/sql/func_sqlserver_coalesce.asp
    https://www.w3schools.com/sql/func_sqlserver_day.asp
    https://www.w3schools.com/sql/sql_ref_order_by.asp
    https://www.techonthenet.com/sql/intersect.php
    https://github.com/agershun/alasql/wiki/Cast
    https://www.w3schools.com/sql/func_sqlserver_current_timest…
    https://github.com/agershun/alasql/wiki/Except
    https://www.w3schools.com/sql/func_sqlserver_dateadd.asp
    https://github.com/agershun/alasql/wiki/Else
    https://github.com/agershun/alasql/wiki/Right
    https://www.w3schools.com/sql/func_mysql_least.asp
    https://github.com/agershun/alasql/wiki/Check
    https://docs.microsoft.com/en-us/sql/t-sql/functions/groupi…
    https://www.w3schools.com/sql/func_mysql_now.asp
    https://www.w3schools.com/jsref/jsref_split.asp
    https://confluence.atlassian.com/doc/confluence-wiki-markup…
    https://www.w3schools.com/sql/sql_join_full.asp
    https://github.com/agershun/alasql/wiki/Having
    https://www.w3schools.com/sql/sql_any_all.asp
    https://github.com/agershun/alasql/wiki/Date
    www-db.deis.unibo.it/courses/TW/DOCS/w3schools/sql/sql_func…
    https://github.com/agershun/alasql/wiki/From
    https://www.w3schools.com/sql/func_sqlserver_log.asp
    https://www.w3schools.com/sql/func_mysql_hour.asp
    https://www.w3schools.com/sql/sql_update.asp
    https://www.w3schools.com/sql/func_mysql_dayofweek.asp
    https://www.w3schools.com/sql/func_mysql_isnull.asp
    https://github.com/agershun/alasql/wiki/Asc
    https://www.w3schools.com/sql/func_msaccess_lcase.asp
    https://github.com/agershun/alasql/wiki/Abs
    https://docs.stiltsoft.com/pages/viewpage.action?pageId=422…
    https://github.com/agershun/alasql/wiki/False
    https://github.com/agershun/alasql/wiki/Limit
    https://github.com/agershun/alasql/wiki/Exists
    https://www.w3schools.com/sql/sql_groupby.asp
    https://github.com/agershun/alasql/wiki/Inner
    https://github.com/agershun/alasql/wiki/Rollup
    https://www.w3schools.com/sql/func_mysql_greatest.asp
    https://github.com/AlaSQL/alasql/wiki/SEARCH
    https://www.w3schools.com/sql/func_mysql_round.asp
    https://github.com/agershun/alasql/wiki/Max
    https://www.w3schools.com/sql/sql_count_avg_sum.asp
    https://www.w3schools.com/sql/func_mysql_replace.asp
    https://developer.mozilla.org/en-US/docs/Web/JavaScript/Ref…
    https://github.com/agershun/alasql/wiki/Like
    https://github.com/agershun/alasql/wiki/Natural
    https://github.com/agershun/alasql/wiki/True
    https://github.com/agershun/alasql/wiki/While
    https://github.com/agershun/alasql/wiki/Desc
    https://github.com/agershun/alasql/wiki/Cross
    https://www.w3schools.com/sql/func_mysql_nullif.asp
    https://github.com/agershun/alasql/wiki/Avg
    https://www.w3schools.com/sql/func_mysql_length.asp
    https://github.com/agershun/alasql/wiki/Offset
    https://developer.mozilla.org/en-US/docs/Web/JavaScript/Ref…
    https://www.w3schools.com/sql/func_mysql_exp.asp
    https://www.w3schools.com/sql/func_msaccess_ucase.asp
    https://www.w3schools.com/sql/func_mysql_month.asp
    www.sql-tutorial.ru/ru/book_predicate_like.html
    https://docs.stiltsoft.com/pages/viewpage.action?pageId=422…
    https://www.w3schools.com/sql/func_sqlserver_concat.asp
    https://www.w3schools.com/sql/func_mysql_floor.asp
    https://github.com/agershun/alasql/wiki/Some
    https://www.w3schools.com/sql/func_mysql_sqrt.asp
    https://www.w3schools.com/sql/func_mysql_trim.asp
    https://www.w3schools.com/sql/sql_where.asp
    https://github.com/agershun/alasql/wiki/Using
    https://www.w3schools.com/sql/func_mysql_year.asp
    https://github.com/agershun/alasql/wiki/Begin
    https://developer.mozilla.org/en-US/docs/Web/JavaScript/Ref…
    https://github.com/agershun/alasql/wiki/Substring
    https://github.com/agershun/alasql/wiki/Corresponding
    https://www.w3schools.com/sql/func_mysql_minute.asp
    https://docs.progress.com/bundle/datadirect-openaccess/page…
    https://www.w3schools.com/sql/sql_distinct.asp
Table Filter, Charts & Spreadsheets for Confluence - Knowledge base (27)     Page: Replacing uneditable macros content
    Page: Merging Jira Issue tables by linked issues and keys
    Page: Getting local time of different time zones
    Page: Counting the definite value in a column
    Page: Using EXISTS function to check if the specific table rows exist
    Page: Adding line breaks
    Page: Merging columns with SQL
    Page: Calculating the completion ratio
    Page: Calculating the number of distinct (unique) values by categories
    Page: General syntax and SQL functions available
    Page: Advanced table cells formatting
    Page: Extracting values from specified HTML tags
    Page: Splitting cell values to different rows (flatten an array)
    Page: Updating existing rows
    Page: Extracting uneditable macros content
    Page: Searching in the string with a regular expression
    Page: Grouping Jira issues
    Page: Number formatting
    Page: Splitting cell values to different rows preserving the original formatting
    Page: Creating temporary tables for reuse in SELECTS - Normalizing tables
    Page: Escaping special characters for wiki markup
    Page: Pivoting tables
    Page: Merging tables using SQL filtration
    Page: Searching and replacing with a regular expression
    Page: Calculating time difference
    Page: Unpivoting tables
    Page: Formatting as strings