You need to sign in to do that
Don't have an account?
Brendan Lally
Maps, cross object join tables and accessing complex multi-relationship record objects
I get a compile error if I try and create a map of a x-object join table
I have object A and B with a join table of AB
If I try the following I get the following - compile error - Invalid type:AB
..Map ab_recs = new Map();
does this mean that x-object join tables cannot be 'mapped'
I know I can run a query that gives me data from A and B via __r but how do I setup an (map) object to receive them. Will this work if its a List?
for example
I can setup
...Map a_recs = new Map();
and happily read in an 'A' record and access its fields via a_recs.get.(i).fieldname
but if I do a query where its pulling back parent/child related recs via __r or '.' notation HOW is that mapped now?
Can't c how I can do a a_recs.get(i).parentfieldname?
don't c any info on this in docs/cookbook etc.
Lal
I have object A and B with a join table of AB
If I try the following I get the following - compile error - Invalid type:AB
..Map ab_recs = new Map();
does this mean that x-object join tables cannot be 'mapped'
I know I can run a query that gives me data from A and B via __r but how do I setup an (map) object to receive them. Will this work if its a List?
for example
I can setup
...Map a_recs = new Map();
and happily read in an 'A' record and access its fields via a_recs.get.(i).fieldname
but if I do a query where its pulling back parent/child related recs via __r or '.' notation HOW is that mapped now?
Can't c how I can do a a_recs.get(i).parentfieldname?
don't c any info on this in docs/cookbook etc.
Lal
.. List ab_recs = new List();
PS I'm trying 2 do this within a trigger
So how do I process this recs and 'map' the data from
[select field_ab1, fieldab2, fieldab3, a__r.fielda1, a__r.fielda2, b__r.fieldb1, b__r.fieldb2 from ab]
where I now have 3 'chunks' of different objects - ab, a and b ?
Lal
However how to map that complex object back is still a ?
I'd like to use MAP but not sure I can access the right fields. will play and c
Lal