JavaScript required
We’re sorry, but Coda doesn’t work properly without JavaScript enabled.
Skip to content
Gallery
My Makerspace
About me
Blog
More
Share
Explore
Blog
SQLChat
AS
alonso suarez
May 19, 2019
Training Phrases
Parameters
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 (
Ctrl
P
) instead.