[bluepicaso]

hey,
i am facing a problem with showing distinct records.
my table structure
[img]http://i.imgur.com/idHte.png[/img]

and i simple want to run this query in CRUD

select distinct(proCode) from products

showing only distinct records.

Thank you

[cleberkr]

change in grocery_crud_model.php line 53:

 

    function get_list()

    {

    if($this->table_name === null)

    return false;

 

    $select = "distinct `{$this->table_name}`.*";

[cleberkr]

This could be added to core! ?

[Amit Shah]

I will not recommend hampering the core library - rather this is an uncommon requirement - i will recommend you to use custom model for the same.

 

Happy GCing :)