Hi, I'm relatively new to APEX.
When working with a Checkbox Group within a Faceted Search menu, I notice that when you use the Distinct Values type under List of Values, similar results are grouped together as a single selection, with a number next to it indicating the amount of values that have been grouped. On the other hand, when I instead use a Shared Component (in order to get data via join using an associative entity that implements a many-to-many relationship), the correct data appears with the correct functionality—that is, selecting the associated data from the other table delivers the correct results from the current table, but unfortunately, identical values are displayed separately from one another, each with a (1) next to it, delivering the specific result that that individual instance of the value is associated with in the associative entity table. This is extremely inconvenient.
First of all, I'm wondering why there seems to be different behavior in terms of grouping values between Distinct Values and Shared Component. Am I missing something? Secondly, is there is a way to group these values such that the values from Shared Component display the same as the ones from Distinct Values? Thank youuu