Easy Dropdowns problem with Table Filter and Table Transformer

[Tommy Strømme]

Dear community,

So I'm running my Page Properties Report with Table Transformer and Table Filter. It works great, but for some reason I'm not allowed to interact with the dropdowns in the the view shown below (showing some of the colums). I'm pretty sure that this worked before. Using Data Center version. When I hover over the dropdowns i see a message at the bottom left in the browser saying javascript:void(0). 

When I open the projects themselves from this view, then I'm able to use the dropdowns in the Page Report without going into Edit mode, so the dropdowns themselves are configured in the right way allowing to interact with them in other views. see example below. 

I'm also posting the Table Transformer Code at bottom here.  Some of the columns that are not mentioned in the transformer code, like Unit and Type has the same error as the colums that are mentioned (like Status). I cant interact with any of the dropdowns.   

Any help on this is greatly appreciated!

SELECT *,
FORMATWIKI("{cell:width=90px|bgColor=" +
CASE
WHEN T1.'Updated' IS NULL THEN "Grey"
WHEN DATEDIFF(day, "today", T1.'Updated') <= -7 THEN "Red"
ELSE "White"
END
+ "}" + FORMATDATE(T1.'Updated') + "{cell}") AS 'Updated',
FORMATWIKI("{cell:width=350px}" , T1.'Title' , "{cell}") AS 'Title',
FORMATWIKI("{cell:width=150px}" , T1.'CSE' , "{cell}") AS 'CSE',
FORMATWIKI("{cell:width=150px}" , T1.'Status' , "{cell}") AS 'Status',
FORMATWIKI("{cell:width=150px}" + T1.'Customer' + "{cell}") AS 'Customer'
FROM T1
ORDER BY Priority ASC, Owner ASC;

[Stiltsoft support]

Hi @Tommy Strømme ,

The Table Filter and Table Transformer macros are provided by the Table Filter, Charts & Spreadsheets for Confluence app that is developed by our company. The Easy Dropdown macros are not ours.

So, you may try to use the Handy Macros for Confluence app and its Handy Statuses - this app is also ours, the compatibility is always supported and the functionality should be pretty the same.

As for now, you may try to unwrap the Page Properties Report from our macros and check if the statuses change in the page view mode (you mentioned that they can be changed for the Page Property macro but not for the Page Properties Report).

If everything works as expected, check the version of the Table Filter app: the current one is 12.1.0. If yours is an older one, please update - we need to be on the same page for further investigation.

If the issue persists, refer to our support: send us your Confluence, plugin and browser versions, the page storage format, the browser console log. We'll see if anything can be done from our side here.

[Stiltsoft support]

Hi @Tommy Strømme ,

Meanwhile we've also checked the compatibility of these two apps: at first for Confluence 8+ we installed the up-to-date versions of the Table Filter (12.1.0 released 2024-09-26) and Easy Dropdown (6.6.1 released 2024-07-24). The statuses in pure PPR changed on the fly, the statuses after the Table Transformer macro with a simple SELECT * FROM T* were shown as pictures.

Then we took older versions: 9.5.2 for Table Filter (released 2022-11-29) and 6.5.4 (released 2023-02-08) for Easy Dropdown - both are the first versions compatible with Confluence 8+. Again the statuses in pure PPR changed on the fly and the statuses after the Table Transformer macro with a simple SELECT * FROM T* were shown as pictures.

So, we are not even sure that during some time period this case was a working one.

Again, you may take the Handy Macros for Confluence app that I've mentioned above - it is ours and the compatibility is always maintained.

Also we haven't made any changes to the internal logic of the Table Transformer macro, it works as usual. If you are sure that these two macros have really worked together, you may apply to the Easy Dropdown support. 

[Tommy Strømme]

Hi, 

Thank you for your swift reply and also your research on the matter. Highly appreciated!

Our Confluence Admin has ensured me today that we have the latest versions of all the plugins. 

I'll try to do some more troubleshooting and if we don't come up with a solution I'll try to see if its possible for us to get the Handy Macros instead. 

Kind Regards

Tommy

[Stiltsoft support]

Try to get to the Easy Dropdown support - if you are sure that at some point everything was working fine, maybe there were some changes from their side.

[Tommy Strømme]

Yepp, I've reached out to them and asked them to respond directly in this thread. So we'll see what they say. I've become a bit more unsure whether it worked before or not to be honest. I'm not an active user, more of an administrator of the system, so it might be that I remember wrong. Let's see what they say :)

Have a good weekend!

Tommy

[Flavian Diethelm]

Hi Everyone,

I'm Flavian from the EDM development team, thanks for reaching out to us on this matter.

As of now, I'm unaware of any issues regarding the compatibility of EDM and TF/TT on data center. What I know is that we regularly have users contacting us about issues regarding the compatibility between EDM and TF, when they migrate to cloud. This suggests that they use both macros in conjunction on DC without issue. I am however unfamiliar with TT and it's functionality.

I'm gonna try it out and perform some tests. When I'm done, I'll let you know what my findings are.

Kind Regards
Flavian

[Tommy Strømme]

Thank you for looking into this Flavian :-)

[Flavian Diethelm]

Hi Everyone,

I finally got around to do some tests and talk to our lead developer. Here are my findings:

- As Stiltsoft already told us, only the compatibility with EDM and the Table Transformer are an issue. The Table Filter works as intended.

- Looking at our commit history I haven't found anything that suggests, that there were recent changes that could have affected this behavior.

- Scouring our own Service Desk and Backlogs have shown that there already were customers reporting the incompatibility since Confluence 7. So the two macros were probably never compatible in the first place.

- One interesting this was, that my predecessors had opened a ticket with Stiltsoft support to investigate the issue, but sadly the ticket went stale after a while. @Stiltsoft support this would be the ticket.

That's everything for my findings. Now for what would be possible to do:

- If we made the two macros compatible, the fix would be released with the newest version of EDM (v7.0.1 or higher).

- We've already established that v7.0.0 is no longer backward compatible with Confluence 8, so you'd have to either update your server or request a backport in addition.

What we don't know at the moment is what causes the incompatibility. It could be on our side or on Stiltsofts side. Only further investigation from both parties will show us, what has to be done.

I hope i could provide some insights on the matter. Let me know what you want to do.

Kind regards
Flavian

[Tommy Strømme]

Hi,

Thank you for your thorough investigation on the matter.  On our side I can confirm what you are saying in that EDM works with Table Filter but that its an issue only when you add the transformer into the mix. 

The transformer is a real benefit for us in a lot of scenarios so we are unlikely to remove it and only use table filter. Going forward we would just have to open the projects and then adjust the dropdowns from there.  

If the two macros become compatible sometime in the future, please reach out. 

Kind Regards

Tommy

[Stiltsoft support]

Hi Everyone,

The difference between the Table Filter and Table Transformer macros lays in the output: the latter creates the virtual table copy as a result. This logic was implemented from the beginning and has been never changed from our side.

So, we agree that our Table Transformer and EDM's macros were never compatible in the first place.