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

[Small, Eric]

You probably need to write a unidata program not sure you can get what you want using the,download,program.

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!
Sent from my iPad

On Apr 28, 2014, at 12:53 PM, "Aaron Thomason" <athomason at apps.zogotech.com<mailto:athomason at apps.zogotech.com>> wrote:

How do I get all the values of STUDENT.ACAD.CRED, STC.STATUS, STC.STATUS.DATE, and STC.STATUS.TIME in a format similar to:

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

When I use MV.ORIENTATION VERTICAL, it does not group the output correctly.

Aaron Thomason
Systems Engineer
zogotech
Toll-free: 888.221.6372 x.809 | Dallas: 214.774.4780 x.809
Fax: 512-469-6306
Email: athomason at zogotech.com<mailto:athomason at zogotech.com> | Web: zogotech.com<http://www.zogotech.com/>

From: Small, Eric [mailto:esmall at chapman.edu]
Sent: Wednesday, April 23, 2014 11:02 AM
To: support at zogotech.com<mailto:support at zogotech.com>; Cedarville DOWNLOAD Users
Cc: Aaron Thomason
Subject: RE: [Download-List] How To Retrieve The Record Number For A Multivalued Field

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> [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<mailto: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>