Sort table with block name, not the block reference

Hi,
I have to manage many projects. Each project has its own page with properties. The code-project property is from a block reference (( double parenthesis)). The active projects query shows the code-project property but when sorting the table Logseq takes the block reference ((6604121d-1c05-43b1-a278-2505d08a18a4)) to sort and not the block name (PRJ0400). How to solve this?
Thanks in advance

Welcome. What query do you use? Special sorting needs a so-called advanced query.

My query returns several properties from all the projects. I’m not looking for sorting on a specific property but rather to be able to sort the table by clicking the table title. Thank you

I’m not aware of any way to modify the sorting behavior when clicking a column title of a table. Consider turning this into a Feature Request.