Utilize the benefits of Excel-like Confluence spreadsheets!
  • Table Filter, Charts & Spreadsheets for Confluence
  • Table Filter, Charts & Spreadsheets for Confluence
  • Need Help
  • FAQ
  • Migration
  • Book Live Demo
  • Start Free Trial
  • Suggest Feature
  • For monday.com
  • DC/Server
    • Cloud
    • DC/Server
  • Provided macros and their main functions
  • How to insert and remove macros
  • Table Filter
  • Table Spreadsheet
  • Spreadsheet from Table
  • Table Spreadsheet Include
  • Chart from Table
  • Pivot Table
  • AI Table
  • Table Excerpt and Table Excerpt Include
  • Table Transformer
    • Default automatic presets
    • General syntax and SQL functions available
    • Custom Transformation - use cases with advanced SQL queries
      • Advanced table cells formatting
      • Aggregating and grouping with SQL
      • Executing calculations with SQL
      • Data searching, filtration, and formatting with SQL
      • Merging columns with SQL
      • Merging/JOINing tables with SQL
      • Processing links with SQL
      • Setting conditions with SQL
      • Using multiple SQL statements
      • Using SQL with Jira Issues
      • Using regular expressions in SQL
      • Working with variables in SQL
    • Stylesheet tab - altering table display with CSS
    • Using AI assistant to construct SQL queries
    • Messages tab - customizing no-output notifications
  • Table from CSV
  • Table from JSON
  • How to combine macros
  • Use cases
  • How to work with built-in and third-party macros
  • How to export macros and results
  • Configuring parameters of Table Filter, Charts & Spreadsheets
  • How to set the date format and worklog settings
  • Migration Details
  • FAQ
  • Release Notes
  • Privacy and Data Collection Policy
  • VPAT (Product Accessibility)
  • Table Filter, Charts & Spreadsheets for Confluence
  • Table Transformer
  • Current: Custom Transformation - use cases with advanced SQL queries
PDF

Custom Transformation - use cases with advanced SQL queries

Advanced table cells formatting
Adding background, text color
Adding border color
Adding bullet, numbered list
Adding lighter status color
Adding line breaks
Adding text color
Adding tooltips
Changing alignment
Changing cells height
Changing column width
Changing font size, style
Preserving initial cell formatting
Conditional formatting
Conditional inserting of statuses
Conditional inserting of values and coloring cells background
Creating clickable links
Escaping special characters for wiki markup
Text formatting
Using beautiful colors from the Atlassian Design System
Aggregating and grouping with SQL
Aggregating by headers
Pivoting tables
Unpivoting tables
Splitting cell values to different rows (flatten an array)
Splitting cell values to different rows preserving the original formatting
Executing calculations with SQL
Using formulas to calculate with SQL
Accounting for the monthly budget
Counting the definite value in a column
Calculating cumulative (running) totals
Calculating standard deviation / variance
Calculating the completion ratio
Calculating the number of distinct (unique) values by categories
Calculating the number of workdays in a period of time
Calculating time difference
Data searching, filtration, and formatting with SQL
Extracting uneditable macros content
Formatting as strings
Getting local time of different time zones
Number formatting
Replacing uneditable macros content
Searching for a specified pattern in a column
Merging columns with SQL
Merging/JOINing tables with SQL
Merging tables using SQL filtration
Merging tables by partial match
Automatic filling blanks and updating values in tables
Processing links with SQL
Changing a link text and preserving it clickable
Getting the link address from the link
Setting conditions with SQL
Using If/Then construct in SQL
Comparing two dates using If/Then construct
Using EXISTS function to check if the specific table rows exist
Checking if the specific tables exist
Using multiple SQL statements
Creating temporary tables for reuse in SELECTS - Normalizing tables
Inserting new rows
Updating existing rows
Visualizing the progression data in rows as bars
Using SQL with Jira Issues
Adding manual comments to Jira Issues
Creating clickable links to the Jira issues
Formatting a header of Jira Issue
Grouping Jira issues
Merging Jira Issue tables by linked issues and keys
Selecting fields/columns of multiple languages
Using regular expressions in SQL
Using basic regular expressions
Sorting by complex version formats
Searching in the string with a regular expression
Searching and replacing with a regular expression
Working with variables in SQL
"today" variable
@currentUser variable
@pageTitle variable


Table Filter, Charts & Spreadsheets for Confluence Logo
Privacy Policy / Stiltsoft Europe App License Agreement / Stiltsoft website / Privacy and Data collection Policy
Copyright © 2025 Stiltsoft Europe • Powered by Scroll Viewport and Atlassian Confluence

Download PDF

Download page Custom Transformation - use cases with advanced SQL queries.

Cookie Notice

This website uses cookies for analytics, personalization and advertising. By continuing to browse, you agree to our use of cookies.
Learn more

OK Don't track me.