How to change the query for the orders list in Back Office - Prestashop 1.7.8

[Ana MBL]

I need to change the way the information is retrieved for the orders list in the BO.

I know the columns and filters are defined in /public_html/src/Core/Grid/Definition/Factory/OrderGridDefinitionFactory.php , but I don't need to change the columns, just the information inside them (for example, for the customer name column, in certain situations the name should be shown differently). However I can't find where the actual query that retrieves the data is created.

Edited August 22, 2022 by Ana MBL
added prestashop version (see edit history)

[Ana MBL]

I figured it out in the meantime, leaving this here in case somebody else needs it in the future: the file containing the query fields is /src/Core/Grid/Query/OrderQueryBuilder.php

[JoaquimMarques]

Hello Ana MBL,

I'm using Prestashop 1.7.8.11. Without your help, it would have been very difficult to display the City and State instead of the country and to show the full name of the customer.

Thank you very much