Empty Task Report & Table Transformer

[codadevbu]

Hi,

I'm having problems getting multiple task reports working in one table transformer. Since each task report ist limited to 40 entries and only can display one assignee, I tried to limit entries by creating one task report for all incomplete tasks for each subpage. With this workaround I can list all tasks for the team and do the needed filtering with the table transformer, which is wrapped around all task reports. 

Now with this rather clunky workaround I face another problem, which I haven't found a solution yet. If one of those multiple task reports is empty the whole table transformer runs into an error. It seems like an empty task report is returning nothing, instead of an empty table. Trying to fix this issue with the sql command, e.g. for Table 1 "if not exists(select * from T1)" returns a typeerror. So the sql-usage seems to be limited. 

Is there a way to solve this issue? An empty task report has to return something at least, as it shows "No incomplete tasks" when used without the table tansformer.

Thanks for your help!

[Katerina Rudkovskaya _Stiltsoft_ · Accepted solution]

Hi @codadevbu,

Not sure what your current SQL query looks like but here are some hints for you: as your Task Reports have the same headers, you may merge them using the standard “Merge” preset via the Table Transformer macro. The SQL query that stands behind this preset is “SELECT * FROM T*”, so we don’t call any specific tables (T1, T2, T3, etc.) and it is not important how many tables we have.

Then you go to the Table Transformer macro settings -> Options tab -> Source data: Hide all content. Here we get rid from the information blocks that appear if there are no any suitable tasks for the specific Task Report.

So, as a result, you’ll get one combined table.

To filter and/or transform it further, you may use another Table Transformer or Table Filter macro on top of the first Table Transformer macro.

Hope this workaround helps your case.

By the way, you may also browse the Atlassian Marketplace and find some apps that will enhance your experience with tasks and reports.

For example, our company also develops the Handy Macros for Confluence app – you may check its Handy Tasks feature.

[codadevbu]

Thanks @Katerina Rudkovskaya _Stiltsoft_

that solved the problem. I thought I have to union all tables, but this way it's way easier.