...
| Note |
|---|
This function works only when using in our builtin SQL navigator. |
| Excerpt |
|---|
This functions "casts" any URL like value to an object which builtin navigator will show as a link to an image. |
...
Basically with this function - you can show an image or icon in table results.
...
| Code Block |
|---|
| language | sql |
|---|
| title | Simple SQL |
|---|
| SELECT I.SUMMARY, P.NAME, P.ICONURL
FROM ISSUES I
JOIN PRIORITIES P ON I.PRIORITY = P.ID
LIMIT 4 |
|
| Code Block |
|---|
| language | sql |
|---|
| title | SQL with ASICON function |
|---|
| SELECT I.SUMMARY, AUX.ASICON(P.NAME, P.ICONURL)
FROM ISSUES I
JOIN PRIORITIES P ON I.PRIORITY = P.ID
LIMIT 4 |
|
|---|
| |
...
