dataField can't access subobject

[kopax]

I have an object which is like that

{
  "person_id": 1,
    "username": "UserTest",
    "created_at": "2015-09-10T21:13:56.000Z",
    "updated_at": "2015-09-10T21:13:56.000Z",
    "deleted_at": null,
    "Person": {
          "id": 1,
          "firstname": "UserTest",
          "lastname": "Obama",
          "note": "DevOps",
          "email": "iam@obama.com",
          "created_at": "2015-09-10T21:13:56.000Z",
          "updated_at": "2015-09-10T21:13:56.000Z",
          "deleted_at": null
    }
}

I can't access the subojbect using

<TableHeaderColumn dataField="Person.firstname">Firstname</TableHeaderColumn>

Is there any workaround not specified in the doc ?

[AllenFang]

Hi @kopax, the nested object does not supported on newest version in this component, sorry for that. But I can add it in the future, but this is not in my plan, so I need more plan or thinking on this feature. :)

[kopax]

I have made a little modification in TableBody.js
I don't know if this is enough for the rest of the feature provided by your lib, could you check a quick look ?

/blob/master/lib/TableBody.js line 101 replaced by :

        var fieldValue = null;

        if( column.name.indexOf('.') != -1 ){
          var depth = column.name.split('.');
          while(depth.length > 0){
            fieldValue = fieldValue ? fieldValue[depth.shift()] : data[depth.shift()]
          }
        }
        else{
          fieldValue = data[column.name];
        }

What do you think ?
I think you should also handle errors.

Edit: I have just tried with filter field, doesn't work (input placeholder is "Person.firstname")

[AllenFang]

Hi @kopax , it's a way to implement this feature and I think it will be OK. but there are a lots of feature in this component, include cell edit, filter ..etc. so I need to consider these part for design this feature, so it will take some time. Anyway, if you just want to "display" the nested data on component, I think your solution is ok :)

[kopax]

Hi @AllenFang , I am really trying hard to implement subobject management but the problem is that some comments are missing in your code.
Could you provide me further runtime details ?

My idea would be to add a dataPath="Person" to TableHeaderColumn props

[AllenFang]

Hi @kopax , did you folk my project? I cant find your repository. I thinks I can spend a little time to watch out your folk and help you debug :)

[kopax]

I didn't for some (stupid) reasons :

I have two table Person and User
User doesn't have a primaryKey, the indexKey in User is person_id

The current add/edit feature add new User instance to dataSet with wrong nested Object (created key is "Person.firstname", insteand of "Person": { "firstname": ... }

I think I can't use this feature so I will need to do a bunch of modification just for my needs

[AllenFang]

Hi @kopax, you mean you want the add/edit feature work with nested object? If yes, I thinks it's a very very hard work. And you really cant solve the problem on your side, I can help you, but you need give me your folk first

[lebeier]

This feature is definitely welcomed. the fact that it does not support nested objects make it feel rather rigid in design. I hope to see this implemented soon =)

[kopax]

@AllenFang sorry for not replying. I really liked your table unfortunately I wasn't able to implement anything in your code.
I would also love to reuse react-bootstrap-table in the futur so +1 for adding the feature

[AllenFang]

that's ok, I know this feature is very important, but I'm busy and there are lot of things to do, so I prefer to fix bug first. If I've free time, I'll come back and support this features. Anyway, PR is welcome :)
Thanks

[juancarlosfarah]

+1
Will try and have a look at this too!

[ronsc]

+1

[VenkataKotra]

+1

[awlh]

+1

[ZacharyKlein]

+1

[daniel1943]

+1

[nguyenchanhnghia]

using dataFormat to rewrite this cell .

[kopax]

I did have a look at the code and this seems complicated to implement the way it is made. I doubt this feature will be added in the futur.

[AllenFang]

@kopax, yes, it's little hard to implement.. I only have a way, is create a preparer and flat the nested object according user's defined and take this flatted object into table. I prefer to tackle v3.0.0 and go back to check my idea whether is work or not.

Sorry, make this issue pending...

[kopax]

Ok, all I can say is thanks for sharing the code. Wait & see

