Print limiting should work, but sometimes the alignment doesn’t look great.
> SORT INVENTORY BY-EXP PALLET.LOCS “SPKM22” ITEM PALLETS TOTAL PALLET.Q > TYS PALLET.LOCS “SPKM22” WITH PALLET.LOCS = SPKM22 > On Oct 13, 2021, at 05:57, Joshua Camacho <wyck...@gmail.com> wrote: > > > 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 jBASE@googlegroups.com > To unsubscribe, send email to jbase-unsubscr...@googlegroups.com > 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 jbase+unsubscr...@googlegroups.com. > To view this discussion on the web visit > https://groups.google.com/d/msgid/jbase/CAAEHHzhQfWe6nM%3Dkg2s9N5425xc_To0VF4Ocx%2BTA%2BHjrt7XZ5w%40mail.gmail.com. -- -- IMPORTANT: T24/Globus posts are no longer accepted on this forum. To post, send email to jBASE@googlegroups.com To unsubscribe, send email to jbase-unsubscr...@googlegroups.com 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 jbase+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/0D17771A-C27B-487F-8620-339E02CD3AEC%40proman.com.