LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/LODoc/Example_Sport.odb
File actual save date2018-08-07 13:02:22
Scanning done on2018-08-21 17:42:21
Documentation generated on2018-08-21 17:42:31
Table of contents
Example_Sport
List of queries
Query name Used by Query type List of fields SQL
count_agegroup_gender   SELECT Details 
SELECT 
	CASEWHEN(
		(
			YEAR(
				NOW()) - YEAR("birthday")) > 19, 
		CEILING(
			(
				YEAR(
					NOW()) - YEAR("birthday")) / 10) * 10, 
		(
			YEAR(
				NOW()) - YEAR("birthday")) - MOD(
			(
				YEAR(
					NOW()) - YEAR("birthday")), 
			2)) "age_group", 
	COUNT("ID") "quantity", 
	"gender" 
FROM 
	"starter" 
GROUP BY 
	"age_group", 
	"gender" 
ORDER BY 
	"age_group"
count_agegroup_gender_new   SELECT Details 
SELECT 
	CASEWHEN(
		(
			YEAR(
				NOW()) - YEAR("birthday")) > 19, 
		LEFT(
			"gender" || ' ' || CEILING(
				(
					YEAR(
						NOW()) - YEAR("birthday")) / 10) * 10, 
			4), 
		"gender" || ' ' || (
			YEAR(
				NOW()) - YEAR("birthday")) - MOD(
			(
				YEAR(
					NOW()) - YEAR("birthday")), 
			2)) "age_group", 
	COUNT("ID") "quantity", 
	"gender", 
	CASEWHEN(
		(
			YEAR(
				NOW()) - YEAR("birthday")) > 19, 
		CEILING(
			(
				YEAR(
					NOW()) - YEAR("birthday")) / 10) * 10, 
		(
			YEAR(
				NOW()) - YEAR("birthday")) - MOD(
			(
				YEAR(
					NOW()) - YEAR("birthday")), 
			2)) "age_group_sort" 
FROM 
	"starter" 
GROUP BY 
	"age_group", 
	"gender", 
	"age_group_sort" 
ORDER BY 
	"gender", 
	"age_group_sort"
registration   SELECT Details 
SELECT 
	"sportage".*, 
	CASEWHEN(
		"sportage" > 19, 
		CEILING("sportage" / 10) * 10, 
		"sportage" - MOD("sportage", 2)) "age_group" 
FROM 
	"sportage"
report_gender   SELECT Details 
SELECT 
	"gender", 
	CASE WHEN "gender" = 'f' THEN 'female' ELSE 'male' END "gender_full", 
	COUNT("ID") "quantity" 
FROM 
	"starter" 
GROUP BY 
	"gender", 
	"gender_full"
sportage registration (Query)
sportage (Query)		 SELECT Details 
SELECT 
	"starter"."forename", 
	"starter"."surname", 
	"starter"."birthday", 
	"starter"."gender", 
	"sport"."sport", 
	YEAR(
		NOW()) - YEAR("birthday") "sportage" 
FROM 
	"rel_starter_sport", 
	"starter", 
	"sport" 
WHERE 
	"rel_starter_sport"."ID_starter" = "starter"."ID" 
	AND "rel_starter_sport"."ID_sport" = "sport"."ID"