SORT to return only some multivalues?

62 views
Skip to first unread message

Joshua Camacho

unread,
Oct 13, 2021, 8:56:53 AM10/13/21
to jb...@googlegroups.com
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?

Peter Falson

unread,
Oct 13, 2021, 10:13:59 AM10/13/21
to jb...@googlegroups.com
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 <wyc...@gmail.com> wrote:


--
--
IMPORTANT: T24/Globus posts are no longer accepted on this forum.
 
To post, send email to jB...@googlegroups.com
To unsubscribe, send email to jBASE-un...@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+un...@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.

Mark Hogden

unread,
Oct 13, 2021, 10:20:15 AM10/13/21
to jb...@googlegroups.com
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 <wyc...@gmail.com> wrote:


--

Joshua Camacho

unread,
Oct 14, 2021, 10:52:38 AM10/14/21
to jb...@googlegroups.com
Thanks guys! This worked for me.


To view this discussion on the web visit https://groups.google.com/d/msgid/jbase/0D17771A-C27B-487F-8620-339E02CD3AEC%40proman.com.
Reply all
Reply to author
Forward
0 new messages