Is there any way to Group By part of string in SOQL.
For example something like:
Select Id, Name from Object__c group by Name.substringBetween('.','.')
So query by part of a string field and not the whole field.
The other approach that can be taken to this is to create a formula field that takes the substring between the name field, and then use that field in the group by, if there is no other option.
Thanks in advance.