• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

UBE, append data selection, BC field = _LIST_

Frosty the Coder

Legendary Poster
I know that I can append a single value
to data selection.

How would I append where the BC field = LIST?

Would I construct a _long_ variable and
do concats? What if my BC field is numeric?

This is on xe/sp13

Thanks for any/all help, real or imagined.

Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13
 

Zoltan_Gyimesi

Legendary Poster
Hi Gene,

Where do you want to do it? In a Batch Version or inside the template, i n Event Rule?

In any case, try the following:
1.) Select "Literal" on Right Operand
2.) Select the "List of values" tab
3.) Enter one value from your list into the field
4.) Press the blue plus icon (Add)
5.) Repeat 3,4 for all of the values in your list
6.) Press OK

Does it work at your site?

Zoltán


B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Frosty the Coder

Legendary Poster
No, I'm not getting the LIST OF VALUES tab,
I'm only getting SINGLE VALUE. This is both
at the client site and on my notebook.

Here are the specifics of what I'd _LIKE_ to
be able to do.

R42520 (pick slip print), a custom version
Pick Slip Detail Lines section
INITIALIZE ER
Append data selection
BC CARRIER = List

When I set ITEM1 to BC CARRIER and click on
LITERAL for ITEM2 I only get "Single Value".

Further, I'd like to be able to read a file/udc/whatever
so that I don't have to hardcode the actual ab#s.

I can handle the loop to read the file, but how
would I set the values w/in the LIST OF VALUES
(if I got it) to be from my file? I _could_
set the values in the List (again IF I can
get it to show) to be RV_AB1, RV_AB2, RV_AB3, ...
but that would limit the #of values to as
many RVs as I set up. I'd like to have it
more open ended.

BTW (by the way) - in THIS case, the client has opted on
keying the ab#s into the data selection as
there are less than a dozen. It's more for
_my_ knowledge as it would seem that there is
some making it work.

TIA, and welcome back for holiday. It was
_odd_ not seeing my inbox peppered w/your name.....

Gene

Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13
 

Zoltan_Gyimesi

Legendary Poster
Hi Gene,

Ooops! I have re-read your post and went into RDA and called the SetUserSelection systemfunction and detected that the Range and the List tabs arwe missing when I select Literal (only Single Value tab apperas) while they appears when I set the selection at Section or Version level. The funny is that the plus (add) icon exists but grayed out.

I tried it on B7331 SP6, XE SP 13 an SP14. The situation are the same.
Could it be a SP related issue? //Hey, Listers using later SP level(s), what is the situation there?// Have you checked the KG for it already?

At last a silly hint (half cent):
1.) Create a dummy conditional section with the same business view.
2.) Define your selection at section level for this section (here you can access the Lis tab).
3.) Use the "Use Data Sel/Seq from a Section" systemfunction in your original section.

I never used it, so I didn't know that does it append or don't but I really hope, you can use it somehow for your situation.

Please, let us know your results. I am very curious to it. Thanks.

Good luck,
Zoltán











B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 
Discover how to build no-code data integrations and business process automations.

Frosty the Coder

Legendary Poster
OK - help desk says it can't be done.
SAR# 4787613 is status 04 - "Returned redesign not planned".

I suppose that (in future instances) I _could_ set up a
WHOLE BUNCH of RVs, populate them, and append them as SINGLE
LINES to the data selection.

Anyway, in this case, there were few enough that hardcode
was acceptable.

Thanks for looking.

Gene

Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13
 

Zoltan_Gyimesi

Legendary Poster
Hi Gene,

Really very sad to read: status 04 - "Returned redesign not planned".
I just would like to interest, have you tried my suggestion setting up selection in a dummy conditional section with the same BSVW and using "Use Data Sel/Seq from a Section" systemfunction somehow, or it isn't feasible in your concrete situation?

Zoltán

B7332 SP11, ESU 4116422, Intel NT4, SQL 7 SP1
(working with B7321, B7331, XE too)
 

Frosty the Coder

Legendary Poster
No, I didn't get the opportunity.

The client, reasonably, wants cost effective solutions,
and in this case, that's hardcode.

Should the need for this arise again, I will setup
the custom section as you suggest and give it a whirl.
I don't see why it wouldn't work though.

Thanks, again, for all your help - past, present, future, real, or
imagined.

Gene



Gene Piekarski, Jr

AS/400, B733, SP11.2, NT client
AS/400, B733, SP14, W2000 client
XE, SP13
 
Top