Prev
Next
Forums Integration / Customization S3 Customization/Development

Distinct Value in screen rules

 4 Replies
 0 Subscribed to this topic
 17 Subscribed to this forum
Sort:
Author
Messages
ARaja
Advanced Member Send Private Message
Posts: 26
Advanced Member
11/11/2013 10:48 PM

I have a custom file with three fields in it. All three fields are part of the primary key. I have a selects built that are working but they return all records. Is there a way to return only the distinct list of the first field. So My table has Group, company, and location in it. Currently my selects return every combination in the table. I want to return only a distinct list of group names.

So instead of Group1, company1, location1 Group1, company1, location2 Group2, ......

I want Group1 Group2 Thanks, Alex

Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
11/11/2013 11:12 PM
Maybe another custom table that just has the one field ? Your select can be based on this new table and just show Group1, Group2....
ARaja
Advanced Member Send Private Message
Posts: 26
Advanced Member
11/12/2013 2:52 PM
Is there any other options without using an additional table.
Ragu Raghavan
Veteran Member Send Private Message
Posts: 477
Veteran Member
11/12/2013 6:03 PM
create an index with a condition (where company = null and location = null) Create records with just the group populated and company/location null in the Select, refer to this index If you have Design Studio, paint a drop-down list and populate the list with whatever values you want.
ARaja
Advanced Member Send Private Message
Posts: 26
Advanced Member
11/12/2013 6:33 PM
The company and the location will have a unique record for the same group. Group A will have more than one record for a different company and location combination. And in my drop down i need to display my Group A only once.