I'm trying to show via Table Transform macros only rows related with current month:
SELECT * FROM T*
WHERE MONTH('End date') = MONTH(CURRENT_TIMESTAMP)
And get the error like: table have no rows
When I do it like
SELECT * FROM T*
WHERE MONTH('End date') = 6
All works fine.
Could you please assist me to resolve this
It certainly may be so: there were at least 3 releases regarding the Table Transformer macro and its functions since your version.
You may also check what the MONTH(CURRENT_TIMESTAMP) function returns (show it as a separate column). For me it works fine and returns 6 for every cell. So the comparison also works properly.
And you may check the date format that you use inside the Table Transformer settings (I guess that it corresponds the date format in your table, because the second query is working well).
So update the app, and if the issue is still present, raise a support request. Attach the page storage format (upper right corner -> menu ... -> View Storage Format). If you don't see the option, ask your Confluence administrator to help you.
Our support team will restore exactly your source table and your macro and look into the issue. If your source table is the Jira Issues macro, add its screenshot in a published state without any macros.
Could you please show which date format you have used in your first answer?
Now function is working (checked on putting month number to separate table). But I still can't reach the result.
I have used all data variants described here https://docs.stiltsoft.com/display/public/TFAC/How+to+set+the+date+format+and+worklog+settings
it works with string dates but not working with Date macro
Hi everyone, We’re always looking at how to improve Confluence and customer feedback plays an important role in making sure we're investing in the areas that will bring the most value to the most c...
Connect with like-minded Atlassian users at free events near you!Find an event
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.Host an event
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events