<html><head><style type='text/css'>p { margin: 0; }</style></head><body><div style='font-family: arial,helvetica,sans-serif; font-size: 12pt; color: #000000'>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>http://wiki.eprints.org/w/Views.pl#Menu_options<br><br>Regards,<br>GF<br><br><br><hr id="zwchr"><blockquote style="border-left:2px solid #1010FF;margin-left:5px;padding-left:5px;color:#000;font-weight:normal;font-style:normal;text-decoration:none;font-family:Helvetica,Arial,sans-serif;font-size:12pt;"><style><!--
@font-face
{font-family:Wingdings;
panose-1:5 0 0 0 0 0 0 0 0 0;}
@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:Georgia;
panose-1:2 4 5 2 5 4 5 2 3 3;}
@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;}
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.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.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Georgia","serif";
color:#003366;
mso-ligatures:standardcontextual;
mso-number-form:lining;
mso-number-spacing:tabular;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:612.0pt 792.0pt;
margin:72.0pt 72.0pt 72.0pt 72.0pt;}
div.WordSection1
{page:WordSection1;}
@list l0
{mso-list-id:1575503882;
mso-list-type:hybrid;
mso-list-template-ids:-999883724 998793852 67698691 67698693 67698689 67698691 67698693 67698689 67698691 67698693;}
@list l0:level1
{mso-level-start-at:0;
mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;
mso-fareast-font-family:Calibri;
mso-bidi-font-family:"Times New Roman";}
@list l0:level2
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level3
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level4
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level5
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level6
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
@list l0:level7
{mso-level-number-format:bullet;
mso-level-text:\F0B7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Symbol;}
@list l0:level8
{mso-level-number-format:bullet;
mso-level-text:o;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:"Courier New";}
@list l0:level9
{mso-level-number-format:bullet;
mso-level-text:\F0A7;
mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-18.0pt;
font-family:Wingdings;}
ol
{margin-bottom:0cm;}
ul
{margin-bottom:0cm;}
--></style><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" lang="EN-AU">Hi folks,</span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">We have two multiple compound fields: “creators” and “editors”, with subfields:</span></p><p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">name (type=name)</span></p><p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">id (type=text)</span></p><p class="MsoListParagraph" style="text-indent:-18.0pt;mso-list:l0 level1 lfo1"><span style="font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"><span style="mso-list:Ignore">·<span style="font:7.0pt "Times New Roman""> </span></span></span><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">… etc.</span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">The ids are sparsely assigned (used to identify contributors associated with our institution.)</span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">We also have a view “person”, with a single menu:</span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> allow_null => 0,<br> menus => [{</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> fields => [ "creators_id", "editors_id" ],</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> new_column_at => [1, 1],</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> mode => "sections",</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> open_first_section => 1,</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> group_range_function => "EPrints::Update::Views::cluster_ranges_30",</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> grouping_function => "EPrints::Update::Views::group_by_a_to_z",</span></p><p class="MsoNormal"><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> }],</span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">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></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">I tracked through the code and found that it’s generating the correct UNION statement (effectively: </span><span style="font-size:10.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">select from eprint_creators_id where creators_id!='' UNION select from eprint_editors_id where editors_id!=''</span><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">), however for each field it’s then wrapping the union in a distinctby (</span><span style="font-size:9.0pt;font-family:"Courier New";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">select creators_id from (UNION); select editors_id from (UNION)</span><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">). 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></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">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></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU"> </span></p><p class="MsoNormal"><span style="font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular" lang="EN-AU">Cheers</span></p><p class="MsoNormal"><span style="font-size:6.0pt;font-family:"Verdana","sans-serif";color:#003366" lang="EN-AU">-- </span></p><p class="MsoNormal" style="text-autospace:none"><b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">Matthew</span></b><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> <b>Kerwin</b> |</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">Senior</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">Web</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">Developer</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">|</span><span style="font-size:10.0pt;font-family:"MS Gothic";color:#F4F4F4" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"><a href="https://wiki.qut.edu.au/display/lib/Digital+Repository+Team" title="Digital Repository Team" target="_blank"><span style="color:#7A7A7A;text-decoration:none">Applications</span><span style="color:#7A7A7A;text-decoration:none"> </span><span style="color:#7A7A7A;text-decoration:none">&</span><span style="color:#7A7A7A;text-decoration:none"> </span><span style="color:#7A7A7A;text-decoration:none">Development</span><span style="color:#7A7A7A;text-decoration:none"> </span><span style="color:#7A7A7A;text-decoration:none">Team</span></a></span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">| Library</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">eServices</span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU"> </span><span style="font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">| Queensland University of Technology | Level 3, R Block, Kelvin Grove | <u><a href="mailto:matthew.kerwin@qut.edu.au" target="_blank"><u><span style="color:#7A7A7A">matthew.kerwin@qut.edu.au</span></u></a></u> | </span><span style="font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7A7A7A" lang="EN-AU">CRICOS No 00213J</span></p><p class="MsoNormal"><span lang="EN-AU"> </span></p></div><br>*** Options: http://mailman.ecs.soton.ac.uk/mailman/listinfo/eprints-tech<br>*** Archive: http://www.eprints.org/tech.php/<br>*** EPrints community wiki: http://wiki.eprints.org/<br>*** EPrints developers Forum: http://forum.eprints.org/<br></blockquote><br></div></body></html>