function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
Ross FieldRoss Field 

SOQL & TopicAssignment

Hi All

I am trying to make a single SOQL call that retreives some records WITH their Topics (from TOPICASSIGNMENT).  For example:-

SELECT Id, Name (SELECT ID FROM TOPICASSIGNMENT) FROM Account

Due to the number of results I will have I cannot determine the TopicAssignment for each record separately - this wil certainly cause me to hit limits.

Many thansk for any and all asssistance
Ross





 
SonamSonam (Salesforce Developers) 
When you say some records - you should be adding the condition using the WHERE clause.
For you to not hit the limits due to the number of records being returned by the query you will have to add filters such that the record set being returned is filtered and less in size.