Sortable Link

We know how to add a link field to a table, using:

Here is a way to get it to be sortable… Insert a throw-away attribute to the left of the link.

instead of

CONCAT('<a href="', `Card Link`, '" target="_blank">',`Title`,'</a>')
Use
CONCAT('<a title="', `Title`,'" href="', `Card Link`, '" target="_blank">',`Title`,'</a>')

Then the column will be sortable by the displayed text.

Tagged: