Table of contents
Example_Search_and_Filter

• Tables
  • filter
  • listbox_1_view
  • listbox_2_view
  • searchtable
  • searchtmp
• Queries
  • columns_searchtable
  • filterquery
  • listbox_1
  • listbox_1_filterquery
  • listbox_1_simple
  • listbox_2
  • listbox_2_filterquery
  • listbox_2_simple
  • searchquery
• Forms
  • filter_with_macros_1
  • filter_with_macros_2
  • filter_without_macros
  • hierarchical_macrofilter
  • searchquery
  • searchtable
  • searchtable_hierarchical_macrofilter_form_directly_filtered
  • searchtable_macrofilter_form_directly_filtered
• Modules
  • Module1
• Index

List of fields by query

Query name	Field name	Field type	Source table	Source field
columns_searchtable	COLUMN_NAME	VARCHAR	SYSTEM_COLUMNS	COLUMN_NAME
	COLUMN_SIZE	INTEGER	SYSTEM_COLUMNS	COLUMN_SIZE
	Default Value	VARCHAR	SYSTEM_COLUMNS	Default Value
	TYPE_NAME	VARCHAR	SYSTEM_COLUMNS	TYPE_NAME
filterquery	Art			IFNULL( "Art", 0 )
	Autor	VARCHAR	searchtable (Table)	Autor
	ISBN	VARCHAR	searchtable (Table)	ISBN
	Jahr	NUMERIC	searchtable (Table)	Jahr
	Kuerz.	VARCHAR	searchtable (Table)	Kuerz.
	Nr.	INTEGER	searchtable (Table)	Nr.
	Schlagworte	VARCHAR	searchtable (Table)	Schlagworte
	Sys.			IFNULL( "Sys.", 0 )
	Titel	VARCHAR	searchtable (Table)	Titel
	Verw.	VARCHAR	searchtable (Table)	Verw.
	Zunummer	VARCHAR	searchtable (Table)	Zunummer
listbox_1	IFNULL( "Sys." || ' - ' || "quantity", 'empty - ' || "quantity" )			IFNULL( "Sys." || ' - ' || "quantity", 'empty - ' || "quantity" )
	Sys.	VARCHAR	listbox_1_view (Table)	Sys.
listbox_1_filterquery	display	VARCHAR		display
	Sys.	LONGVARCHAR	SYSTEM_SUBQUERY	Sys.
listbox_1_simple	Sys.	VARCHAR	searchtable (Table)	Sys.
	Sys.1	VARCHAR	searchtable (Table)	Sys.
listbox_2	Art	VARCHAR	listbox_2_view (Table)	Art
	IFNULL( "Art" || ' - ' || "quantity", 'empty - ' || "quantity" )			IFNULL( "Art" || ' - ' || "quantity", 'empty - ' || "quantity" )
listbox_2_filterquery	Art	LONGVARCHAR	SYSTEM_SUBQUERY	Art
	display	VARCHAR		display
listbox_2_simple	Art	VARCHAR	searchtable (Table)	Art
	Art1	VARCHAR	searchtable (Table)	Art
searchquery	Art	VARCHAR	searchtable (Table)	Art
	Autor	VARCHAR	searchtable (Table)	Autor
	Datum	DATE	searchtable (Table)	Datum
	ISBN	VARCHAR	searchtable (Table)	ISBN
	Jahr	NUMERIC	searchtable (Table)	Jahr
	Kuerz.	VARCHAR	searchtable (Table)	Kuerz.
	Nr.	INTEGER	searchtable (Table)	Nr.
	Schlagworte	VARCHAR	searchtable (Table)	Schlagworte
	Sys.	VARCHAR	searchtable (Table)	Sys.
	Titel	VARCHAR	searchtable (Table)	Titel
	Verw.	VARCHAR	searchtable (Table)	Verw.
	Zunummer	VARCHAR	searchtable (Table)	Zunummer