• 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
  • Cloud
    • Cloud
    • DC/Server
  • Table Filter, Charts & Spreadsheets for Confluence
  • Table Transformer
  • Current: Custom Transformation - use cases with advanced SQL queries
PDF

Download PDF

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

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
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
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 © 2024 Stiltsoft Europe • Powered by Scroll Viewport and Atlassian Confluence

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.