Refined Search functioning ??? How set it to display DISTINCT values ??? Not repeated

Hello all,

I’m trying to introduce the new feature on a Grid to use it as dinamic filter for rows.
Each row is an Item and has its own Category of product.

I want to have on Refined Search only one line for each type of category , not repeated.
I’ve tried to insert DISTINCT on the Select SQL but nothing change.

Any hints will be very appreciated .
Thanks

refined_search.png

Why have you a distinct in your lookup?

How has you defined this field. It’s very weird it repeats in refined search. It works automatically. Wich RDBMS are you using?

Hi Giu,
I’m using mySQL . I insert DISCTINCT just to try if something went better

refined.png

Hello Giu,
did you find a logic on that ugly list ??

Sorry. I have no idea. It’s working as expected, and there aren’t too much to configure it.

Selección_003.png

Selección_006.png

Selección_005.png

Selección_004.png