render array with two fields

montoyam · June 2020

I have an mjoin with a one to many situation. I want to return a comma seperated list of First and Last Name. So, basically I am needing to merge these two:

            ,{
                data: "CaseDefendants",
                render:  {
                    _: '[, ].DefendantFirstName'
                }
            }

and

            {
                data: null,
                title: "Defendants",
                render: function (data, type, row) {
                    return row.DefendantFirstName+ ' ' + row.DefendantLastName;
                }
            },

but i can't figure out the correct syntax.

allan · June 2020

You’d need to write a custom renderer for it:

data: ‘myArray’,
render: function (data) {
  return data.map( function (o) {
    return o.DefendantFirstName + ‘ ‘ + o.DefendantLastName;
  } );
}

Allan

montoyam · June 2020

thanks. i don't know a lot of javascript/jquery functions. .map did the trick. thanks. at first i was wondering where the comma separator was going to come from when looking at your code, but in reading about .map i see that it is returning an array, which is by nature separated by commas??

allan · June 2020

Oops - I should have added .join(', '); there! What is probably happening at the moment is that Javascript will be taking the toString() of the array return which is basically the values comma separated. I think if you look closely at them, you might find that they don't have spaces at the moment. Adding the join will fix that.

Allan

render array with two fields

render array with two fields

Answers

Howdy, Stranger!

Categories

DataTables

render array with two fields

render array with two fields

Answers

Howdy, Stranger!

Quick Links

Categories

DataTables