On Mon, Dec 7, 2020 at 3:12 PM Steve Baldwin <[email protected]> wrote:
> Try: > > select _message_body->'Charges'->>'Name' from ... > > Hi Steve. I tried that again, and that returns a NULL value for me. I believe that is because Charges holds an array of two elements, each of which has a Name element. Though my terminology might not be correct! Cheers, Ken >> >> >> >> >> -- >> AGENCY Software >> A Free Software data system >> By and for non-profits >> *http://agency-software.org/ <http://agency-software.org/>* >> *https://demo.agency-software.org/client >> <https://demo.agency-software.org/client>* >> [email protected] >> (253) 245-3801 >> >> Subscribe to the mailing list >> <[email protected]?body=subscribe> to >> learn more about AGENCY or >> follow the discussion. >> > -- AGENCY Software A Free Software data system By and for non-profits *http://agency-software.org/ <http://agency-software.org/>* *https://demo.agency-software.org/client <https://demo.agency-software.org/client>* [email protected] (253) 245-3801 Subscribe to the mailing list <[email protected]?body=subscribe> to learn more about AGENCY or follow the discussion.
