Jeff, First make sure these dictionary items are properly associated. Second use WHEN with the ASD keyword.
Example: "list order-log WHEN ASD(action="pck" and act.date="10/11/05") id.supp hdr.supp col.hdr.supp count.sup @id fmt "132l"" Thank you, David A. Green DAG Consulting (480) 813-1725 www.dagconsulting.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Jeff Powell Sent: Tuesday, October 11, 2005 6:02 AM To: u2 users group 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 [email protected] To unsubscribe please visit http://listserver.u2ug.org/ ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
