<html xmlns:v="urn:schemas-microsoft-com:vml" xmlns:o="urn:schemas-microsoft-com:office:office" xmlns:w="urn:schemas-microsoft-com:office:word" xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type content="text/html; charset=utf-8"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><!--[if !mso]><style>v\:* {behavior:url(#default#VML);}
o\:* {behavior:url(#default#VML);}
w\:* {behavior:url(#default#VML);}
.shape {behavior:url(#default#VML);}
</style><![endif]--><style><!--
/* Font Definitions */
@font-face
{font-family:Helvetica;
panose-1:2 11 6 4 2 2 2 2 2 4;}
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:"MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@font-face
{font-family:Consolas;
panose-1:2 11 6 9 2 2 4 3 2 4;}
@font-face
{font-family:Verdana;
panose-1:2 11 6 4 3 5 4 4 2 4;}
@font-face
{font-family:"\@MS Gothic";
panose-1:2 11 6 9 7 2 5 8 2 4;}
@font-face
{font-family:HelveticaNeue-Light;
panose-1:0 0 0 0 0 0 0 0 0 0;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0cm;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p
{mso-style-priority:99;
margin:0cm;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0cm;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0cm;
margin-right:0cm;
margin-bottom:0cm;
margin-left:36.0pt;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle19
{mso-style-type:personal;
font-family:"Georgia","serif";
color:#003366;
mso-ligatures:standardcontextual;
mso-number-form:lining;
mso-number-spacing:tabular;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:Consolas;}
span.EmailStyle22
{mso-style-type:personal-reply;
font-family:"Georgia","serif";
color:#003366;
mso-ligatures:standardcontextual;
mso-number-form:lining;
mso-number-spacing:tabular;}
.MsoChpDefault
{mso-style-type:export-only;
font-size:10.0pt;}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div class=WordSection1><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>I did try that, and it didn’t make a difference; by inspecting the menu object directly I could see that it defaulted that way anyway.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'><o:p> </o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>The problem here seems to be some inherent complication resulting from a menu with two multiple fields, generating the wrong ‘distinctby’ query.<o:p></o:p></span></p><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> <o:p></o:p></span></p><div><p class=MsoNormal><span lang=EN-AU style='font-size:6.0pt;font-family:"Verdana","sans-serif";color:#003366'>-- <o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>Matthew</span></b><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'> <b>Kerwin</b></span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#F4F4F4'> </span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>| QUT Library eServices</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'> | <u><a href="mailto:matthew.kerwin@qut.edu.au"><u><span style='color:#7A7A7A'>matthew.kerwin@qut.edu.au</span></u></a></u></span><span lang=EN-AU style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7A7A7A'><o:p></o:p></span></p></div><p class=MsoNormal><span style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'><o:p> </o:p></span></p><div><div style='border:none;border-top:solid #B5C4DF 1.0pt;padding:3.0pt 0cm 0cm 0cm'><p class=MsoNormal><b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'>From:</span></b><span style='font-size:10.0pt;font-family:"Tahoma","sans-serif"'> eprints-tech-bounces@ecs.soton.ac.uk [mailto:eprints-tech-bounces@ecs.soton.ac.uk] <b>On Behalf Of </b>Gilles Fournié<br><b>Sent:</b> Monday, 22 December 2014 18:24<br><b>To:</b> eprints-tech@ecs.soton.ac.uk<br><b>Subject:</b> [EP-tech] Re: problem with DB query for view<o:p></o:p></span></p></div></div><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Sorry.. <br>I have not been clear. <br><br>The wiki shows allow_null under "menus ".<br>Yours is outside.<br>I don't know if it could make a difference or not...<br><br>Regards <o:p></o:p></span></p><div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'>Le 22 décembre 2014 08:47:48 UTC+01:00, Gilles FOURNIE <<a href="mailto:gilles.fournie@cirad.fr">gilles.fournie@cirad.fr</a>> a écrit :<o:p></o:p></span></p><div><p class=MsoNormal style='margin-bottom:12.0pt'><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:black'>HI,<br><br>Did you try adding "allow_null => 0" to your view ?<br><br>I'm not sure which is the default value :<br><a href="http://wiki.eprints.org/w/Views.pl#Menu_options">http://wiki.eprints.org/w/Views.pl#Menu_options</a><br><br>Regards,<br>GF<br><br><o:p></o:p></span></p><div class=MsoNormal align=center style='text-align:center'><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:black'><hr size=2 width="100%" align=center id=zwchr></span></div><blockquote style='border:none;border-left:solid #1010FF 1.5pt;padding:0cm 0cm 0cm 4.0pt;margin-left:3.75pt;margin-top:5.0pt;margin-bottom:5.0pt'><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>Hi folks,</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>We have two multiple compound fields: “creators” and “editors”, with subfields:</span><span style='color:black'><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt'><span lang=EN-AU style='font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>·</span><span lang=EN-AU style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>name (type=name)</span><span style='color:black'><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt'><span lang=EN-AU style='font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>·</span><span lang=EN-AU style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>id (type=text)</span><span style='color:black'><o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt'><span lang=EN-AU style='font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>·</span><span lang=EN-AU style='font-size:7.0pt;font-family:"Times New Roman","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>… etc.</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>The ids are sparsely assigned (used to identify contributors associated with our institution.)</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>We also have a view “person”, with a single menu:</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> allow_null => 0,<br> menus => [{</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> fields => [ "creators_id", "editors_id" ],</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> new_column_at => [1, 1],</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> mode => "sections",</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> open_first_section => 1,</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> group_range_function => "EPrints::Update::Views::cluster_ranges_30",</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> grouping_function => "EPrints::Update::Views::group_by_a_to_z",</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:9.0pt;color:black'> }],</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>The problem is that, since upgrading from 3.2 to 3.3, the view includes a subset of those creators/editors who don’t have an id.</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>I tracked through the code and found that it’s generating the correct UNION statement (effectively: </span><span lang=EN-AU style='font-size:10.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>select from eprint_creators_id where creators_id!='' UNION select from eprint_editors_id where editors_id!=''</span><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>), however for each field it’s then wrapping the union in a distinctby (</span><span lang=EN-AU style='font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>select creators_id from (UNION); select editors_id from (UNION)</span><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>). Of course, the union returns everything with either a creators_id or an editors_id, so both of those distinctby queries includes some null ids. Thus, the first section in the view menu is “?” with a link to the user “NULL.html” who has several thousand EPrints.</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>This is a bug, but I’m not quite sure how to turn it into a bug report on github. In the meantime, has anybody else come across this sort of issue? Are there any known fixes or workarounds? I have a potential hack ready to get us by, but I’d prefer something a bit less klugey.</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>Cheers</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='font-size:6.0pt;font-family:"Verdana","sans-serif";color:#003366'>-- </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal style='text-autospace:none'><b><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>Matthew</span></b><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'> <b>Kerwin</b> | Senior Web Developer |</span><span lang=EN-AU style='font-size:10.0pt;font-family:"MS Gothic";color:#F4F4F4'> </span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'><a href="https://wiki.qut.edu.au/display/lib/Digital+Repository+Team" target="_blank" title="Digital Repository Team"><span style='color:#7A7A7A;text-decoration:none'>Applications & Development Team</span></a> | Library eServices | Queensland University of Technology | Level 3, R Block, Kelvin Grove | <u><a href="mailto:matthew.kerwin@qut.edu.au" target="_blank"><span style='color:#7A7A7A'>matthew.kerwin@qut.edu.au</span></a></u> | </span><span lang=EN-AU style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>CRICOS No 00213J</span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU style='color:black'> </span><span style='color:black'><o:p></o:p></span></p><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Helvetica","sans-serif";color:black'><br>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>*** Archive: <a href="http://www.eprints.org/tech.php/">http://www.eprints.org/tech.php/</a><br>*** EPrints community wiki: <a href="http://wiki.eprints.org/">http://wiki.eprints.org/</a><br>*** EPrints developers Forum: <a href="http://forum.eprints.org/">http://forum.eprints.org/</a><o:p></o:p></span></p></blockquote><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Arial","sans-serif";color:black'><o:p> </o:p></span></p></div><pre>*** Options: <a href="http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech">http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech</a><br>*** Archive: <a href="http://www.eprints.org/tech.php">http://www.eprints.org/tech.php</a>/<br>*** EPrints community wiki: <a href="http://wiki.eprints.org">http://wiki.eprints.org</a>/<br>*** EPrints developers Forum: <a href="http://forum.eprints.org">http://forum.eprints.org</a>/<o:p></o:p></pre></div><p class=MsoNormal><span style='font-size:12.0pt;font-family:"Times New Roman","serif"'><br>-- <br>Envoyé de mon téléphone Android avec K-9 Mail. Excusez la brièveté.<o:p></o:p></span></p></div></body></html>