Thread: Need Information on how to retrieve DISTINCT records?

Hi Mike,

I am developing a sample application in PHP, in that i'm retrieving the records from salesforce.com (CRM - salesforce.com) and displaying it in a PHP page here my query works fine and displaying the records. Now i want to eliminate the duplicate records but salesforce.com (CRM - salesforce.com) doesn't support DISTINCT keyword and i tried this PHP function array_unique() to display the unique records, but i'm not able to get the records. Can you tell is there any other method to display the unique records from salesforce.com (CRM - salesforce.com) to PHP page.
Thanking You,


Best Regards,
Chiranjeevi.T.G

Hi and thanks for understanding about sending me emails about answering questions. I know that Salesforce does not support DISTINCT and that getting unique records from Salesforce.

Do the records that you are extracting have a field that you can key on? Like an email address?. You could setup a temporary variable to capture the email address coming in from salesforce and then compare it, then exclude it, if you find a match

The best way to do it would be to setup a database and table, create an extraction to that table using the records, set a CRON job to run and load the data every so many hours or once a night and then you could use MySQL as your database of record. That is what I do, but I use Oracle.


Hope this helps and let me know if you have any other questions


~Mike