onto.Birthdate

Definition

Some date attributes may refer to dates of birth and, by tagging them with extends: onto.Birthdate, you will be able to ask questions related to age and birthday.

Examples

"Show me our oldest customer"
"Average age of customers in each country"
"Show me all employees with birthday next week"
"Which customers were born before 1970?"

Usage

For this to work, you will have to add an extends: onto.Birthdate. Like this:

kb {
    class Customer {
        name.en: "Customer"
        
        from_table: customer
        sql: "${customer.id}"
        name_sql.en: "${customer.full_name}"
        
        
        date Birthdate {
            name.en: "Birthdate"

            sql: "${customer.birthdate}"

            datetime_format: DayFormat

            // Add this to enable questions involving age and birthday
            extends: onto.Birthdate
        }

        ...
    }
}