Skip to content
My Makerspace
Share
Explore
Blog

SQLChat

May 19, 2019


Training Phrases
image.png
Parameters
image.png
Demos
User: can you tell me the employees that have a birthday in January
Fulfilment:
{
Table: "employees",
Filters: [
{
Filter: {
"month": "January",
"Comparator": "equal to"
}
}
]
}
User: search for employees first name and last name born between January and March
Fulfilment:
{
"Filters": [
{
"Filter": {
"date-period": {
"endDate": "2020-03-31T23:59:59-07:00",
"startDate": "2020-01-01T00:00:00-08:00"
}
},
"Field": "employees-birth_date"
}
],
"Fields": [
{
"field": "employees-first_name"
},
{
"field": "employees-last_name"
}
]
}

Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.