Re: Help with building a nested JSON command

Thank you all.
I have it working.
Darryl.

On Tue, Aug 12, 2025 at 2:06 PM Daniel Gross <daniel@xxxxxxxx> wrote:

Am 12.08.2025 um 19:35 schrieb a4g atl <a4ginatl2@xxxxxxxxx>:

The closing param is on my statement but is not shown here. Trying to

configure json_array.

That should be easy:

'ErrorUsers' value json_array (
case ke1usr when '' then null else ke1usr end,
case ke2usr when '' then null else ke2usr end,
case ke3usr when '' then null else ke3usr end,
case ke4usr when '' then null else ke4usr end,
case ke5usr when '' then null else ke5usr end
),
...

I assume that you only want the user fields that are not blank.

HTH
Daniel
--
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: https://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
Before posting, please take a moment to review the archives
at https://archive.midrange.com/midrange-l.

Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
questions.