Stack Overflow
Stack Overflow

Questions tagged [sqlike]

SQLike (not SQLite) is a small (10 kB) query engine for JavaScript and ActionScript.

SQLike (not to be confused with SQLite) is a small (10 kB) query engine for JavaScript and ActionScript. Its functionality and syntax is similar to that of SQL and it can be used to query arrays of objects or arrays of arrays.

More at http://www.thomasfrank.se/sqlike.html

4 questions
2
votes
1 answer

SQLike - understanding the basics

I'm trying to use the query engine SQLike and am struggling with the basic concept. The JSON I'm using as my data source comes from my PHP code, like so: var placesJSON=; Here's a sample JSON: var…
einav
  • 553
  • 9
  • 27
0
votes
1 answer

Multiple Join syntax in SQLike

I'm trying to construct a two level JOIN in SQLike, and can't get past the stage of a one level JOIN. The JSONs I use as source tables are: var placesJSON=[{"id":"173","name":"England","type":"SUBCTRY"},{"id":"580","name":"Great…
einav
  • 553
  • 9
  • 27
0
votes
2 answers

Combine to Fields in one Qlik Sense Filter

I have 2 Fields and I need to combine them in one field. Is it possible to get this result in Qlik Sense? I do not want concatenate but get the result in table
Rachel F
  • 1
0
votes
3 answers

SQLike query on JSON returning 3996 objects

I am trying to query a JSON object in order to determine a username. However, when I run the SQLike i have 3996 objects returned, none of which matching the correct parameters that I have asked to be returned. Would anyone be able to point out where…
Sam Street
  • 306
  • 2
  • 14