Select Distinct

[PowerSystemCH]

I really use RESTfm since some time and it's very useful, thanks.

Please add the SELECT DISTINCT option to the SQLParser. That would be great.

Markus

[gav-]

Hi Markus,

The SQL parser was designed to construct queries that are supported by the underlying FileMaker PHP/XML API. As there is no FileMaker equivalent to DISTINCT, this hasn't been implemented.

It is technically possible to perform this operation in PHP once RESTfm has received the found set from FileMaker.

I will leave this ticket open. It might be something we consider in the future.