Thanks guys! This worked for me. Joshua Camacho [email protected] (773) 988-0846
On Wed, Oct 13, 2021 at 9:20 AM Mark Hogden <[email protected]> wrote: > 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 <[email protected]> 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 [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 > <https://groups.google.com/d/msgid/jbase/CAAEHHzhQfWe6nM%3Dkg2s9N5425xc_To0VF4Ocx%2BTA%2BHjrt7XZ5w%40mail.gmail.com?utm_medium=email&utm_source=footer> > . > > -- > -- > 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/0D17771A-C27B-487F-8620-339E02CD3AEC%40proman.com > <https://groups.google.com/d/msgid/jbase/0D17771A-C27B-487F-8620-339E02CD3AEC%40proman.com?utm_medium=email&utm_source=footer> > . > -- -- 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/CAAEHHzhF%2Brd10FdR%2Bz_xD4iRJwUv9atiV10vhnV%3DZ8o6DrGgnQ%40mail.gmail.com.
