Parsing query string in Node to allow logical operators

Question

I would like something similar to what node-odata offers, but I do not want to wrap it around my database (I am using Cassandra and already have an Express app set up with routes, etc).

Currently, I grab data from the database (which will ultimately return a JSON object to the user) and then using the values passed in the query string I modify the results with JavaScript and pass the modified JSON object on through to the user.

I cannot pass in a query string like this http://localhost:3001/getSomeData?name=jim&age=21||eyeColor=red which includes logical operators in the query string, and would grab all data and filter it where the name is "jim", the age is "21" OR eyeColor is "red". So this would give me all Jims that have either eyeColor red and/or age of 21. If I used this age=21&&eyeColor=red I would expect to get all Jims that have BOTH eye color of red and are 21 years old.

I was thinking of using a custom query string that can be passed in (i.e. inclusive=age&inclusive=eyeColor appended at the end of the query string) and in Node, I would modify the filter results to treat these properties (age and eyeColor) as if they were passed in with the || OR operator). However, this is quite verbose, and I was hoping there was a library or another simpler implementation out there that solves this problem, or somehow lets me pass in simple logical operators into the query string.

The mistake you're making is trying to change how the query string works. Instead, pass the value you want to parse in the query string such as ?query=name%3Djim%26age%3D21%7C%7CeyeColor%3Dred and then you can access that value and parse it yourself however you'd like. — zzzzBov
– zzzzBov, Commented Dec 20, 2017 at 21:19
@zzzzBov Okay, that makes sense, thanks for reply! Would you happen to know of a library that can parse and filter strings like that (I couldn't find any). Otherwise, I will write my own logic to handle the query string like you suggested. — Attila
– Attila, Commented Dec 21, 2017 at 15:38

Attila · Accepted Answer · 2019-07-02 17:16:49Z

1

I ended up using this library to achieve what I wanted: https://www.npmjs.com/package/jspath

It's well document and worked perfectly for my situation.

answered Jul 2, 2019 at 17:16

Attila

1,1774 gold badges22 silver badges49 bronze badges

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

Comments

Yilmaz · Accepted Answer · 2019-07-01 16:38:54Z

0

npm i querystringify  //or
https://cdnjs.cloudflare.com/ajax/libs/qs/6.7.0/qs.min.js


//it will will return an object
const myObject = Qs.parse(location.search, {ignoreQueryPrefix: true}); 
//you can use object destructuring.
const {age,eyeColor}=Qs.parse(location.search, {ignoreQueryPrefix: true})

By default, parsing will include "?" too.

{ignoreQueryPrefix: true} this option will omit "?".

answered Jul 1, 2019 at 16:38

Yilmaz

51k19 gold badges226 silver badges278 bronze badges

1 Comment

Attila Over a year ago

Hey @Yilmaz, thanks for the reply. I had forgotten to update this question when I wrote it over a year ago. I found a suitable NPM package, please see my accepted answer.

Collectives™ on Stack Overflow

Parsing query string in Node to allow logical operators

2 Answers 2

Comments

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related