[galpratama]

Really need this feature too..

[welcoMattic]

👍 Is there any fork of this project with this feature?

[AllenFang]

#508 (comment)

[Obiwarn]

+1

[gengjiawen]

You can use formatExtraData to hack

const column_meta = [
    {columnName: 'user_detail.phone_number', displayName: 'User Phone'},
];

function extraFormatter(cell, row, extra) {
  return eval(`row.${extra}`);
}

let columns = column_meta.map(i => {
    return <TableHeaderColumn dataField={i.columnName} dataFormat={extraFormatter} formatExtraData={i.columnName}>
        {i.displayName}</TableHeaderColumn>
      });

then add colunms to BootstrapTable.

[AllenFang]

@gengjiawen, I will. Sorry for making this feature delay

[gengjiawen]

And this is quite common case if you are using graphql.However, you can easily hack it even without eval, google js flattern object you will get the answer.

[alanqthomas]

+1
Working around it is fairly simple, but it shouldn't need a workaround at all.

[ferrwan]

I'm using lodash's _.get lib to achieve this.

import _ from 'lodash'

const renderCustom = (cell, row, extra) => {
    const value = _.get(row, extra.path)
    return <div>{value}</div>
}

const columns = [
    {path: 'Person.firstname', title: 'Firstname'},
    {path: 'Person.lastname', title: 'Lastname'},
    {path: 'this.is.a.long.path.of.an.object', title: 'Long Path'},
]

const tableColumn = _.map(columns, (column) => (
    <TableHeaderColumn
        dataField={column.path}
        dataFormat={renderCustom}
        formatExtraData={column}
    >{column.title}</TableHeaderColumn>
))

[Siyfion]

I was just about to add to this... Why can't we simply make a PR that uses both the lodash _.get:
https://lodash.com/docs/4.17.4#get
and _.set:
https://lodash.com/docs/4.17.4#set

When retrieving and setting values?

[nivek91]

+1 still no fix for this?

[nivek91]

@ferrwanz the key is missings in your code:

import _ from "lodash";

const renderCustom = (cell, row, extra) => {
const value = _.get(row, extra.path);
return

{value}

;
};

const columns = [
{ path: "CPA", title: "cpa", isKey: true },
{ path: "entreCalles.calleA", title: "entreCa" }
];

const tableColumn = _.map(columns, column => (
<TableHeaderColumn
dataField={column.path}
dataFormat={renderCustom}
formatExtraData={column}
isKey={column.isKey}
key={column.path}

{column.title}

));

[aaronryden]

hey @nivek91, any thoughts on sorting this nested field?

[nivek91]

which field @aaronhayes ?

[PraxentSupport]

I solved the issue without modification of the project 👍
<TableHeaderColumn dataField='Contact' dataFormat={ this.contactFormatter } >Contact</TableHeaderColumn>

and the function :
contactFormatter(cell, row){ return ${cell.first} ${cell.last}; }

[logolevel]

Working example with the required field is the key. Thanks to ferrwanz and nivek91.

import _ from 'lodash';

const renderCustom = (cell, row, extra) => {
	const value = _.get(row, extra.path);
	return <div>{value}</div>;
};

const columns = [
	{ path: "id", title: "ID", isKey:true },
	{ path: "animal.cat", title: "Cat" },
];

const tableColumn = _.map(columns, column => (
	<TableHeaderColumn
		dataField={column.path}
		dataFormat={renderCustom}
		formatExtraData={column}
		isKey={column.isKey}
		key={column.path}
	>{column.title}</TableHeaderColumn>
));

Then you need to add to the method render, next code:

render() {
	return(
		<BootstrapTable data={ transactionData }>
                     {tableColumn}   
		</BootstrapTable>
	);
}

[kopax]

@logolevel does all the features works ?

[logolevel]

kopax, yes.

[romainPellerin]

@logolevel thanks so much for this example.

I am trying to aggregate data within one column like animal.firstname + animal.lastname into a path (yes I named my cat with a full name ;)).

Does any one have a solution for that?

[StohlmanMatteo]

