...
Used in DocList.java to populate temp tables for searching.
docsubjects_view
Used in DocList.java to populate temp tables for searching.
filmgenres
Used in FilmSearchArgs.java
doc_detail_summary (function)
Returns multiple result sets used for document citation. Called by DocDetail.java.
Execution (for doc_id=12):
| Code Block |
|---|
begin;
select cinefiles_denorm.doc_detail_summary('12', 'document', 'doctitle', 'authors', 'source', 'doctype', 'lang', 'docsubj', 'docnamesubj', 'docfilmsubj', 'docurl');
fetch all in "document";
fetch all in "doctitle";
fetch all in "authors";
fetch all in "source";
fetch all in "doctype";
fetch all in "lang";
fetch all in "docsubj";
fetch all in "docnamesubj";
fetch all in "docfilmsubj";
fetch all in "docurl";
commit;
|
Returns:
| Code Block |
|---|
...
|
film_detail_summary (function)
Returns multiple results sets for film citation. Called by FilmDetail.java
Execution (for film_id='pfafilm3):
| Code Block |
|---|
begin;
select cinefiles_denorm.film_detail_summary('pfafilm3','title', 'director', 'country', 'filmyear', 'lang', 'prodco', 'genre', 'subject', 'reldocs');
fetch all in "title";
fetch all in "director";
fetch all in "country";
fetch all in "filmyear";
fetch all in "lang";
fetch all in "prodco";
fetch all in "genre";
fetch all in "subject";
fetch all in "reldocs";
commit;
|
Returns:
| Code Block |
|---|
...
|