Re: JSON Questions

["Art Tostaine, Jr." <atostaine@xxxxxxxxx>]

Thank you Tim.  The select doesn't like the colon after Deceasedds, I'm
trying to figure out the syntax.

On Tue, Jan 7, 2020 at 11:09 AM Tim Fathers <X700-IX2J@xxxxxxxxxxx> wrote:

> I don't have access to a machine right now with SQL/JSON support so this
> might not work as is, but I think you will need a JSON object inside and
> outside the array and an array aggregate function, something like this:
>
> select json_object(
>   "deceaseds":
>   json_arrayagg(
>     json_object(
>       "ExternalId": Nameid,
>       "Prefix": trim(PRFXDESC),
>       "FirstName": trim(firstname),
>       "MiddleName": trim(middlenme),
>       "LastName": trim(lastname),
>       "Suffix": trim(SUFFIXDES),
>       "BirthDate": trim(BIRTHDATE),
>     )
>   )
> )
> from namintprp
>
> Tim.