Split the string and convert to json object using nodejs

Question

I am trying to filter my data(mongoDB) based on the query params which I will be sending in the api as below. But mongoDB doesn't support comparison symbols so I am trying to convert all the symbols to proper query operators before sending to find().

GET /companies/?created_by<2&type<=Subsidiary&modified_by!=3

For my above url req.query will look like below:

{ 'created_by>2': '', // { created_by: { $gt: 2} }
  'type<': 'Subsidiary', // { type: { $lte: Subsidiary } }
  'modified_by!': '3' }  //  { modified_by: { $ne: 3 } }

I have six cases while filtering. Whenever particular field of my data comes for filtering I have to convert it proper json.

field=value // { <field>: { $eq: <value> } }
field!=value  // { <field>: { $ne: <value> } }
field<value   // { <field>: { $lt: <value> } }
field>value   // { <field>: { $gt: <value> } }
field<=value  // { <field>: { $lte: <value> } }
field>=value  // { <field>: { $gte: <value> } }

Below is my json object of two fields(this object may change based on my filtering):

{ 
   'created_by>2': '',
   'type<': 'Subsidiary'
}

I want to convert the above json to below format with nodejs query parameters ($gt,$lte).

{ 
   created_by: { '$gt': '2' }, 
   type: { '$lte': 'Subsidiary' } 
}

How to convert using nodejs?

What problem are you having in doing this? Can you include the code you have already tried? — Tim Biegeleisen
– Tim Biegeleisen, Commented Jul 1, 2019 at 4:57
Which type of format you want as result? For example, json etc. — Shivani Sonagara
– Shivani Sonagara, Commented Jul 1, 2019 at 4:59
You don't need to specify all operands, if you accept "min" and "max" parameters you can do exactly the same with way less code, e.g. "field < value" means "max=value&min=0" — Ivan Castellanos
– Ivan Castellanos, Commented Jul 1, 2019 at 6:41
I didn't get your point. Can u give sample url how can I pass my query params — mounika kommineni
– mounika kommineni, Commented Jul 1, 2019 at 7:36

Harish · Accepted Answer · 2019-07-01 05:40:17Z

2

you can try something like below,

var obj= { 
   'created_by>2': '',
   'type<': 'Subsidiary'
}

var result = Object.keys(obj).reduce((acc, el)=> {
var op = ''
if(el.indexOf('>') > -1) {
    op = '>'
} else {
    op ='<'
}
var elCopy = el.split(op)
//console.log(el);

acc[elCopy[0]] = { [op === '>' ? '$gt' : '$lte' ]: elCopy[1] ? elCopy[1] : obj[el] }
return acc;
}, {})

console.log(result)

answered Jul 1, 2019 at 5:40

Harish

1,9111 gold badge15 silver badges26 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

mounika kommineni Over a year ago

Thank You Harish. This will not give complete solution for my requirement I updated my question.

Collectives™ on Stack Overflow

Split the string and convert to json object using nodejs

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related