⚠ In case you've missed it, we have migrated to our new website, with a brand new forum. For more details about the migration you can read our blog post for website migration. This is an archived forum. ⚠

  •     

profile picture

Column search not working



subexl
  • profile picture
  • Member

Posted 28 March 2018 - 20:48 PM

Hi.

I'm using GC Enterprise

I have a setup with a column ("product") with product ID's.

i'm using  $crud->setRelation('product','table_products','name');

The column filtering for this column does not work.

 

Seems like filtering is made by original data of the column, the ID, and not the text value of if that gets read from the relational table;

example

 

if i have 3 rows: with values like (3,31,5) the product IDs and  ('xxx','yyy','zzz') as the product nmes got from the relational table, if in the dropdown selectbox filter 1 select 'XXX' wich has ID 3, the row with  value 'yyy' with id 31 shows up too because filtering seems to be made based on the original valued(ID) , so 3 and 31 both have '3' in them, both are shown.

If this is not a bug..than what's the point of having a filter that works only for non relational fields??

 

Is there any way to pass this issue?

Thanks!