Necesito ordenar mis datos por fecha y eventos, pero estoy luchando para que funcione usando la consulta AlaSQL en objetos de fecha:
function testOrderBy() { var data = [{event:'A', date: new Date('2021-04-21')}, {event:'B', date: new Date('2021-04-21')}, {event:'C', date: new Date('2021-04-21')}, {event:'D', date: new Date('2021-04-20')}]; console.log(data); var res = alasql(`SELECT event, date FROM ? ORDER BY date, event`, [data]); console.log(res); }Y el resultado obtenido es:
[ { event: 'D', date: Tue Apr 20 2021 02:00:00 GMT+0200 (Central European Summer Time) }, { event: 'C', date: Wed Apr 21 2021 02:00:00 GMT+0200 (Central European Summer Time) }, { event: 'B', date: Wed Apr 21 2021 02:00:00 GMT+0200 (Central European Summer Time) }, { event: 'A', date: Wed Apr 21 2021 02:00:00 GMT+0200 (Central European Summer Time) } ]Yo estaba esperando:
[ { event: 'D', date: Tue Apr 20 2021 02:00:00 GMT+0200 (Central European Summer Time) }, { event: 'A', date: Wed Apr 21 2021 02:00:00 GMT+0200 (Central European Summer Time) }, { event: 'B', date: Wed Apr 21 2021 02:00:00 GMT+0200 (Central European Summer Time) }, { event: 'C', date: Wed Apr 21 2021 02:00:00 GMT+0200 (Central European Summer Time) } ]El problema no ocurre si las fechas no son objetos de fecha sino cadenas ISO:
function testOrderBy() { var data = [{event:'A', date: '2021-04-21'}, {event:'B', date: '2021-04-21'}, {event:'C', date: '2021-04-21'}, {event:'D', date: '2021-04-20'}]; console.log(data); var res = alasql(`SELECT event, date FROM ? ORDER BY date, event`, [data]); console.log(res); } El resultado es el esperado D, A, B, C
Alguna idea ?
Es necesario crear el esquema de la tabla para considerar correctamente la columna como de tipo Fecha, de la siguiente manera:
alasql("CREATE TABLE events (event string, date date)"); alasql.tables.events.data = [{event:'A', date: new Date('2021-04-21')}, {event:'B', date: new Date('2021-04-21')}, {event:'C', date: new Date('2021-04-21')}, {event:'D', date: new Date('2021-04-20')}]; alasql(`SELECT event, date INTO HTML("#res") FROM events ORDER BY date, event`); <script src="https://cdn.jsdelivr.net/npm/alasql@1.7.3/dist/alasql.min.js"></script> <div id="res"> </div>