How can I customise listview data coming in?

SuiteCRM Forum - English Language
1

I would like to add a where clause to the data shown in the list view, where the status of the call is open will be only shown. How can I add this?

Thanks

2

Would you like to apply an automatic and unconditional filter for only open Calls?

3

Yes correct, I want to show only the calls from the open status and then the user can detailview into the call and close it. Once closed it will not show in the list. So I need to add a WHERE statement. But not sure where to add. It is not a custom module.

4

The easiest way, without coding, is to create a saved filter.

image
image748×549 36.1 KB

image

5

Thank you for the answer, however I didn’t want to let the user choose this filter. I can code if you can guide me a bit on what exact query or function to tweak.

6

This could be achieved by adding an ‘after login’ logic hook.

er
er1447×805 120 KB

This logic hook will trigger a function when a user logs into the system, which will add the filter to the module specified in the triggered function. Please find the image attached:

ert.PNG
ert.PNG1447×763 131 KB

This function can be customized as per the need and the code that is highlighted will actually add the filter in the database. The highlighted code can be customized as per requirements to filter the records by where clause. In the query, the ‘status advanced’ is the field name we want to filter upon and the value contains the field value the module key contains the name of the module on which the records must be filtered in the list view. So in this example, the list view for the meetings module will be customized to show the records that have the status ‘Planned’, and the assigned user for the meeting is the currently logged-in user.

1 Like
7

Okay let me try this, thank you.

8

Sure, let me know if it works!

9

Hi @Rolustech it seems like not working. This is the code.

image
image1016×494 25.2 KB

image
image1078×630 44 KB

10

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);
            $savedSearchName = empty($_REQUEST['saved_search_select_name']) ? '' : (' - ' . $_REQUEST['saved_search_select_name']);
            echo $this->lv->display();
        }
    }
2 Likes
11

Hi @itsassef, may i know if you used the logic hook “after login” to take effect or just add the function in custom listview? and if you used the logic hook, where did you put it, on the custom modules? Thanks

12

Hi, No just use the code I posted. It works.

13

Thanks, but it seems didn’t work for me even I tried to repair and still the same. I wonder if it relates to the version, I am working on 8.4. I am actually working on Product Categories module and by default it does not have the view.list.php in the main module, where now am adding in custom/module, wonder if I am correct?

14

Hi, Mine was Version 7.14. It could be the reason.

15

I see. Thanks for your replies.