SELECT query for the list

[prajeesh]

Hi,

I want to add a condition(filter ) in the SELECT sql query written for the list view page. But I was not able to find the file where the sql SELECT query is written. Please guide me .

Thanks,
Prajeesh

[andopes]

The sql query is defined into function create_new_list_query at data/SugarBean.php
If your module is a custom one you can feel free to implement such function into module class, but if your module is a built in one so you should need to create a custom controller to override the $this->bean.

Best regards

[juanmrs]

The sql query is defined into function create_new_list_query at data/SugarBean.php
If your module is a custom one you can feel free to implement such function into module class, but if your module is a built in one so you should need to create a custom controller to override the $this->bean.

Best regards

Hello i am having troubles to change search condition, i would like to know if its possible change the condition for querys select from like 'word%' to like '%word%', so i can search inside the names,

i hope you could help me.