Changing theme and branding colors in Jira Service Management

Still need help?

The Atlassian Community is here for you.

Ask the community





Summary

You are able to change the colors used in the customer portal if you have a customized theme and branding for your service project.

If you do not have a customized theme and branding you must set it up in order to customize the colors used.


Procedure

You must first set a customized theme and branding for your service project if you have not already done so

The process described below is a simple update to an existing theme row and has been tested for safety.

  • Do not insert or delete any rows from the database as this may cause corruption.
  • Do not make modifications other than changing one or more of the four colors using UPDATE "AO_54307E_CUSTOMTHEME"

Step 1 - Obtain the ID of the theme you wish to change

  • Use the following SQL query to obtain a list of your service projects along with the THEME_ID for each

    SELECT * FROM "AO_54307E_VIEWPORT";

Step 2 - Obtain the colors currently used

  • Now use the following SQL to obtain the colors used for this service project. Replace XXX with the THEME_ID obtained in the previous step

    SELECT * FROM "AO_54307E_CUSTOMTHEME" WHERE ID = XXX; 
  • The results will look like the following

    jira=# SELECT * FROM "AO_54307E_CUSTOMTHEME" WHERE ID = 1;
     HEADER_BGCOLOR | HEADER_LINK_COLOR | HEADER_LINK_HOVER_BGCOLOR | HEADER_LINK_HOVER_COLOR | ID
    ----------------+-------------------+---------------------------+-------------------------+----
     #000000        | #292929           | #d4171e                   | #ffffff                 | 1
  • The image below shows what each of the fields is refers to

    (info) The color used for the issue count that appears next to "My requests" cannot be changed

Step 3 - Update database with new custom colors

  • Decide on the colors you wish to use and obtain their hexadecimal color code
    • These codes are available on many sites on the internet. Examples are provided in this Google search
  • Create the SQL statement(s) you will use to update the database. An example is provided below:

    (warning) This is only an example. You must customize the SQL to meet your needs (warning)

    UPDATE "AO_54307E_CUSTOMTHEME" SET "HEADER_BGCOLOR" = '#ffffff' WHERE "ID" = 5;
  • Update the database with the SQL. If using Oracle remember to commit the changes
    • Changes will be applied immediately
    • You must refresh any open customer portal pages to see the changes

Rolling back changes

If for any reason you wish to return to the automatically selected colors you can do so by turning off the customized theme and branding and then turning it back on.

  • When you do this a new ID will be inserted into the AO_54307E_CUSTOMTHEME table and the THEME_ID of the service project in the AO_54307E_VIEWPORT will be updated to use the new ID





Last modified on Mar 13, 2023

Was this helpful?

Yes
No
Provide feedback about this article
Powered by Confluence and Scroll Viewport.