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

Reply via email to