custom SQL for ListView

[hzara]

Hi all,

I need to assemble a custom query for a ListView in the Bugs module. The reason I need this is because, from a custom module, I select a set of values and need to open the bugs modules showing the records that match those values.

For example, I need to answer the question: "All bugs with high priority created between 2 dates".

My current SugarCRM platform is 5.2.0d.

Thanks in advance,
hzara

[SugarDev.net]

If you only need it to work from the custom module, maybe you can extend the Bugs class with Bugs_cstm and override create_list_query_new. Otherwise you may override view.list.php in the MVC framework.

[hzara]

SugarDev.net

Thanks a lot! I'll look into overriding view.list.php in the MVC framework option. If I have any problems I'll get back to the forum.

Thanks again,
Salutti!