X2CRM official Logo & Trademark
X2CRM Logo & Trademark

You can use the following MySQL query to get a built in color scheme or theme from the X2CRM database.

MySQL Query: 

SELECT *

FROM x2_media t

WHERE

t.associationType =’theme’

AND t.fileName=’Terminal’

AND t.private=0

LIMIT 1;

Explanation: 

This mysql query will return a theme which is not private to individual users of X2CRM. In case of above query, it will return a Terminal theme, i.e., the default Dark theme available in the CRM out of the box.

If you have some custom theme / color schemes saved in the database, you can also fetch those by modifying the attributes of WHERE clause in the above SQL statement.

 

If this SQL statement is not working for you, or if you are facing issues while executing this query, add a comment in the comments section below and I will try to help you out! 

NO COMMENTS

LEAVE A REPLY

*