How to display the référence of products in commands list

[hajar_rolin]

I want to display the product reference for each order in this table so that I can generate an excel file with the desired fields, do you have any idea how I can do it ?

This is the Current SQL query

[abdullacm]

for customizing the order list grid, you need to create a module and use 2 hooks 
 

actionOrderGridDefinitionModifier 
actionOrderGridQueryBuilderModifier

 

[Knowband Plugins]

You can also try to directly modify the Core files.
File Path: /src/Core/Grid/Definition/Factory/OrderGridDefinitionFactory.php

In the above file you can modify the below function:
protected function getColumns()
To add the column.

And in below file:
/src/Core/Grid/Query/OrderQueryBuilder.php

You have to modify the query to show the data according to your requirement.
Function: private function getBaseQueryBuilder(array $filters)