building on @PraxentSupport's response. I'm using:
function objectFormat(data, cell) { if(data.constructor===Array){ if(data[0]=='last'){ return <p>${cell[data.length-1][data[1]]}</p> } return <p>${cell[data[0]][data[1]]}</p> } return <p>${cell[data]}</p>; }

dataFormat={ objectFormat.bind(this, [0,'address'])}
or
dataFormat={ objectFormat.bind(this, 'number')}

Note: need to ad ` around return values.

[janpauldahlke]

@StohlmanMatteo
works fine for me, thanks. just a quick note for all the other coming from google. just hsow how to use `` :-)

[georgewritescode]

Building off the above: (This is using lodash but can work out how to use if dont want to use lodash/underscore)

First create a method in your react component like this replacing 'datapropertywithnested.nestedpropertyname' this your specifics:

depthFormatter(cell, row)
    { 
        console.log("contactFormatter")
        console.log(row)
        console.log(cell)
        let val =  window._.get(row,'datapropertywithnested.nestedpropertyname');
        return <div>{val ? val : 'none found'}</div>;
    }

Then in your table:
<TableHeaderColumn dataField='anything' dataFormat={this.depthFormatter}> Custom </TableHeaderColumn>

[georgewritescode]

However the above solution doesn't support filtering

As such I found the easiest solution is to modily your data before it enters the table to flatten it, such as through:

 let data = tableData;
        data = data.map((item,index) => {
            if(_.has(item,'contact_company.name')) {
                item.contact_company_name = item.contact_company.name;
            }
            return item;
        });

Table as regular:

<BootstrapTable data={data}>
<TableHeaderColumn filter={{ type: 'TextFilter', delay: 100 }} dataSort={true} dataField='contact_company_name'>
Company Contact Name
</TableHeaderColumn>
</BootstrapTable>

[AllenFang]

sorry guys, as I mention on README, I already decide to create react-bootstrap-table2, I trust it will be better than react-bootstrap-table. A good news is I'll support the nested data in react-bootstrap-table2 start from v0.0.1, bad news is I will not support the nested data in react-bootstrap-table.

Feel free to let me know your idea and any idea/issues is welcome on react-bootstrap-table2

Sorry for inconvenience.

[maxpdx]

Any updates?

[Ogglas]

To people finding this thread: Using lodash works well with displaying data but the data presented will not be searchable or sortable.

import _ from 'lodash'

const renderCustom = (cell, row, extra) => {
    const value = _.get(row, extra.path)
    return <div>{value}</div>
}

const filterValue = (cell, row) => {
        //Cells that are subobjects won't hit this metod
        debugger; 
 }

const columns = [
    {path: 'Person.firstname', title: 'Firstname'},
    {path: 'Person.lastname', title: 'Lastname'},
    {path: 'this.is.a.long.path.of.an.object', title: 'Long Path'},
]

const tableColumn = _.map(columns, (column) => (
    <TableHeaderColumn
        dataField={column.path}
        dataFormat={renderCustom}
        formatExtraData={column}
        filterValue={filterValue}
    >{column.title}</TableHeaderColumn>
))

[AdnanBoota]

@Ogglas any idea about sorting the field? or any approach to dataSort and also dataFormat with formatExtraData?

Thanks.

[AdnanBoota]

To go furthher into nested fields, i'm passing string and then returning the key/value pair.

const nestedFields = (data, row, field) => {
  let nested_field = field.split(',');
  return data[nested_field[0]][nested_field[1]];
}

<TableHeaderColumn row='1' dataField="torque_sensor" formatExtraData="top_hits,process" dataFormat={nestedFields} dataSort>Process</TableHeaderColumn>

[mcmwhfy]

Or the simplest way:

tableDataFormat(cell, index){ 
    return (
    <React.Fragment>
        <span className="d-block">{index.name}</span> 
        <span className="d-block">{index.location}</span>
    </React.Fragment>)
}

<TableHeaderColumn dataSort={ true } dataFormat={this.tableDataFormat}>Name </TableHeaderColumn>

you need also dataField only if you are using isKey={ true } on element