new_downloadable_book_view (view)
1,781 rows
This data as json, CSV (advanced)
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW new_downloadable_book_view AS select
json_object(
-- 'img_src', 'https://covers.openlibrary.org/b/isbn/0899080871-L.jpg',
'img_src', 'https://covers.openlibrary.org/b/isbn/' || json_extract(bib.isbn_values, '$[0]') || '-L.jpg',
'href', 'https://cincinnatilibrary.bibliocommons.com/v2/record/S170C' || bib.bib_record_num
) as jacket,
json_object(
--'img_src', 'https://placekitten.com/200/300',
'href',
'https://cincinnatilibrary.bibliocommons.com/v2/record/S170C' || bib.bib_record_num,
'label',
item_view.best_title || coalesce(vol_statement, ''),
'title',
item_view.best_title || coalesce('
' || item_view.best_author, ''),
'description',
item_view.best_author || '
' || item_view.publish_year || coalesce ('
' || item_view.item_callnumber, '')
) as catalog_link,
creation_date as "date added" -- item_format
from
item_view
join bib on bib.bib_record_num = item_view.bib_record_num
where
item_view.creation_date >= date('now', 'weekday 1', '-7 days', '-60 days')
-- item_view.creation_date >= :create_date_start
and item_view.item_format = 'Downloadable Book'
order by
"date added" desc,
coalesce(item_view.best_author, 'Zzzz') ASC,
item_view.best_title;