<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=us-ascii"><meta name=Generator content="Microsoft Word 14 (filtered medium)"><style><!--
/* Font Definitions */
@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;}
/* 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.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 Definitions */
@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><!--[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 lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>Hi folks,<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'><o:p>&nbsp;</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: &#8220;creators&#8221; and &#8220;editors&#8221;, with subfields:<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-AU style='font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'><span style='mso-list:Ignore'>&middot;<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]><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)<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-AU style='font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'><span style='mso-list:Ignore'>&middot;<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]><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)<o:p></o:p></span></p><p class=MsoListParagraph style='text-indent:-18.0pt;mso-list:l0 level1 lfo1'><![if !supportLists]><span lang=EN-AU style='font-family:Symbol;color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'><span style='mso-list:Ignore'>&middot;<span style='font:7.0pt "Times New Roman"'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; </span></span></span><![endif]><span lang=EN-AU style='font-family:"Georgia","serif";color:#003366;mso-ligatures:standardcontextual;mso-number-form:lining;mso-number-spacing:tabular'>&#8230; etc.<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'><o:p>&nbsp;</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.)<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'><o:p>&nbsp;</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 &#8220;person&#8221;, with a single menu:<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'><o:p>&nbsp;</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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; allow_null =&gt; 0,<br>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; menus =&gt; [{<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; fields =&gt; [ &quot;creators_id&quot;, &quot;editors_id&quot; ],<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; new_column_at =&gt; [1, 1],<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; mode =&gt; &quot;sections&quot;,<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; open_first_section =&gt; 1,<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; group_range_function =&gt; &quot;EPrints::Update::Views::cluster_ranges_30&quot;,<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; grouping_function =&gt; &quot;EPrints::Update::Views::group_by_a_to_z&quot;,<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'>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; }],<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'><o:p>&nbsp;</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&#8217;t have an id.<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'><o:p>&nbsp;</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&#8217;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&#8217;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 &#8220;?&#8221; with a link to the user &#8220;NULL.html&#8221; who has several thousand EPrints.<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'><o:p>&nbsp;</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&#8217;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?&nbsp; I have a potential hack ready to get us by, but I&#8217;d prefer something a bit less klugey.<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'><o:p>&nbsp;</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<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'>-- <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'>&nbsp;<b>Kerwin</b>&nbsp;&nbsp;|</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp; </span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>Senior</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp;</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>Web</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp;</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>Developer</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp;&nbsp;</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>|</span><span lang=EN-AU style='font-size:10.0pt;font-family:"MS Gothic";color:#F4F4F4'>&nbsp; </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" title="Digital Repository Team"><span style='color:#7A7A7A;text-decoration:none'>Applications</span><span style='color:#7A7A7A;text-decoration:none'>&nbsp;</span><span style='color:#7A7A7A;text-decoration:none'>&amp;</span><span style='color:#7A7A7A;text-decoration:none'>&nbsp;</span><span style='color:#7A7A7A;text-decoration:none'>Development</span><span style='color:#7A7A7A;text-decoration:none'>&nbsp;</span><span style='color:#7A7A7A;text-decoration:none'>Team</span></a></span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp;&nbsp;</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>|&nbsp; Library</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp;</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>eServices</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>&nbsp;&nbsp;</span><span lang=EN-AU style='font-size:10.0pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>|&nbsp; Queensland&nbsp;University&nbsp;of&nbsp;Technology&nbsp;&nbsp;|&nbsp; Level&nbsp;3,&nbsp;R&nbsp;Block,&nbsp;Kelvin&nbsp;Grove&nbsp;&nbsp;|&nbsp; <u><a href="mailto:matthew.kerwin@qut.edu.au"><u><span style='color:#7A7A7A'>matthew.kerwin@qut.edu.au</span></u></a></u>&nbsp;&nbsp;|&nbsp; </span><span lang=EN-AU style='font-size:7.5pt;font-family:"Verdana","sans-serif";color:#7A7A7A'>CRICOS&nbsp;No&nbsp;00213J<o:p></o:p></span></p><p class=MsoNormal><span lang=EN-AU><o:p>&nbsp;</o:p></span></p></div></body></html>