You need to sign in to do that
Don't have an account?

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
Has anyone encountered the same issue? If so, what was the workaround?
Thanks
Neema

What type of field are you trying to use to combine the two objects?

The fields would name
1. Name (string)
2. Site Name (String)
3. Date created (Date)
4. Site address (String)
5. Site City (string)

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?