DISTINCT

usage

<DISTINCT>
  <object>
    <INFO>
      <fieldname/>
    </INFO>
    [<WHERE>
      ...
    </WHERE>]
  </object>
</DISTINCT>

paramètres

object: the name of a sushee object (or your own object). e.g. CONTACT, GROUP, MEDIA, etc
fieldname: the name of the field for which you want to know all the distinct values

retourne

A list of the distinct values for the given field.

exemples

<DISTINCT>
  <CONTACT>
    <INFO>
      <OWNERID/>
    </INFO>
  </CONTACT>
</DISTINCT>

<DISTINCT>
  <MEDIA>
    <INFO>
      <MEDIATYPE></MEDIATYPE>
    </INFO>
  </MEDIA>
</DISTINCT>

<DISTINCT>
  <CONTACT>
    <INFO>
      <CONTACTTYPE></CONTACTTYPE>
    </INFO>
    <WHERE>
      <GENERAL>nectil</GENERAL>
    </WHERE>
  </CONTACT>
</DISTINCT>