Hi everyone, is there a way to use a distinct filt...
# community-helpm
Michael
07/06/2023, 1:23 AMHi everyone, is there a way to use a distinct filter without grouping? As in, I only want to get the first result where a field is duplicated
k
Kishore Nallan
07/06/2023, 1:54 AMYes, set
group_limit: 1m
Michael
07/06/2023, 2:13 AMThanks Kishore - but I want to avoid grouping where possible, just want to remove duplicates and return distinct items
Michael
07/06/2023, 2:13 AMAdding some context:
Michael
07/06/2023, 2:17 AMI have an event ticketing system where users have "Events" and then each event can have "Sessions"...
e.g. "Taylor Swift Tour" is the event, and then "New York Show", "Sydney Show"
I want users to be able to search for the session, but return the event and session together.. also linked to their geography...
e.g. If the user lives in New York and searches Taylor Swift - they will get Taylor Swift Tour - New York, but if they search Taylor Swift Sydney, the sort naturally brings the New York to the top
In the search, I only ever want to return one "Taylor Swift Tour" event at a time
Michael
07/06/2023, 2:19 AMThis message contains interactive elements.
Michael
07/06/2023, 2:20 AMThis message contains interactive elements.
Michael
07/06/2023, 2:21 AMSo I'm flattening the Events and Sessions into one schema "events"
Michael
07/06/2023, 2:21 AMBut the group_by field forces the eventId to be a facet, which it really shouldn't be
Michael
07/06/2023, 2:22 AMWhere really I just want to return the top performing result for each eventId
Michael
07/06/2023, 2:22 AMAppreciate your help @Kishore Nallan (sorry about the message spam)
k
Kishore Nallan
07/06/2023, 2:48 AMWhat you probably need a join like feature here. We are actively working on this and will have something to share in a week or so.
🙌 1
m
Michael
07/06/2023, 2:51 AMAwesome, glad to hear!