Log in
Loading…
StiltSoft Docs
  • Spaces
  • People
  • Learning
  • Hit enter to search
  • Help
    • Online Help
    • Keyboard Shortcuts
    • Feed Builder
    • What’s new
    • About Confluence
  • Log in

Table Filter, Charts & Spreadsheets for Confluence - Knowledge base
  • Pages
  • Blog

Page tree

Browse pages
    • Remove Read Confirmation
    • Attachments (260)
    • Page History
    • Page Information
    • Resolved comments
    • View in Hierarchy
    • View Source
    • Export to PDF
    • Export to Word
    • Export to PDF
  1. Pages
  2. Welcome to Table Filter, Charts & Spreadsheets for Confluence!
  3. Table Transformer
  • Jira links
  • Workflow
  • Source page
  • Read Confirmation

Custom Transformation - use cases with advanced SQL queries

  • Aggregating and grouping with SQL
    • Aggregating by headers
    • Pivoting tables
    • Splitting cell values to different rows (flatten an array)
    • Splitting cell values to different rows preserving the original formatting
    • Unpivoting tables
  • Data searching, filtration, and formatting with SQL
    • Extracting column headers/names from a table
    • Extracting uneditable macros content
    • Extracting values from specified HTML tags
    • Filling in empty cells based on the upper-cell present values
    • Formatting as strings
    • Getting local time of different time zones
    • Number formatting
    • Replacing uneditable macros content
    • Searching for a specified pattern in a column
    • Searching for a specified pattern through the entire table
  • Executing calculations with SQL
    • Accounting for the monthly budget
    • 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
    • Counting the definite value in a column
    • Using formulas to calculate with SQL
  • Merging/JOINing tables with SQL
    • Automatic filling blanks and updating values in tables
    • Merging tables by partial match
    • Merging tables using SQL filtration
  • Merging columns with SQL
  • Processing links with SQL
    • Changing a link text and preserving it clickable
    • Getting the link address from the link
  • Setting conditions with SQL
    • Checking if the specific tables exist
    • Comparing two dates using If/Then construct
    • Using EXISTS function to check if the specific table rows exist
    • Using If/Then construct in SQL
  • 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 regular expressions in SQL
    • Searching and replacing with a regular expression
    • Searching in the string with a regular expression
    • Sorting by complex version formats
    • Using basic regular expressions
  • 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
  • Working with variables in SQL
    • "today" variable
    • @currentUser variable
    • @pageTitle variable
    • Custom (user) variables


  • article
Overview
Content Tools
Apps
  • Powered by Atlassian Confluence 9.2.7
  • Printed by Atlassian Confluence 9.2.7
  • Report a bug
  • Atlassian News
  • StiltSoft Europe Privacy Policy
Atlassian
{"serverDuration": 461, "requestCorrelationId": "e90611df66867eb5"}