I would like to be able to return a list of only multivalues that match a
criteria, rather than all multivalues of an item that contains a match in
any of the multivalues.
Example:
On the INVENTORY file, the record key is ITEM. PALLETS, PALLET.QTYS, and
PALLET.LOCS are all multivalue fields on the record.
SORT INVENTORY *BY-EXP PALLET.LOCS* ITEM PALLETS TOTAL PALLET.Q
TYS PALLET.LOCS *WITH PALLET.LOCS = SPKM22*
Returns:
INVENTORY..... ITEM...... PALLETS... QTYS. LOC.....
1101660 1101660 02107528 20 SPKM11
1101660 1101660 02107523 20 SPKM13
1101660 1101660 02107517 20 SPKM21
*1101660 1101660 02100266 20 SPKM22*
1101660 1101660 02107516 20 SPKM23
1101660 1101660 02107521 20 SPKM31
1101660 1101660 02107530 20 SPKM32
1101660 1101660 02107533 20 SPKM33
=====
*** 160
I would like it to return only this:
INVENTORY..... ITEM...... PALLETS... QTYS. LOC.....
1101660 1101660 02100266 20 SPKM22
=====
*** 20
Is there a way to do this?
--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
To post, send email to [email protected]
To unsubscribe, send email to [email protected]
For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
---
You received this message because you are subscribed to the Google Groups
"jBASE" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To view this discussion on the web visit
https://groups.google.com/d/msgid/jbase/CAAEHHzhQfWe6nM%3Dkg2s9N5425xc_To0VF4Ocx%2BTA%2BHjrt7XZ5w%40mail.gmail.com.
