This is a classic MV situation that is over 25 years old. I don't know the platform and if it supports associated fields. But, traditionally, selects against 2 fields are often taken as 2 separate selects.
The classic repair is to concatenate the requested pair into one dict item and select it as follows: ED DICT ORDER.LOG COMBO 002 ACTION:ACT.DATE or to the effect. Insure ACT.DATE is oconv'd D2/ Then you would select ORDER.LOG WITH COMBO = "PCK10/15/05" My 1 cent. Mark Johnson P.S. Is this RESULTS. Nice to see it's still around. ----- Original Message ----- From: "Jeff Powell" <[EMAIL PROTECTED]> To: "u2 users group" <u2-users@listserver.u2ug.org> Sent: Tuesday, October 11, 2005 9:02 AM Subject: [U2] help with multivalue and when > I am querying a file with multivalued fields but I am not getting a > precise enough selection. I want to find only those records where the > multivalues for two separate fields meet the criteria within the same > index. > > The file is the order-log file. There is only one record for each order > number but within that record there is an activity log stored in > multivalued fields. > > My desire is to construct (using uniobjects for java) a list command > that returns a list of ids where the transaction matches. In this case I > want to see only those records where action = PCK and act.date = > (today). > > Here is my query: > "list order-log when action="pck" and when act.date="10/11/05" id.supp > hdr.supp col.hdr.supp count.sup @id fmt "132l"" > > What I get as a result of this is a record where there is a action of > PCK and there is a act.date of 10/11/05 but these are not the record. > > Here is sample of one of those records. > > LIST ORDER-LOG "100TU093370" ACTION ACT.DATE ACT.TIME REF.NUM 07:44:50 > Oct 11 2005 1 > ORDER-LOG. Code Act Date Time Reference Number > > 100TU09337 C 09/09/05 10:37 CALL IN ORDER > 0 > FUT 09/13/05 18:17 D3660RFBLMSS > FUT 09/19/05 18:16 D2.5X18STUD > FUT 09/21/05 18:37 D3660NASBRGMSS > FUT 09/21/05 18:37 TDW3660BLKIT > ALC 10/03/05 09:41 TDW3660BLKIT > PCK 10/04/05 09:23 TU093370-1 Whse TUL > SAV 10/11/05 06:52 TU093370-1 No Update Through RCE > PAK 10/11/05 06:52 TU093370-1 > 1 record listed > > As you can see the PCK occurred on 10/04 and the SAV occurred on 10/11. > I need a list of records where there is a PCK on 10/11. > > Any suggestions? > > Thanks. > > Jeff > ------- > u2-users mailing list > u2-users@listserver.u2ug.org > To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list u2-users@listserver.u2ug.org To unsubscribe please visit http://listserver.u2ug.org/
