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)', ];

[IP-V15]

Thank you very much ! Can you tell me how to add a hyperlink to the order form?

[stonebuzz]

@joekoay

can you open a pull request concerning you fix ?