In my code, all of the info from a Postgres table row are stringified when a specific rowID is selected.
var jsonRes = result.message.rows;  document.getElementById('panel').innerHTML = '<pre>' + JSON.stringify(jsonRes[0], null, "\t") + '</pre>'   The result looks something like this:
{   "ogc_fid": 143667,   "relkey": 288007,   "acct": "000487000A0010000",   "recacs": "12.5495 AC",   "shape_star": 547131.567383,   "shape_stle": 3518.469618,   "objectid": 307755,   "zone_dist": "MU-3",   "pd_num": null,   "council_da": null,   "long_zone_": "MU-3",   "globalid": "{D5B006E8-716A-421F-A78A-2D71ED1DC118}",   "ord_num": null,   "notes": null,   "res_num": null,   "effectived": 1345766400000,   "shape.star": 629707.919922,   "shape.stle": 3917.657332,   "case_numbe": null,   "common_nam": null,   "districtus": null  }   I am new to JS and would like to know if there might be a simple way to completely exclude the columns containing null values - a function that roughly looks like this:
function hide(jsonObject) {     if (property === null) {       hide property   } else {       return str   } }   So that in the end, the object in the panel looks like this:
{   "ogc_fid": 143667,   "relkey": 288007,   "acct": "000487000A0010000",   "recacs": "12.5495 AC",   "shape_star": 547131.567383,   "shape_stle": 3518.469618,   "objectid": 307755,   "zone_dist": "MU-3",   "long_zone_": "MU-3",   "globalid": "{D5B006E8-716A-421F-A78A-2D71ED1DC118}",   "effectived": 1345766400000,   "shape.star": 629707.919922,   "shape.stle": 3917.657332 } 
                JSON. stringify will omit all object attributes that are undefined .
The JSON.stringify() method converts a JavaScript value to a JSON string, optionally replacing values if a replacer function is specified or optionally including only the specified properties if a replacer array is specified.
Use the JavaScript function JSON. stringify() to convert it into a string. const myJSON = JSON. stringify(obj); The result will be a string following the JSON notation.
You can do something like this:
let x = {    'x1':0,    'x2':null,    'x3':"xyz",     'x4': null  }    console.log(JSON.stringify(x, (key, value) => {    if (value !== null) return value  }))  If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With