On Mon, Dec 7, 2020 at 3:12 PM Steve Baldwin <steve.bald...@gmail.com> 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>* >> ken.tan...@agency-software.org >> (253) 245-3801 >> >> Subscribe to the mailing list >> <agency-general-requ...@lists.sourceforge.net?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>* ken.tan...@agency-software.org (253) 245-3801 Subscribe to the mailing list <agency-general-requ...@lists.sourceforge.net?body=subscribe> to learn more about AGENCY or follow the discussion.