Announcement

Collapse
No announcement yet.

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

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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
    Attached Files

  • #2
    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?
    /Giuseppe

    Professional Scriptcase Services
    Some Customers opinions

    Comment


    • #3
      Hi Giu,
      I'm using mySQL . I insert DISCTINCT just to try if something went better
      Attached Files

      Comment


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

        Comment


        • #5
          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
          /Giuseppe

          Professional Scriptcase Services
          Some Customers opinions

          Comment

          Working...
          X