How to adopt Skills Matrix boards to use emojis from report statuses post release 140

To display specific emojis based on the status of your training reports, you can use a CASE statement in your SQL query. This method allows you to search for each emoji and return it accordingly, which helps create a more visually engaging and easily understandable skills matrix.

How It Works:

You will write a CASE statement to check for specific emojis in the status field and return the corresponding emoji or other desired result. This ensures that your report will show the emojis directly.

Example SQL Query:

SELECT 
   CASE 
     WHEN status ~ '📥' THEN '📥' 
     WHEN status ~ '✅' THEN '✅' 
     WHEN status ~ '❌' THEN '❌' 
     ELSE 'Other' 
   END AS status_emoji 
FROM t_reports;

Explanation:

• CASE Statement: This checks the status field for specific emojis.
  • status ~ '📥': If the status contains the "📥" emoji, it returns the "📥" emoji.
  • status ~ '✅': If the status contains the "✅" emoji, it returns the "✅" emoji.
  • status ~ '❌': If the status contains the "❌" emoji, it returns the "❌" emoji.
• ELSE Clause: If no emoji matches, the query will return "Other".

Matrix Output:

The result of this query will return a matrix of emojis based on the status of each training report. Here's an example of how it might look in your results:

Why Use This Approach:

• Visual Representation: Emojis provide a quick and clear way to convey the status of each training.
• Customizable: You can easily add or modify emojis and conditions to suit your specific needs.
• Improves Readability: Emojis make it easier to distinguish between different statuses at a glance.