Custom Query for the list view

[mfonsatti]

Hi,
is it possible to customize the query for the account list view ?
the entity account is in relation with a custom entity (Many to One) .
When i'm in Account entity list view , the system to populate the table make a query with also a join with the custom entiry .
This join in list view is not necessary , because there's no column's related to the custom entity .
I want to speed up this query so I need to override it to prevent that the list view is populated using join with the custom entity .

[tanya]

you can override findEntities method in Service

https://github.com/espocrm/espocrm/blob/master/application/Espo/Core/Controllers/Record.php#L155

https://github.com/espocrm/espocrm/blob/master/application/Espo/Services/Record.php#L898

OR

you can add "noJoin" parameter to the link definition if the type is 'belongsTo'

https://github.com/espocrm/espocrm/blob/master/application/Espo/Services/Record.php#L328

example https://github.com/espocrm/espocrm/b...nity.json#L240

[mfonsatti]

Hi Tanya,
thanks a lot for your answer ...
As i told you the relation between Account and Campaign is many to one ... so i don't think that i could use the solution "noJoin".

searching on the web i've found something related to my question : a procedure to make query with only the attribute that are visible on the view ...

https://github.com/espocrm/espocrm/issues/946

https://github.com/espocrm/espocrm/issues/947

Do you confirm that this problem will be solved with the 5.3.0 ??

[tanya]

It is testing now, but it has to be solved in the next release.