Use the value limiter along with the BY-EXP https://docs.zumasys.com/jbase/jql/jql-keyword-cross-reference/by-exp/#by-exp-by-exp
Sent from my iPhone > On Oct 13, 2021, at 5:56 AM, 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/9298550F-2162-4343-AC02-66E45A0D0401%40gmail.com.