Display and search of the "order" field in invoices

[IP-V15]

When displaying invoices in list mode, the "order" field appears empty and searches yield nothing on this field.
If someone come and fix it ?
Thanks
Config : GLPI 10.0.5 - Windows Server 2016 - PHP 8.0.9 - MariaDB 10.4.20 - "Form Creator" plugin - "Additional fields"plugin - "Order"plugin - Firefox 102.5 ESR

[joekoay]

that is sql script issue, because the current script return 0 value

[joekoay]

i have modified the code and i get the result now, here for your reference

$tab[] = [
'id' => '8',
'table' => 'glpi_plugin_order_bills',
'field' => 'order_name',
'name' => __('Order Name', 'order'),
'datatype' => 'string',
'nosearch' => true,
'massiveaction' => false,
'computation' => '(SELECT name FROM glpi_plugin_order_orders WHERE glpi_plugin_order_orders.id = glpi_plugin_order_bills.plugin_order_orders_id)',
];