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
Neema Gudur 8Neema Gudur 8 

Workaround for the SOQL union operator

SOQL does not support the UNION operator. I have two custom objects that I need to query and UNION the results.
Has anyone encountered the same issue? If so, what was the workaround?

Thanks
Neema
 
Austin MuellerAustin Mueller
What type of field are you trying to use to combine the two objects?
Neema Gudur 8Neema Gudur 8
The fields would name 1. Name (string) 2. Site Name (String) 3. Date created (Date) 4. Site address (String) 5. Site City (string)
Austin MuellerAustin Mueller
Can you please provide a screenshot of how the two objects are setup? What data on the first object, would you be able to link to the second object?