.title "Copy Search (Extended)"
.category "Cataloging"
.layout labels title="Labels"
.column copyid hidden
.column bibid hidden
.column barcode_nmbr title="Barcode" sort=barcode_nmbr
.column callno title="Call Num." sort=callno
.column author title=Author sort=author
.column title func=biblio_link title=Title sort=title
.column collection
.column status_begin_dt title="Status Begin Date" sort=status_begin_dt
.parameters
.	string barcode title="Barcode Starts With"
.	date newer title="Newer than"
.	select status default=any title="Status"
.		item any title=Any
.		sql
			SELECT code AS value, description AS title FROM biblio_status_dm
.		end sql
.	end select
.	date status_begin_dt title="Status Date since"
.	string calln1 title="Call Num. 1 Starts With"
.	string calln2 title="Call Num. 2 Starts With"
.	string calln3 title="Call Num. 3 Starts With"
.	order_by default=callno
.		item barcode_nmbr title="Barcode"
.		item callno title="Call Number, Author, Title" expr="concat(b.call_nmbr1, b.call_nmbr2, b.call_nmbr3, b.author, b.title)"
.		item author title="Author"
.		item title title="Title"
.		item status_begin_dt title="Status Begin Date"
.	end order_by
.end parameters

.sql
	select c.*, concat_ws(' ', b.call_nmbr1, b.call_nmbr2, b.call_nmbr3) callno,
		b.title, b.author, coll.description collection
	from biblio_copy c, biblio b, collection_dm coll
	where b.bibid=c.bibid and coll.code=b.collection_cd
.	if_set barcode
		and c.barcode_nmbr like '%"barcode%%%'
.	end if_set
.	if_set newer
		and c.create_dt >= %newer%
.	end if_set
.	if_set status
.		if_not_equal status any
			and c.status_cd = %status%
.		end if_set
.	end if_set
.	if_set status_begin_dt
		and c.status_begin_dt >= %status_begin_dt%
.	end if_set
.	if_set calln1
		and b.call_nmbr1 like '%"calln1%%%'
.	end if_set
.	if_set calln2
		and b.call_nmbr2 like '%"calln2%%%'
.	end if_set
.	if_set calln3
		and b.call_nmbr3 like '%"calln3%%%'
.	end if_set
.	order_by_expr
.end sql