Wiki code for Watershed Bibliography

Hide Line numbers
1: 1 Watershed Bibliography
2: 
3: #set($selectedarea = $request.getParameter("area"))
4: #set($selectedsubject = $request.getParameter("subject"))
5: #set($areaids = $xwiki.DBPlugin.getArrayListFromQuery("Bibliography","SELECT distinct(StudyAreaID) FROM studyarealist ORDER By StudyAreaID"))
6: #set($sids = $xwiki.DBPlugin.getArrayListFromQuery("Bibliography","SELECT distinct(SubjectID) FROM subjectlist Order By SubjectID"))
7: 
8:  <form action="" method="get">
9:    <input type="hidden" name="search" value="1">
10:    <table>
11:      <tr>
12:        <td align="right">
13:           Area: 
14:        </td>
15:        <td>
16:          <select name="area" size="1">
17:            #foreach ($id in $areaids)
18:            <option value="$id"
19:            #if ($selectedarea == $id)
20:               selected
21:            #end
22: >
23:               $xwiki.DBPlugin.getStringValue("Bibliography","Select StudyArea From studyarea Where StudyAreaID = $id") 
24:            </option>
25:            #end
26:          </select>
27:        </td>
28:      </tr>
29:      <tr>
30:       <td align="right">
31:           Subject: 
32:        </td>
33:        <td>
34:          <select name="subject" size="1">
35:            #foreach ($id in $sids)
36:            <option value="$id"
37:            #if ($selectedsubject == $id)
38:               selected
39:            #end
40: >
41:              $xwiki.DBPlugin.getStringValue("Bibliography","Select Subject From subject Where SubjectID = $id") 
42:            </option>
43:            #end
44:          </select>
45:        </td>
46:      </tr>
47:      <tr>
48:       <td colspan="2" align="center">
49:          <input type="submit" value="Search" />
50:       </td>
51:      </tr>
52:     </table>
53:  </form>
54: 
55: #if( $request.getParameter("search") )
56:   #tableFromDB("Bibliography", "
57: SELECT 
58: 	R.ReferenceTitle As Title, 
59: 	R.Summary
60: FROM 
61: 	referenceauthors R, 
62: 	studyarea A, 
63: 	subject S 
64: WHERE 
65:    A.StudyAreaID = $selectedarea
66:    And A.StudyAreaID IN (SELECT StudyAreaID FROM studyarealist WHERE ReferenceTitleID = R.ReferenceTitleID)
67:    And S.SubjectID = $selectedsubject
68:    And S.SubjectID IN (SELECT SubjectID FROM subjectlist WHERE ReferenceTitleID = R.ReferenceTitleID) 
69: ORDER BY
70:    PublishedYear Desc;")
71: #end
Watershed Bibliography

Top Menu

Wiki code for Watershed Bibliography

Search

Quick Links
