Could you post the exact statement you're using with the WHEN clause, a
and also the contents of the DICT items?
I suspect one or more of them is not actually setup as a multivalued field
-----Original Message-----
From: Hilk, Brandon <brandon.h...@iqor.com>
To: U2 Users List <u2-users@listserver.u2ug.org>
Sent: Tue, Nov 19, 2013 8:29 am
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
