AnsweredAssumed Answered

Show Unique Records only In a found set script

Question asked by pmehta91 on Jan 8, 2015
Latest reply on Jan 12, 2015 by pmehta91

Title

Show Unique Records only In a found set script

Post

Hi 

In a found set I have all the records that match the search I have set. However, each record layout has a portal within it. E.g. A company sells pens, but in the portal it lists pens twice as they are from different brands. 

In the found set if a search for pens was made, it shows the company twice in the found set. I want the company to only appear once.  Please note the fields in the results page is from two different tables, e.g. the name is from one table (which is the uniqueid) and the email address / phone number are on another table. 

I have tried to constrain the found set with a ! but still no luck. 

Any suggestions?

Outcomes