OOPS, meant field 7, not field 6.

George

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of George Gallen
Sent: Tuesday, November 19, 2013 11:35 AM
To: U2 Users List
Subject: Re: [U2] Simple question - selecting and listing records

I'm assuming you have multiple fields which are tied together that are all 
multivalued?
If so, make sure you field 6 in the dict all have the same linkcode otherwise 
WHEN
Will not be to pull the associated fields.

George

-----Original Message-----
From: u2-users-boun...@listserver.u2ug.org 
[mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Hilk, Brandon
Sent: Tuesday, November 19, 2013 11:29 AM
To: U2 Users List
Subject: [U2] Simple question - selecting and listing records

Hello, I have a quick question regarding listing multivalued fields. I
hope the formatting is retained on this email so my example doesn't get
confusing. 

 

This file is structured for multiple credit card entries under one @id.
How can I alter my LIST command to only show the entries for the date
specified? I tried using "when" in both the LIST and SELECT statements
but didn't get the results I was looking for. I feel like I'm missing
something really basic. Thanks in advance.

 

 

}SELECT CREDITCARD.FILE WITH PMT.DATE EQ "11/19/2013"    

303 record(s) selected to SELECT list #0.                

 

}}LIST CREDITCARD.FILE PACKET STATUS TRACKING.ID PMT.DATE

 

CREDITCARD.FILE PACKET.. STATUS......... TRACKING ID......... PMT DATE..

                                                                        

52152162        52152162 APPROVED        25D6TGCD             11/19/2013

                52152162                                      12/31/2013

                52152162                                      01/31/2014

                52152162                                      02/28/2014

                52152162                                      03/31/2014

                52152162                                      04/30/2014

                52152162                                      05/30/2014

                52152162                                      06/30/2014

                52152162                                      07/31/2014

                52152162                                      08/29/2014

                52152162                                      09/30/2014

                52152162                                      10/31/2014

56436495        56436495 APPROVED        259l17j2             02/18/2013

                56436495 APPROVED        25a0hfg7             03/18/2013

                56436495 APPROVED        25adf4bt             04/18/2013

                56436495 APPROVED        25ar1ofv             05/20/2013

                56436495 APPROVED        25b7a92o             06/18/2013

                56436495 APPROVED        25bk0tpv             07/18/2013

                56436495 APPROVED        25c11rl1             08/19/2013

 

_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users

Reply via email to