Small issue with displaying features in the BO product list

[Rhobur]

Hi,

I have added a few columns with features to the Catalog->Products.

All OK except I can't get the search to work for them.

My problem is that in  order to be displayed I need to make a sql alias for each table column which has to be exactly the column name, alias used by the SELECT clause.

I need to do that otherwise I get an error in the WHERE clause for xxxx not being a column name.

But if I end up with lets say 4 identical aliases then these couldn't be added to the fields_list in order to construct the form columns.

Using the column alias from the SELECT clause doesn't work, it displays the column data but results in no search data found.

Any idea of how the search can be achieved when having to deal with multiple tables having the same column name?

[rocky]

Have you tried giving the identical columns different names? For example: a.`column` as a_column, b.`column` as b_column and then using 'a_column' and 'b_column'.

[Rhobur]

Yes I have tried that but for some unknown reason the search doesn't work unless the alias is "value" which is each table's column name.

If I use a different alias, the content of the table column is displayed but not searchable :puzzled: