On my client's site, I have a SQL query that brings the readiness result of multiple collaborators. However, for the moment I can only translate the result of the query into a GridView:
SQL CONSULTATION
SELECT codigoAvaliacao, codigoColaborador, nomeColaborador, nivelProntidao
FROM TableAvaliacoes
RESULTS EXAMPLE
codigoAvaliacao | codigoColaborador | nomeColaborador | nivelProntidao
--------------- | ----------------- | --------------- | --------------
1 | 1 | Fulano | 90
2 | 3 | João | 75
3 | 4 | Ciclano | 83,5
4 | 6 | Beltrano | 44,44
5 | 10 | Silva | 68,11
My idea was to bring the result of this query in another way, associating it with a figure called NineBox. It puts the names in the squares depending on the level of readiness. Here is an example of the figure as I found it on the internet:
There,fornow,IcouldonlyputtheHTMLcodeofthetablewiththepropercolors:
<table><tr><tdwidth="200" height="200" style="color: black; background-color: yellow"><center id="names1"></center></td>
<td width="200" height="200" style="color: black; background-color: rgb(151,195,82)"><center id="names2"></center></td>
<td width="200" height="200" style="color: white; background-color: rgb(12,133,54)"><center id="names3"></center></td>
</tr>
<tr>
<td width="200" height="200" style="color: black; background-color: rgb(245,154,73)"><center id="names4"></center></td>
<td width="200" height="200" style="color: black; background-color: yellow"><center id="names5"></center></td>
<td width="200" height="200" style="color: black; background-color: rgb(151,195,82)"><center id="names6"></center></td>
</tr>
<tr>
<td width="200" height="200" style="color: white; background-color: red"><center id="names7"></center></td>
<td width="200" height="200" style="color: black; background-color: rgb(245,154,73)"><center id="names8"></center></td>
<td width="200" height="200" style="color: black; background-color: yellow"><center id="names9"></center></td>
</tr>
</table>
What I would need then from this SQL query would be created another and something like that (assuming the results were the image names instead of the result example), with the names of each square separated by the tab:
QUADRADO | NOMES
-------- | -----
1 | Francisco
2 | NULL
3 | Vera
4 | NULL
5 | Alice<br>Alexandre<br>Marcos<br>Madalena
6 | Ângela<br>José
7 | Maria
8 | João<br>Pedro
9 | Benedito<br>Carla<br>David
What do I put as an SQL query for this case?