LibreOffice logo
BASEDOCUMENTER
The software tool for documenting your LibreOffice Base applications
 
Database file/home/jean-pierre/Documents/BaseDocumenter/www/databases/LODoc/Example_Search_and_Filter.odb
File actual save date2018-06-27 13:59:23
Scanning done on2018-08-21 17:39:10
Documentation generated on2018-08-21 17:39:20
Table of contents
Example_Search_and_Filter
List of tables
Table name Used by List of fields Number of records Table data (sample) SQL
filter listbox_1_view (Table)
listbox_2_view (Table)
filterquery (Query)
filter_with_macros_1 (Form)
filter_with_macros_2 (Form)
filter_without_macros (Form)
Filter (Procedure)
Filter_Additional_Info (Procedure)		 Details 1 Data  
listbox_1_view listbox_1 (Query) Details 55 Data 
SELECT 
	COUNT("Nr.") "quantity", 
	"Sys." 
FROM 
	"searchtable" 
WHERE 
	"Nr." IN (
		SELECT 
			"searchtable"."Nr." 
		FROM 
			"filter", 
			"searchtable" 
		WHERE 
			"searchtable"."Art" = IFNULL(
				"filter"."filter_2", "searchtable"."Art"
			)) 
GROUP BY 
	"Sys." 
ORDER BY 
	"Sys." ASC
listbox_2_view listbox_2 (Query) Details 12 Data 
SELECT 
	COUNT("Nr.") "quantity", 
	"Art" 
FROM 
	"searchtable" 
WHERE 
	"Nr." IN (
		SELECT 
			"searchtable"."Nr." 
		FROM 
			"filter", 
			"searchtable" 
		WHERE 
			"searchtable"."Sys." = IFNULL(
				"filter"."filter_1", "searchtable"."Sys."
			)) 
GROUP BY 
	"Art" 
ORDER BY 
	"Art" ASC
searchtable listbox_1_view (Table)
listbox_2_view (Table)
filterquery (Query)
listbox_1_simple (Query)
listbox_2_simple (Query)
searchquery (Query)
hierarchical_macrofilter (Form)
hierarchical_macrofilter|listbox1 (Control)
searchtable (Form)
searchtable_hierarchical_macrofilter_form_directly_filtered (Form)
searchtable_hierarchical_macrofilter_form_directly_filtered|listbox1 (Control)
searchtable_macrofilter_form_directly_filtered (Form)
searchtable_macrofilter_form_directly_filtered|listbox1 (Control)
searchstart (Procedure)		 Details 8187 Data  
searchtmp searchquery (Query) Details 12 Data