ParamQuery grid support forum

General Category => Help for ParamQuery Pro => Topic started by: neoinbiz on September 11, 2019, 11:49:00 pm

Title: Carriage Return for multiple values in a cell
Post by: neoinbiz on September 11, 2019, 11:49:00 pm

I have a field that has multiple values and when it returns the values it words wraps
I want carriage return for each value that is separated by "|".
Ultimately just carriage return each value minus the "|".

Title: Re: Carriage Return for multiple values in a cell
Post by: paramvir on September 12, 2019, 09:24:56 am

"|" can be replaced with "<br/>" in column.render callback

Code: [Select]

render: function(ui){
  return ui.cellData.replace(/\|/g,"<br/>");
}


Title: Re: Carriage Return for multiple values in a cell
Post by: neoinbiz on September 12, 2019, 06:34:12 pm

Thank you for the reply

I get this error "Unable to get property 'replace' of undefined or null reference"

Code: [Select]

{ title: "Deployed Location", width: 200, dataIndx: "DeployedLocations", hidden: hideLoc, /*hideLoc uses the varible from the dropdown list deployedLoc and the condtion is around Line#312*/
filter: { type: "textbox",
        condition: 'contain',
        listeners: ['keyup']
     },
render: function(ui){
  return ui.cellData.replace(/\|/g,"<br/>");
}      
},


Title: Re: Carriage Return for multiple values in a cell
Post by: paramvir on September 12, 2019, 08:41:37 pm

It can be modified to take care of null / undefined values. Hope you have understood the concept and make changes according to the field values in your column.

Code: [Select]

render: function(ui){
  return (ui.cellData || "").replace(/\|/g,"<br/>");
}