How to get addressee and addrphone from an address record?
- returns addressee some of the time and not others, even when I can see that addressee is has a value
- never returns addrphone
Are you looking to get this from the Shipping Address on the item fulfilment itself?
At this point I don’t care how I get it. I’ve tried everything. From the shipping address on the IF would be simplest but it doesn’t work.
I’m seeing values when I include this in my IF search:
search.createColumn({
name: "addressee",
join: "shippingAddress"
}),
search.createColumn({
name: "phone",
join: "shippingAddress"
})
Are you getting inconsistent results with Saved Search too?
Your code was what I tried first.
The same data is missing in saved searches.
Are you seeing those fields on the address that’s shown on the IF in question or on the customer record?
Both on the IF and on the customer
I’m drawing a bit of a blank if address and phone are populated but not shown in your saved search.
The only other thing I can think is whether a SuiteAnalytics dataset / SuiteQL might get you what you need?
