<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)">
<style><!--
/* Font Definitions */
@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:"Comic Sans MS";
panose-1:3 15 7 2 3 3 2 2 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","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;
mso-margin-top-alt:auto;
margin-right:0in;
mso-margin-bottom-alt:auto;
margin-left:0in;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
span.EmailStyle18
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@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"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">There is no internal value that can be accessed to get the position within the multivalued field STC.STATUS.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Also your BY.EXP and BY.EXP.DSND will not work either because it will sort based on the STATUS VALUE in the field. See my example below.
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">The dates and the why it was entered will be out of order. I suggest you don’t explode on this field at all.<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">LIST STUDENT.ACAD.CRED BY.EXP.DSND STC.STATUS STC.STATUS STC.STATUS.DATE STC.S<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">TATUS.TIME EVAL "DCOUNT(STC.STATUS,@VM)" COL.HDG 'POS' 08:57:24 Apr 23 2014 1
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">STUDENT.ACAD.CRED Status......... Status Date Status Time POS............
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"> <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">4454891 X 12/15/08 05:36PM
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">4454891 N 11/19/08 07:54AM
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">4454891 N 01/01/09 09:26PM 3
<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">3 records listed <o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060">Eric Small</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060">Technical Analyst<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060">Information Systems and Technology</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060">Chapman University<o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060">714/744-7852</span><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#002060"><o:p></o:p></span></p>
<p class="MsoNormal"><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#002060"><a href="mailto:esmall@chapman.edu" title="mailto:esmall@chapman.edu"><span style="color:#1F497D">esmall@chapman.edu</span></a><o:p></o:p></span></p>
<p class="MsoNormal"><b><i><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#C00000"><o:p> </o:p></span></i></b></p>
<p class="MsoNormal"><b><i><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#C00000">IS&T WILL NEVER ASK FOR YOUR PASSWORD - DO NOT SHARE YOUR PASSWORD WITH OTHERS!<o:p></o:p></span></i></b></p>
<p class="MsoNormal"><i><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:red">"If a child cannot learn the way we teach him, we had better teach him the way he learns."</span></i><span style="font-size:10.0pt;font-family:"Comic Sans MS";color:red">
</span><u><span style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:red"><o:p></o:p></span></u></p>
<p class="MsoNormal"><b><i><span style="font-size:11.0pt;font-family:"Arial","sans-serif";color:#C00000"><o:p> </o:p></span></i></b></p>
<p class="MsoNormal"><u><span style="font-size:10.0pt;font-family:"Calibri","sans-serif";color:red"><o:p><span style="text-decoration:none"> </span></o:p></span></u></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><span style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<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""> download-list-bounces@cedarville.edu [mailto:download-list-bounces@cedarville.edu]
<b>On Behalf Of </b>Keith Wiggans<br>
<b>Sent:</b> Wednesday, April 23, 2014 8:21 AM<br>
<b>To:</b> download-list@cedarville.edu<br>
<b>Cc:</b> Aaron Thomason<br>
<b>Subject:</b> [Download-List] How To Retrieve The Record Number For A Multivalued Field<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<div>
<p class="MsoNormal">We are using the query below to retrieve student registration records expanded by status.<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<blockquote style="border:none;border-left:solid #CCCCCC 1.0pt;padding:0in 0in 0in 6.0pt;margin-left:4.8pt;margin-right:0in">
<p class="MsoNormal">SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL = 'UG' REQUIRE.SELECT<br>
DOWNLOAD STUDENT.ACAD.CRED \<br>
@ID \<br>
<b>BY.EXP.DSND</b> STC.STATUS STC.STATUS \<br>
STC.STATUS.DATE \<br>
STC.STATUS.TIME \<br>
STC.TERM \<o:p></o:p></p>
</blockquote>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<p class="MsoNormal">Is there a way to extract the record number for the row, and the sequence number for the status?<o:p></o:p></p>
<div>
<p class="MsoNormal">For example, Keith added, dropped and added a course. Is there a numeric sequence that corresponds with each Add, Drop, Add entry, and how do we access it?<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Sincerely,<br clear="all">
<o:p></o:p></p>
<div>
<div>
<p><b><span style="font-family:"Arial","sans-serif";color:#222222;background:white">Keith Wiggans
</span></b><b><span style="font-size:10.0pt;font-family:"Arial","sans-serif";color:#888888;background:white">Systems Engineer</span></b><span style="font-family:"Arial","sans-serif";color:#929497;background:white">
</span><b><span style="font-family:"Arial","sans-serif";color:#4779BC;background:white">zogo</span></b><span style="font-family:"Arial","sans-serif";color:#999999;background:white">tech
</span><span style="color:#999999">Toll-free</span>: 888.221.6372 x 814 | <span style="color:#999999">Austin</span>: 214.774.4780 x 814 | <span style="color:#999999">Fax: </span>512-469-6306<br>
<span style="color:#999999">Email</span>: <a href="mailto:kwiggans@zogotech.com" target="_blank">kwiggans@zogotech.com</a> | <span style="color:#999999">Web</span>: <a href="http://zogotech.com" target="_blank">zogotech.com</a><o:p></o:p></p>
</div>
</div>
</div>
</div>
</div>
</body>
</html>