I have an content type (bundle) "Journal" that has a field "journal number" (integer field) and an entity reference to "Document" bundle. I have a view that lists"document" objects as a table. I want to add there a number of journal referencing to the "Journal" item. It can be done via Relations in Views. But then I want to see this number as a link to corresponding journal. I see two ways there:
.1. that number is shown as a link via "override" option of the field with hardcoded url. (I use pathauto with custom patterns which means that I'm to monitor that hardcoded with "override patterns" urls to be correspondent to their actual urls provided by pathauto)
Pros: the field is sortable as an integer (I want it to be that).
Cons: if Pathauto patterns change, the views overide patterns should be changes correspondingly by hand.
.2. Add a field "Link" referencing to that journal and override this field with a journal number field.
Pros: linking system works without any crutches: Pathauto pattern changes -> link to journal will still work.
Cons: The overriden property is NOT SORTABLE
How can i get both beiing a link and sortable ability as a number for a field?