[Download-List] How To Retrieve The Record Number For A Multivalued Field

Small, Eric esmall at chapman.edu
Wed Apr 23 12:01:56 EDT 2014


There is no internal value that can be accessed to get the position within the multivalued field STC.STATUS.

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.

The dates and the why it was entered will be out of order. I suggest you don’t explode on this field at all.


LIST STUDENT.ACAD.CRED   BY.EXP.DSND STC.STATUS STC.STATUS STC.STATUS.DATE STC.S
TATUS.TIME  EVAL "DCOUNT(STC.STATUS, at VM)" COL.HDG 'POS' 08:57:24 Apr 23 2014 1
STUDENT.ACAD.CRED Status......... Status Date Status Time POS............

4454891           X                  12/15/08     05:36PM
4454891           N                  11/19/08     07:54AM
4454891           N                  01/01/09     09:26PM 3
3 records listed

Eric Small
Technical Analyst
Information Systems and Technology
Chapman University
714/744-7852
esmall at chapman.edu<mailto:esmall at chapman.edu>

IS&T WILL NEVER ASK FOR YOUR PASSWORD - DO NOT SHARE YOUR PASSWORD WITH OTHERS!
"If a child cannot learn the way we teach him, we had better teach him the way he learns."




From: download-list-bounces at cedarville.edu [mailto:download-list-bounces at cedarville.edu] On Behalf Of Keith Wiggans
Sent: Wednesday, April 23, 2014 8:21 AM
To: download-list at cedarville.edu
Cc: Aaron Thomason
Subject: [Download-List] How To Retrieve The Record Number For A Multivalued Field

We are using the query below to retrieve student registration records expanded by status.

SELECT STUDENT.ACAD.CRED WITH STC.ACAD.LEVEL = 'UG' REQUIRE.SELECT
DOWNLOAD STUDENT.ACAD.CRED \
@ID \
BY.EXP.DSND STC.STATUS STC.STATUS \
STC.STATUS.DATE \
STC.STATUS.TIME \
STC.TERM \

Is there a way to extract the record number for the row, and the sequence number for the status?
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?
Sincerely,

Keith Wiggans Systems Engineer zogotech Toll-free: 888.221.6372 x 814 | Austin: 214.774.4780 x 814 | Fax: 512-469-6306
Email: kwiggans at zogotech.com<mailto:kwiggans at zogotech.com> | Web: zogotech.com<http://zogotech.com>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.cedarville.edu/pipermail/download-list/attachments/20140423/c5b9046c/attachment.html>


More information about the download-list mailing list