Link Search Menu Expand Document

To help with debugging you can access the raw output of a query, you will need to create the entire SELECT query for this to work, the raw array is sent to the development console. Use Ctrl+Shift+I to open the console and look at the console log for the query output.

Query with the Tasks in your Vault to query against

This example runs the SQL query with the tasks from this Vault.

```task-sql
SELECT *, moment()->startOf('day') AS MomentDate, dueDate->getDate() AS DateDay
FROM ?
WHERE status->indicator = ' ' AND  moment()->format('YYYY-MM-DD') = moment(dueDate)->format('YYYY-MM-DD')
LIMIT 1
#raw tasks
```
SELECT *, moment()->startOf('day') AS MomentDate, dueDate->getDate() AS DateDay
FROM ?
WHERE status->indicator = ' ' AND  moment()->format('YYYY-MM-DD') = moment(dueDate)->format('YYYY-MM-DD')
LIMIT 1
#raw tasks

Query with no data to query against

This example runs the SQL query as is with no data passed in so the entire SQL query has to return some information.

```task-sql
SELECT moment() AS Moment, Date() AS JSDate, 'Some String' AS AString, 42 AS ANumber, 'Another String'->length AS ALength
#raw empty
```
SELECT moment() AS Moment, Date() AS JSDate, 'Some String' AS AString, 42 AS ANumber, 'Another String'->length AS ALength
#raw empty
```task-sql
SELECT *
FROM tasks
WHERE status->indicator = ' ' AND  moment()->format('YYYY-MM-DD') = moment(dueDate)->format('YYYY-MM-DD')
LIMIT 1
#raw tasks
```
SELECT *
FROM tasks
WHERE tags->includes('#Chores')
LIMIT 10
#raw tasks
SELECT * FROM pagedata; SHOW TABLES FROM alasql
#SELECT *, queryId(), queryBlockFile() FROM tasks LIMIT 10
#SELECT queryId()  
#raw empty