Hey All: I'm trying to Find Ship To Address Data,...
# suiteql
a
Hey All: I'm trying to Find Ship To Address Data, and I am not able to see all of the fields in the AddressBook Record.
SELECT * from AddressBook
only returns
internalid
and
addressname
. Where can I find the Details of this Address? Any thoughts? TIA!
j
I think you actually need to use
entityaddressbook
and
JOIN
to
entityaddress
a
@jen Thank you so very much! I'd been struggling with this one for a good while. How did you find that record? I'm not seeing it in the records browser, so curious how I can find other records like this when I'm at a loss. Thanks a bunch!
j
Setup -> Records Catalog
a
I owe you! Thanks!
Still not seeing it under there, either, though... Strange:
j
not everything is listed in the menu, it’s very annoying
a
That is very annoying. Thank you for the validation check :)