Katerina Kovriga {Stiltsoft} Expert

Hi @FilBerry , Here is how everything works for us: * If we use a single issue view of the Jira Issues macro/paste the issue link directly on the page in Confluence, then we have a note before the page title section that we have a Jira link here. If we refresh this Jira Issue, the page title appears in the "mentioned in"…

Maybe you have something similar: Let's consider that the first table with links was generated by the Jira Issues macro. The second one was created manually. SELECT T1.'Key', T1.'Status', T1.'Mentioned In', T2.'Comment' FROM T1 JOIN T2 ON T1.'Key' = T2.'Key' Here you join these tables but not with the help of the default…

Hi @FilBerry , Please give us more info about the backward links - not sure that we got the case. How do you get the links from Jira backwards to Confluence pages? Are they stored as a custom field?

Hi @Leona , As @Srinatha Tondihal has kindly mentioned, the similar case can be achieved with one Jira Issues macro and one Table Transformer macro. SELECT *, 'Open'/'All'*100 AS '% of Completion' FROM (SELECT SUM(IF(T1.'Status' = "To Do", 1, 0)) AS 'Open', SUM(IF('Status' IN ("To Do", "In Progress", "Done", "Answered"),…

Hi @Leona, The first two queries work well if you change the names of your statuses: for example, TO DO -> To Do, IN PROGRESS -> In Progress. Please see the screenshots below and check the queries - I specifically made the status names visible near the preview window: And the third query catches all the suitable names…

Hi @Susan Granz , Such messages may appear if your source tables are complex and exceed the size/loading timeout. Please raise a support ticket and we try to see if anything can be done to improve the performance. Attach your page storage format (upper right corner -> menu ... -> View storage format, if you don't see this…

Hi @Russell , In Cloud you won't be able to build a sequence "table <- Table Filter <- Table Excerpt" macro as for now. So I assume that you have Server or Data Center. Please create a support request here and attach your page storage format for the two pages with the Table Excerpt and Table Excerpt Include (upper right…

Use an additional Table Transformer - wrap it outside the first one. In this case all the transformations and calculations done in the internal Table Transformer macro won't be visible for the external Table Transformer macro. The external macro will work with your table as a plain one and the FORMATWIKI option won't be…

Hi @Emil , I can suggest using the following query structure for your case: SELECT 'Issue', 'Created', 'Updated', FORMATWIKI('Checks Created' + " \n" + 'Checks Updated') AS 'Checks' FROM (SELECT *, CASE WHEN 'Checks Created' IS NULL THEN "-" ELSE 'Checks Created' END AS 'Checks Created', CASE WHEN 'Checks Updated' IS NULL…

I can suggest such settings for your case: Seems that the result table looks exactly as you need.

Seems that your Pivot looks not like mine, please attach a screenshot of the Pivot Table macro settings. It seems that you use the Name column twice and get a kinda strange aggregation: first in one column, than in two columns divided by teams. And again in the initial example you should hide the Literal of Name column.…

Hi @Esteban Borja Lopez , Maybe you should separate the Jira Issues macros and the Table Transformer macros? Leave one source table per macro? The issues may come from the dynamic origin of the source macros (maybe some of the Jira Issues macros are slower to download the information, the Table Transformer macro "sees" the…

Seems that everything is correct. The Search Results macro is not available for new Confluence versions, but as far as I know there was a field to set the maximum number of results - maybe you have too many pages to be listed? Try the search field in the upper right corner of the page instead. Here is Atlassian…

Hi @Emily Berg , We can suggest using the Table Transformer macro for your case: SELECT "Total" as 'QTY', SUM(IF(T1.'A' = "X", T1.'QTY', 0)) AS 'A', SUM(IF(T1.'B' = "X", T1.'QTY', 0)) AS 'B', SUM(IF(T1.'C' = "X", T1.'QTY', 0)) AS 'C' FROM T1 UNION CORRESPONDING SELECT * FROM T1 Hope this helps.

Hi @Marcin Krówka , We can suggest this workaround for your case.

Seems to be a duplicate, tried to answer here https://community.atlassian.com/t5/Confluence-questions/To-calculate-the-total-number-of-defects-extracted-using-macro/qaq-p/2029614#U2030149

Hi @sindhushandilyaa , We assumed that the number after your PAC- is a number of days to subtract from the PAC-0. So our developers came up with the following solution: Don't forget to set the correspondent date format: And use the following SQL query: SELECT T1.*, FORMATDATE(ADDDATE(TT1.'Base', INTERVAL…

And what concerns the Table Transformer macro, it is based on the AlaSQL library. So some functions may be limited and require a workaround.

If you save this filter, it will be set for all the page visitors (it works like any other simple dropdown or date range filter). The "3m" and other dynamic filters were introduced specifically for the cases that are similar to yours (when there are manually created and automatically generated by the Page Properties…

Hi @Simon Berdal , To get rid of any confusion, I confirm that the Table Filter and Charts for Confluence app is a paid add-on developed by our company Stiltsoft (according to the guidelines I have the company name attached to my own name). I also use "our app", "the app we provide", etc. while answering. And I also give…

Hi @FA , The Table Filter and Charts for Confluence app is our add-on. As for now export to pdf is not working with the Table Excerpt Include macro for Cloud. We have this improvement in our backlog, and I've added your vote&link to this thread to the ticket. We'll get back here once the feature is implemented.

Hi @Eishle , I can suggest using the Table Filter macro for the case: Make sure that your date format corresponds the format that you are using in your source table: You can use various expressions (-6m, 1w, today, etc.) and hide the filtration panel if necessary. If your original case is a more complex one and you still…

Hi @Esteban Borja Lopez , I've tried to reproduce the issue for the project from our own Jira instance: Here I have ten issues and all of them are with the empty Due Date field (we leave this field blank for this project). SELECT "Empty Total" AS '', SUM(IF(T1.'Due' IS NULL, 1, 0)) AS 'Empty Due Dates', SUM(IF(T1.'Due' IS…

Hi @Kelley Bennett , Our Table Filter and Charts for Confluence app also allows you to work with external files. You may check its Table from CSV macro that allows you to recreate tables in Confluence from CSV/TSV attachments, urls and Google Spreadsheets. And you may also use our Table Spreadsheet macro that supports the…

Hi @Rohith reddy , As @Patrick Vanhoof has already mentioned, you may use the standard Page Properties/Page Properties Report macros to apply the case. And if you need to collect multiple-row tables into one big master table, you may search for some apps on the Atlassian Marketplace. For example, our Table Filter and…

Hi @Stacy Allotta , As @Fabian Lim has kindly mentioned, our Table Filter and Charts for Confluence app and its Table Transformer macro will do the trick. List all the statuses you have in the SQL query and choose what names you want to show: SELECT *, CASE WHEN T1.'P' LIKE "Trivial" THEN "Trivial" WHEN T1.'P' LIKE "Major"…

Hi @POOJA SINGH , The Table from CSV macro kindly mentioned by @Fabio Racobaldo _Catworkx_ belongs to our Table Filter and Charts for Confluence app and allows you to output data from CSV attachments, urls, Google Spreadsheets. And we also provide the Table Spreadsheet macro that allows you to work with familiar Excel…

The filters apply automatically to your headers (I mean real headers made by Confluence and not the simple colored rows). As I see from your screenshot, you have merged headers - it seems to me that your table was created in the old Cloud editor. For the new editor you won't be able to get merged headers as far as I know.…

Hi @Greg Castaldi , You are using our Table Filter and Charts for Confluence app. You may check the possibilities of the Table Filter macro and other macros provided by the add-on in our documentation or book a live demo session with our team.

Hi @MOh G , I'm sorry, I'm out of the office for the next week. Please contact our support team.