SQL DATEDIFF(WEEKDAY,T1.'Created',GETDATE()) is not calculating the age of the ticket

[Bindiya Chacko]

Hi Experts,

Need help to calculate the age of the ticket. Below SQL is not working:

DATEDIFF(WEEKDAY,T1.'Created',GETDATE())

[Katerina Rudkovskaya _Stiltsoft_]

Hi @Bindiya Chacko,

Are we talking about the Table Filter and Charts for Confluence app and its Table Transformer macro?

If this is the case, then here are the screenshots from our test Confluence instance:



SELECT T1.'Key', T1.'Created',
DATEDIFF(WEEKDAY,T1.'Created',GETDATE()) AS 'Aging'
FROM T*



So, everything works fine.

If you get any errors that the functions are not supported, you may update the app. For Server/Data Center the current version is 9.8.1. For Confluence Cloud your add-on is always up-to-date.

If you still need to share some details (source table, macro settings, macro preview, etc.), please refer to our support. The portal is confidential.

If my assumption about the app is wrong, please clarify what add-on and what macro you are trying to use.

[Bindiya Chacko]

Hi @Katerina Rudkovskaya _Stiltsoft_ ,

This is ask is for Table Transformer and the query is not working for me.

Confluence 7.13.2

[Stiltsoft support]

Hi @Bindiya Chacko

Please check what version of the Table Filter and Charts for Confluence app is installed for your instance. The current one is 9.8.2, so please update if required.

If this doesn't help, please refer to our support. Attach the page storage format (upper right corner of the page -> menu ... -> View storage format) and we'll look into the issue.