dropdown remove fields duplicate

I connect the dropdown input data ChronoForms to a column of a table can have duplicate fields, how can I remove duplicates?
Thank you for
Remo

Hi Remo,

If you are using a Custom Code query you can use UNIQUE or GROUP BY in the query code; if you are using a DB Read action then you may need to process the data in a Custom Code action to sort it and remove any duplicate records.

Bob

but I can not use WHERE in DB Multi Record Loader
Thank You
Remo

Hi Remo,

But there is a "Group" field, no ? what's your Chronoforms version ?

Regards,
Max

My Chronoforms version is 4.0 RC3.5.2
Thank You
Remo

Hi Remo,

The WHERE box and Group Model Data settings are both on the Advanced tab of the DB Mulit Record Loader - scroll down to see them.

Bob

Hi Bob
io scorrere verso il basso e vedere WHERE box e Group Model Data. Io ho messo Group Model Data su "yes" ma io non ho avuto alcun risultato.
Io scrivere - GROUP BY 'tipo' nel WHERE box e non ho avuto alcun risultato.
Che cosa io devo fare?
Remo

Google translate:
I scroll down and see the WHERE box and Group Model Date. I put Group Model Date "yes" but I have not had any results.

I write - GROUP BY 'type' in the WHERE box and have not had any results.

What I have to do?

You must provide some code to the WHERE section first, so please try to write this:

1=1 GROUP BY `type`