

def definition():
    """UI view of dates"""
    sql = """
    SELECT d.set_cat_id, d.acad_year, d.dt, s.description + ' ' + c.description + ISNULL(' - ' + d.description,'') as description, 
	c.important
	FROM conf_dt as d
	INNER JOIN conf_dt_cat AS c on c.dt_cat_id = d.dt_cat_id
	INNER JOIN f_set_cat AS s ON s.set_cat_id = d.set_cat_id """
    return sql



def definition():
    """UI view of dates"""
    sql = """
    SELECT d.set_cat_id, d.acad_year, d.dt, s.description + ' ' + c.description + ISNULL(' - ' + d.description,'') as description, 
	c.important
	FROM conf_dt as d
	INNER JOIN conf_dt_cat AS c on c.dt_cat_id = d.dt_cat_id
	INNER JOIN f_set_cat AS s ON s.set_cat_id = d.set_cat_id """
    return sql

UI view of dates SELECT d.set_cat_id, d.acad_year, d.dt, s.description + ' ' + c.description + ISNULL(' - ' + d.description,'') as description,  	c.important 	FROM conf_dt as d 	INNER JOIN conf_dt_cat AS c on c.dt_cat_id = d.dt_cat_id 	INNER JOIN f_set_cat AS s ON s.set_cat_id = d.set_cat_id