Displaying 2 lists in view.list

[adam1109774]

I am using a suitecrm_version 7.14.1 and want to display 2 lists of invoices in a custom module, in List1 will be show list of invoices not send and in List2 will be shown a list of invoices that were already send. Can something like that be done using lists or should i use subpanels? Also i was trying to display just a list of invoices without any limits using the code bellow but was unable to do so any ideas why it doesnt work would be very appretiated.

View.List.php.zip (753 Bytes)
printing list $invoices shows that the 2 record that i added in aos_invoices module are being displayed but are not in a list

[suitecrm_developer]

Hi,
You can create a custom view and in their you can apply the where condition in the query.
If you know SuiteCRM coding, you can understand what I am saying

Please check these articles

How can I customise listview data coming in?

what worked for me is in the custom listview I added this function listViewProcess() { global $current_user; $this->processSearchForm(); $this->params['custom_where'] = ' AND calls_cstm.interaction_status_c = "Open" AND calls.direction = "Inbound" '; if (empty($_REQUEST['search_form_only']) || $_REQUEST['search_form_only'] == false) { $this->lv->setup($this->seed, 'include/ListView/ListViewGeneric.tpl', $this->where, $this->params); $s…

Custom view listview

You can use several different techniques: actually create a saved filter for each user, through the database extend the list view: http://www.urdhva-tech.com/blogs/extending-list-view-query-in-sugarcrm create separate subpanels for each case: http://www.urdhva-tech.com/blogs/add-custom-subpanel-in-accounts-module

And about no pagination, it is not a recommended approach to skip the pagination from any view as it will come up with many performance issues in future when your data size will increase.

Thanks