jsonquery | Basic json - sqlalchemy query builder | SQL Database library

I'm quite new to javascript and jsfiddle. I've been able to toy around with other fiddles that I find, but setting one up myself has proved difficult.

I'm attempting to use a library from npm to get a proof of concept for how it might work. I'm not sure why my import of the module is not working with jsfiddle.

What am I missing to get my fiddle working?

• used the resourced bar to import the unpkg script

I am trying to perform a GET query search in elasticsearch using httpclient. Whenever I do so though, I get an error when hitting my HttpResponseMessage response variable. It tells me it is a 400 (Bad request).

I checked my jsonQuery and copy that jsonObject and paste it into the CLI of Kibana and I actually get results in the CLI. So I am not understanding why I am getting a 400 bad request.

If I am doing a GET /"indexname"/_search in the CLI of kibana would I need to use .PostAsJsonAsync()?

I am trying to pass my variable query as a Json object. So I saw online that one way to do so is by doing JObject.Parse(). I attempted to do so, but when debugging I noticed that .Parse() would create a "{" at the beginning and a "}" at the end of the contents of the variable query. So I then attempted to remove the first "{" and last "}" inside of query but whenever I would hit the JObject.Parse() line, it would throw an exception saying:

Error reading JObject from JsonReader. Current JsonReader item is not an object: String. Path '', line 1, position 6.

So I then attempted to use the code after query, but this would still give me the same error when I hit the next line that consisted of JObject.Parse():

I have been trying to retrieve inner elements using ReactJs. If my input is country=NZ then I am expecting 4 results, it should consider the inner array also, however when I used jsonQuery it is not able to go to the inner array and fetching only 3 results, and it's not going inside friends1. Is there any way we can fetch inner array elements as well?

I am parsing a JSON which has multiple dates but they are not ordered. I want to order them and add them to a list. Now this is the complicated part, I want to order them in descending order such as that :

I using json-query because it lets me find by path inside the JSON object.

After I find it I want to replace the value with a new value and I expected it to affect the string, but it doesn't.

Is there a way to do it using with json-query? or rebuild this JSON again from the object but I can't find a way in the docs.

I have a scope which is acting in a limiting fashion depending on a user role in a way that you can forward a set of rules to the scope limiting the final output from the DB.

A really simplified role limit example: