00:17:35 Becky Owens: I am familiar. 00:18:32 Lauren Schiller: We do use json extraction a lot but there are places where I feel like I’m doing it by rote rather than understanding, so I appreciate the overview 00:18:42 Sharon Markus: Reacted to "We do use json extra..." with πŸ‘ 00:22:41 Sharon Markus: You can find basic descriptions of these different types of tables Joanne is discussing in the Metadb documentation. You'll find this information in the various sections on tables. There is also a "JSON queries" section with some information on data array extraction." https://metadb.dev/metadb/doc/ 00:22:55 Sharon Markus: Reacted to "I am familiar." with πŸ‘ 00:35:09 Lauren Schiller: I was having trouble with an query where I needed to extract data from multiple arrays from the same table, but using multiple cross joins ended up only giving me results where there was data in all three arrays and not returning null values for the later extractions, so ended up doing LEFT JOIN LATERAL for the later extractions but kept the cross join on the first one because I did want to limit the data to things that did have content in that array. 00:36:39 Sharon Markus: Reacted to "I was having trouble..." with πŸ‘ 00:37:51 Lauren Schiller: Yup, it was a query I was doing on inventory 00:38:06 Sharon Markus: Reacted to "Yup, it was a query ..." with πŸ‘ 00:40:42 Vandana Shah: This is incredibly helpful, unfortunately I have to leave now and I'm very thankful to Joanne for the documentation. 00:41:20 Sharon Markus: Reacted to "This is incredibly h..." with πŸ’― 00:47:41 Juan Moreno: Can we have the link to the webpage? 00:47:51 Erin Block: https://folio-org.atlassian.net/wiki/spaces/RPT/pages/1724645378/Extracting+Fields+from+Metadb+JSON+arrays 00:47:58 Juan Moreno: Reacted to "https://folio-org.at..." with πŸ‘ 00:47:59 Mauricio Resendez: Reacted to "https://folio-org.at..." with πŸ‘ 00:48:10 Lauren Schiller: I was mostly wanting to see if other people were using the lateral joins (but not cross joins) to do multiple array extractions or if people think it’s better to do the nested extractions? 00:48:29 Lauren Schiller: It can wait until Joanne is done though 00:49:24 Lauren Schiller: It didn’t occur to me to try the nested, so I can see if it’s faster or not 00:56:17 Erin Block: This has been incredibly helpful. Thank you so much Joanne! 00:56:29 Juan Moreno: Thank you for sharing cheat sheet and all the information! 00:56:38 Lauren Schiller: It did look like if you do a left join lateral instead of a cross join lateral then it will return the null values, but I’m not sure I understand how lateral joins work 00:57:35 Lauren Schiller: I need to troubleshoot my mic I think 00:57:40 Lauren Schiller: I was unmute 00:57:43 Lauren Schiller: unmuted 01:02:17 Jean Pajerek: Thanks for this presentation, Joanne! 01:02:23 Steven Pryor (he/him/his): Thank you! 01:02:24 Kimberly Pamplin: Thank you so much! 01:02:24 Lauren Schiller: Yes, thank you! 01:02:31 Mauricio Resendez: Thank you! 01:02:39 Lauren Schiller: (I also feel like I’m doing this as incantations sometimes)