<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 12 (filtered medium)">
<style>
<!--
/* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 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;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
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;}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
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>I have a resource node type that references the author(s) of
the post via a node reference CCK field. The authors are not necessarily
still living or using the site so they are just an author node type that has
nothing to do with Drupal users. We want to be able to sort the resources
by authors last name that is stored in the node for the author. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Right now the node reference is based on title which is a concatenation
of the title, first name, last name and suffix fields so it would be hard to
write a regular expression to do this off of the title. We have examples of
authors with and without middle names for example. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I was thinking I could just create a relationship and then
sort on the relationship but I don’t see this as an option in views. <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Thanks,<o:p></o:p></p>
<p class=MsoNormal>Steve <o:p></o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#1F497D'>Steve
Kessler <o:p></o:p></span></p>
<p class=MsoNormal><b><span style='font-family:"Tahoma","sans-serif";
color:#486E95'>Denver DataMan <o:p></o:p></span></b></p>
<p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#1F497D'>303-587-4428
<o:p></o:p></span></p>
<p class=MsoNormal><span style='font-family:"Tahoma","sans-serif";color:#1F497D'><a
href="http://www.denverdataman.com/denver-dataman-e-newsletter-signup"><span
style='color:blue'>Sign up for the Denver DataMan Free eNewslettter</span></a><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><span style='color:#486E95'>"Getting the <b><i>right
information</i></b>, to the <b><i>right people</i></b>, at the <b><i>right time</i></b>"</span><span
style='color:#486E95'><o:p></o:p></span></p>
<p class=MsoNormal><o:p> </o:p></p>
</div>
</body>
</html>