Differences

This shows you the differences between two versions of the page.

--- groups:mxp:projectdb [2022/12/20 15:04] – cse-sull0153
+++ groups:mxp:projectdb [2023/08/01 15:35] (current) – cse-sull0153
@@ Line 1: / Line 1: @@
 ====== MXP Project Database ======
-The database contains summaries of over 500 MXP projects going back to 1970. Data from Kurt's long-standing database was imported to MySQL running on a department server, and is accessed here using the Database2 DokuWiki plugin. Thanks to Alex Schumann for setting this up for us.
+The database contains summaries of over 500 MXP projects going back to 1970. Data from Kurt's long-standing database was imported to MySQL running on a department server, and is accessed here using the [[https://www.dokuwiki.org/plugin:dbquery|DokuWiki dbquery Plugin]].
-Search to narrow the results. Click the "Examine Record" button at right to show the complete record including the report location, and if invented at the time ;-), URL for the experiment webpage. When viewing the URL, __Right-click the link and use Open in New Tab__, since navigation back to the wiki can be annoying. Use the "OK" button at bottom of page to return from wiki record view to wiki list view.
-[[https://zzz.physics.umn.edu/groups/mxp/projectdb|Return to MXP Database ]]
-<database2 mxp auth=physuser-mxp database=@mysql:host=cse-moe.cse.umn.edu;dbname=mxp maydrop=!@ALL mayadmin=@admin,manager mayedit=@admin,manager,wick mayinsert=@webgrp_mxp maydelete=@webgrp_mxp,@admin,manager mayfilter=@ALL mayexport=@ALL mayprint=@ALL mayviewlog=@ALL sort=!ProjDate>
+{{QUERY:projectdb}}
-<!--database2 mxp auth=csemxp database=@mysql:host=mysql-prod5.oit.umn.edu;dbname=cse_mxp maydrop=!@ALL mayadmin=@admin,manager mayedit=@admin,manager,wick mayinsert=@webgrp_mxp maydelete=@webgrp_mxp,@admin,manager mayfilter=@ALL mayexport=@ALL mayprint=@ALL mayviewlog=@ALL sort=!ProjDate-->
-IDPrimKey, integer, id, primary readonly
+~~NOCACHE~~
-ProjDate, date, Date, visible alwaysshow
-MXPCodeDescription, text, Category, required length=40 visible
-ProjName, text, Project Name, length=256 visible alwaysshow
-ProjDescription, text, Project Description, visible alwaysshow
-Students, text, Students, length=150 visible alwaysshow
-Student1, text, Student1, length=40
-Student2, text, Student2, length=40
-Student3, text, Student3, length=40
-RefMXP, text, Reference, length=5 visible alwaysshow
-ProjEqBuilt, text, ProjEqBuilt, length=256
-RepLocation, text, RepLocation, length=50 alwaysshow
-RefAIP, text, RefAIP, length=50
-ProjURL, URL, ProjURL, length=256 alwaysshow
-Notes, text, Notes, length=100 alwaysshow
-</database2>

User Tools

Differences

Page Tools