How to set the alasql output as Array

Question

I need to set the alasql output as Array. Is it possible?

I don't find any method for this

var pre = document.getElementById('pre');
var keys = Object.keys(alasql).map(function(e) {
  return [e];
});
var qLikes = alasql('SELECT * FROM ? WHERE [0] LIKE "%uery%"', [keys]);
pre.innerHTML = JSON.stringify(qLikes, null, ' ');
var pre = document.getElementById('pre');

<script src="https://cdn.rawgit.com/agershun/alasql/develop/dist/alasql.min.js"></script>
<pre id="pre"></pre>

score 6 · Accepted Answer · edited Apr 29 '16 at 19:50

6

With AlaSQL you can prepend COLUMN OF to your SQL to get out an array of values representing the first column in your dataset.

var qLikes = alasql('COLUMN OF SELECT * FROM ? WHERE [0] LIKE "%uery%"', [keys]);

Example

var pre = document.getElementById('pre');
var keys = Object.keys(alasql).map(function(e) {
  return [e];
});
var qLikes = alasql('COLUMN OF SELECT * FROM ? WHERE [0] LIKE "%uery%"', [keys]);
pre.innerHTML = JSON.stringify(qLikes, null, ' ');
var pre = document.getElementById('pre');

<script src="https://cdn.rawgit.com/agershun/alasql/develop/dist/alasql.min.js"></script>
<pre id="pre"></pre>

edited Apr 29 '16 at 19:50

contributorpw

4,739
5
27
50

answered Apr 29 '16 at 17:45

mathiasrw

610
4
10

it's that what I want. I can't understand why have I not thought of this? Thank you! – contributorpw Apr 29 '16 at 19:35
The [MATRIX modifier](https://github.com/agershun/alasql/wiki/MATRIX) is also fine. – contributorpw Feb 27 '17 at 17:46

How to set the alasql output as Array

1 Answers1