Mrthfx

Working with a prototype of a lightning web component, I get that the datatable, just like its Aura brother, needs the columns to be manually specified.

That being said, I have the following specification for a datatable that receives pricebook entries:

const columns = [

    { label: 'Name', fieldName: 'Product2.Name' }

]

The names do not display on the component, but if I use a forEach to list the data retrieved by the component, I get the products names, like in:

connectedCallback() {

    getProducts({ pricebookId: this.pricebookId, countLimit: 4 })

        .then(result => {

            this.products = result

            this.products.forEach(p => {

                console.log(p.Product2) // Proxy {} object is displayed

                console.log(p.Product2.Name) // The name is displayed

            });

            this.tableIsLoading = false

        })

        .catch(error => {

            console.error(error)

        })

}

If the datatable component does not support this, then the correct way of dealing with this is to work with the retrieved data, and build a new list with direct access to the data (no parent-child objects), or to edit the current data and include fields that I can access?

For example, should I iterate the result data and add a productName attribute to the elements, and then set 'productName' as the attribute on the column variable?

Edit: just noticed that you can't iterate the data list and create a new productName property. You end up with a TypeError: 'set' on proxy: trap returned falsish for property 'productName'.

The lightning:datatable assumes that the field name is not an object, but you can have a period in a field name.

Consider this data:

[{ 'Product.Name': 'Hello' }, 'Product': { 'Name': 'World' }}]

If you had data like this, the output in lightning:datatable would be "Hello", not "World".

Here's a copy-paste example for you:

<aura:application extends="force:slds">

    <!-- attributes -->

    <aura:attribute name="data" type="List" default="[{'Product.Name':'Hello', 'Product':{'Name':'World'},'id':'5'}]"/>

    <aura:attribute name="columns" type="List" default="[{ 'label':'Product Name','fieldName':'Product.Name'}]" />



    <!-- the container element determine the height of the datatable -->

    <div style="height: 300px">

        <lightning:datatable

                             keyField="id"

                             data="{! v.data }"

                             columns="{! v.columns }"

                             hideCheckboxColumn="true"/>

    </div>



</aura:application>

This is true for both the Aura and Web component versions.

So, to answer your question, yes, you will need to do some post-processing on your data. It can be as simple as:

this.products = result.map(

  record => Object.assign(

    { "Product2.Name": record.Product2.Name },

    record

  )

);