You need to sign in to do that
Don't have an account?
Сергей Жугин 7
SOQL querry
Hi everyone. I work with small project and ran into a problem. I need to display the most popular genre of the song in the mix object and the second after it, how can I do it using the main syntax of SOQL. If you give SOQL code or example it would be cool.
Probably solved now (don't forget to post the solution in this case and close the question), otherwise, for complex problems with SOQL queries, you will have more answers here with a sample of data and the expected result.
The following query is not the solution but just a possible option by using the count of song Ids directly.
The problem is that it is not the result probably that you are looking for.
The SOQL queries are very restrained when you combine many objects and only the existing relationships can be used (you cannot join fields outside the existing relationships).
All Answers
It is again better to post some sample data and the expected result.
The following queries that you probably already wrote are not accurate or suitable for what reasons in your case?
We also create rollup summary fields in some cases but it is not interesting here.
Probably solved now (don't forget to post the solution in this case and close the question), otherwise, for complex problems with SOQL queries, you will have more answers here with a sample of data and the expected result.
The following query is not the solution but just a possible option by using the count of song Ids directly.
The problem is that it is not the result probably that you are looking for.
The SOQL queries are very restrained when you combine many objects and only the existing relationships can be used (you cannot join fields outside the existing relationships).