Tracking order on the order list with reduced size

[zabamich]

using Vekia Tutorial https://mypresta.eu/en/art/developer/tracking-number-orders-list.html 

 

we can add tracking number on the order list. this is very useful but how to reduce column size or displayed text to max 60 characters??

 

[gabdara]

In $this->fields_list for tracking_number add:

'class' => 'fixed-width-lg'

[zabamich]

great it works, but how to eslo reduce  character displayed to max 60-70?? now still is displated all characters in this row

[gabdara]

I think you can limit the characters by adding to $this->_select

SUBSTR(oc.tracking_number,1, 60) AS tracking_number

[zabamich]

SUBSTR(oc.tracking_number,1, 60) AS tracking_number

 

That forcing blank page in BO.

[gabdara]

Have you used the exact join as in Vekia's tutorial?

Enable development mode to see what it doesn't like.

[zabamich]

Yes, but i have made modification for shipping number to accept more than 65 charackers in this field. That way in my BO this field is that long. ( depend how long code was sent to customer).

 

Still is very usefull ,but will be great if that column will be displaed only first 50 60 characters

[ozfragrance]

how about making that number hyperlink to the currier website same like what we have in the actual order page. this way we don't have to copy and paste from the order list page to the currier page, just click and takes us there. Thanks