Change the color of Table content

Question

We are using Jira macro for representing Jira filter results to the confluence in table format.

Now we want the table Resolution should show conditionally like..is the resolution is Done then it should in Green and if it's another like unresolved then it should show in Yellow like so on.

I tried to search around his and found that i need to work on the user macro but i need help to how to get the table details and so on.

If anybody has gone through this before so throw some lights on it..so it will help me to get this done.

Dominic Lagger · Answer

No. You have to write a user macro. In that user macro you can insert HTML oder Javascript. * Confluence User Macro Guide * Writing User Macros This is an untested and unverified sample code ## Macro title: My Macro ## Macro has a body: Y or N ## Body processing: Selected body processing option ## Output: Selected output option ## ## Developed by: My Name ## Date created: dd/mm/yyyy ## Installed by: My Name ## This is an example macro // HERE IS THE CODE FOR CHECKING, WHETHER THE JIRA TABLE HAS LOADED // IF LOADED, CALL THE MYFUNCTION Regards, Dominic

Yogesh Mude_qi979c · Answer

HI @Dominic Lagger ,

Thanks for the response and the basic code.

Could you please let me know where do i need to write this code ...do i need to use the html macro?

Dominic Lagger · Answer

The scraping is quite easy. This is just some sample code.

Find all status in the jira table (the status macro in the jira table has this class name):

document.getElementsByClassName("aui-lozenge aui-lozenge-subtle")

Then get and check the text

if (state[1].innerText) = 'TO DO') { ...

And finally set backgroundcolor in this row to red

state[1].parentNode.parentNode.style.backgroundColor = 'red'

And of course, all of this you have to do in a loop.

But, the biggest problem you haven't solved. The asynchron load of the jira table.

Regards, Dominic