How to get the value from search.lookupFields when using a join in the columns

AI generated answer (using internal Slack threads):

To get the value from

search.lookupFields

when using a join in the columns, you need to use the full string including the dot as the key. For example, if you have a joined column like 'shippingAddress.internalid', you should use it as the key in the

fieldLookUp

object. Here is an example:

javascript
var fieldLookUp = search.lookupFields({
    type: search.Type.SALES_ORDER,
    id: transactionID,
    columns: ['location', 'shippingAddress.internalid']
});

// This works for location
console.log(fieldLookUp.location[0].value);

// This works for shippingAddress.internalid
const shippingId = fieldLookUp['shippingAddress.internalid'][0].value;
console.log(shippingId);

In this case,

fieldLookUp['shippingAddress.internalid'][0].value

is used instead of

fieldLookUp.shippingAddress.internalid[0].value

. The key is the full string 'shippingAddress.internalid', not 'internalid' inside an object called 'shippingAddress'. When you have strings that include a period, you should reference them with square brackets instead of dot notation. ****** Disclaimer: This response was generated by an artificial intelligence assistant based on previous conversations from multiple Slack channels, and may contain inaccuracies or mistakes. ******